Spacewalk DB Schema - View-RHNUSERAPPLETOVERVIEW

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

Description Columns Query Constraints Triggers

RHNUSERAPPLETOVERVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
USER_ID	NUMBER(38)	N	NO	NO	NO
SECURITY_COUNT	NUMBER(38)	Y	NO	NO	NO
BUG_COUNT	NUMBER(38)	Y	NO	NO	NO
ENHANCEMENT_COUNT	NUMBER(38)	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

SELECT      USP.user_id,
    	    SUM((SELECT COUNT(*) FROM rhnServerErrataTypeView SEV
	         WHERE SEV.server_id = USP.server_id
	         AND SEV.errata_type = 'Security Advisory')),
    	    SUM((SELECT COUNT(*) FROM rhnServerErrataTypeView SEV
	         WHERE SEV.server_id = USP.server_id
	         AND SEV.errata_type = 'Bug Fix Advisory')),
    	    SUM((SELECT COUNT(*) FROM rhnServerErrataTypeView SEV
	         WHERE SEV.server_id = USP.server_id
	         AND SEV.errata_type = 'Product Enhancement Advisory'))
FROM        rhnUserServerPerms USP
GROUP BY    USP.user_id