Page History

...

Expand

title	INVENTORY_AGENT_CLUSTERMEMBERS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key, UNIQUE Key	X	references `INVENTORY_INSTANCES.ID`
AGENT_CLUSTER_ID	NOT NULL	NUMERIC	Foreign Key, UNIQUE Key	X	references `INVENTORY_AGENT_CLUSTERS.ID`
AGENT_INSTANCE_ID	NOT NULL	NUMERIC	Foreign Key, UNIQUE Key	X	references `INVENTORY_AGENT_INSTANCES.ID`
URL	NOT NULL	VARCHAR			agent url
ORDERING	NOT NULL	NUMERIC
`CREATED`	NOT NULL	DATETIME			timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			timestamp of record modification

Expand

title	INVENTORY_AGENT_CLUSTERS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_INSTANCES.ID`
PROCESS_CLASS_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_PROCESS_CLASSES.ID`
SCHEDULING_TYPE	NOT NULL	VARCHAR
NUMBER_OF_AGENTS	NOT NULL	NUMERIC
`CREATED`	NOT NULL	DATETIME			timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			timestamp of record modification

Expand

title	INVENTORY_AGENT_INSTANCES

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_INSTANCES.ID`
OS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_OPERATING_SYSTEMS.ID`
HOSTNAME	NOT NULL	VARCHAR
VERSION	NOT NULL	VARCHAR
URL		VARCHAR		X
STATE		NUMERIC
STARTED_AT		DATETIME	NUMERIC
`CREATED`	NOT NULL	DATETIME			timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			timestamp of record modification

Expand

title	INVENTORY_AGENTAPPLIED_CLUSTERSLOCKS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCEJOB_ID`	NOT NULL	NUMERIC	Foreign KeyKey	X	references `INVENTORY_INSTANCESJOBS.ID`
PROCESS_CLASSLOCK_ID	NOT NULL	NUMERIC	Foreign Key, UNIQUE	X	references `INVENTORY_PROCESS_CLASSESLOCKS.ID`
SCHEDULING_TYPE`CREATED`	NOT NULL	VARCHAR			NUMBER_OF_AGENTS	NOT NULL	NUMERIC	DATETIME	`CREATED`	NOT NULL	DATETIME	timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			timestamp of record modification

...

Expand

title	REPORT_EXECUTION_SUMMARY

CREATE OR REPLACE FUNCTION REPORT_EXECUTION_SUMMARY(start_date DATE, end_date DATE) RETURNS TABLE ( 
    "ID"                    BIGINT,
    "SCHEDULER_ID"          VARCHAR(100),
    "HOSTNAME"              VARCHAR(255), 
    "JOB_CHAIN"             VARCHAR(255), 
    "JOB_NAME"              VARCHAR(255), 
    "JOB_BASENAME"          VARCHAR(100),
    "JOB_CHAIN_BASENAME"    VARCHAR(100),
    "JOB_TITLE"             VARCHAR(255),
    "JOB_CHAIN_TITLE"       VARCHAR(255),
    "CAUSE"                 VARCHAR(100),
    "IS_ACTIVE_CALENDAR"    INT,
    "START_TIME"            TIMESTAMP,
    "END_TIME"              TIMESTAMP,
    "START_DATE"            DATE,
    "END_DATE"              DATE
)

Space shortcuts

Page tree

Versions Compared

Old Version 4

New Version 5

Key