Spacewalk DB Schema - View-RHNACTIONOVERVIEW

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips

Description Columns Query Constraints Triggers

RHNACTIONOVERVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
ORG_ID	NUMBER(38)	N	YES	YES	YES
ACTION_ID	NUMBER(38)	N	YES	YES	YES
TYPE_ID	NUMBER(38)	N	NO	NO	NO
TYPE_NAME	VARCHAR2(100)	N	NO	NO	NO
NAME	VARCHAR2(128)	Y	YES	YES	YES
SCHEDULER	NUMBER(38)	Y	YES	YES	YES
SCHEDULER_LOGIN	VARCHAR2(64)	Y	NO	NO	NO
EARLIEST_ACTION	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	YES	YES	YES
TOTAL_COUNT	NUMBER(38)	Y	NO	NO	NO
SUCCESSFUL_COUNT	NUMBER(38)	Y	NO	NO	NO
FAILED_COUNT	NUMBER(38)	Y	NO	NO	NO
IN_PROGRESS_COUNT	NUMBER(38)	Y	NO	NO	NO
ARCHIVED	NUMBER(38)	N	YES	YES	YES

Query:

Legend: comment string keyword reserved word operator

SELECT    A.org_id,
	  A.id,
	  AT.id,
	  AT.name,
	  A.name,
	  A.scheduler,
	  U.login,
	  A.earliest_action,
	  (SELECT COUNT(*) FROM rhnServerAction WHERE action_id = A.id),
	  (SELECT COUNT(*) FROM rhnServerAction WHERE action_id = A.id AND status = 2), -- XXX: don''t hard code status here :)
	  (SELECT COUNT(*) FROM rhnServerAction WHERE action_id = A.id AND status = 3),
	  (SELECT COUNT(*) FROM rhnServerAction WHERE action_id = A.id AND status NOT IN (2, 3)),
	  A.archived
FROM
	  rhnActionType AT,
	  rhnAction A
		left outer join
          web_contact U
		on A.scheduler = U.id
WHERE A.action_type = AT.id
ORDER BY  A.earliest_action