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.