Host Groups

Host groups define groups of hosts, wildcard patterns, or both, that match hostnames:

CREATE TABLE hostgrp (
	id INTEGER PRIMARY,
	name TEXT UNIQUE,
	description TEXT,
	disabled INTEGER CHECK(disabled BETWEEN 0 AND 1), -- 0=enabled, 1=disabled
	type CHAR(1) CHECK (type IN ('I','E')), -- I=Internal, E=external
	extinfo TEXT -- external lookup info
);
CREATE TABLE hostlist (
	id INTEGER REFERENCES hostgrp(id),
	host TEXT, -- "glob" wildcard
	PRIMARY KEY(id,host)
);

Each host group has multiple host list entries that specify names and/or wildcards that match both submit and run host names when matched by the role.

A diagram demonstrating that each Host Group has multiple Host List entries.