RHNVISSERVERGROUPOVERVIEW
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ORG_ID | NUMBER(38) | N | YES | YES | YES | |
| SECURITY_ERRATA | NUMBER(38) | Y | NO | NO | NO | |
| BUG_ERRATA | NUMBER(38) | Y | NO | NO | NO | |
| ENHANCEMENT_ERRATA | NUMBER(38) | Y | NO | NO | NO | |
| GROUP_ID | NUMBER(38) | N | YES | YES | YES | |
| GROUP_NAME | VARCHAR2(64) | N | YES | YES | YES | |
| GROUP_ADMINS | NUMBER(38) | Y | NO | NO | NO | |
| SERVER_COUNT | NUMBER(38) | Y | NO | NO | NO | |
| NOTE_COUNT | NUMBER(38) | Y | NO | NO | NO | |
| MODIFIED | DATE | Y | NO | NO | NO | |
| MAX_MEMBERS | NUMBER(38) | Y | YES | YES | YES | |
Query:
Legend: string keyword reserved word operator
SELECT SG.org_id,
(SELECT COUNT(E.id)
FROM rhnErrata E
WHERE E.advisory_type = 'Security Advisory'
AND EXISTS (SELECT 1 FROM rhnServerNeededPackageCache SNEC, rhnServerGroupMembers SGM
WHERE SGM.server_id = SNEC.server_id
AND SNEC.errata_id = E.id
AND SGM.server_group_id = SG.id)),
(SELECT COUNT(E.id)
FROM rhnErrata E
WHERE E.advisory_type = 'Bug Fix Advisory'
AND EXISTS (SELECT 1 FROM rhnServerNeededPackageCache SNEC, rhnServerGroupMembers SGM
WHERE SGM.server_id = SNEC.server_id
AND SNEC.errata_id = E.id
AND SGM.server_group_id = SG.id)),
(SELECT COUNT(E.id)
FROM rhnErrata E
WHERE E.advisory_type = 'Product Enhancement Advisory'
AND EXISTS (SELECT 1 FROM rhnServerNeededPackageCache SNEC, rhnServerGroupMembers SGM
WHERE SGM.server_id = SNEC.server_id
AND SNEC.errata_id = E.id
AND SGM.server_group_id = SG.id)),
SG.id, SG.name,
(SELECT COUNT(*) FROM rhnUserManagedServerGroups UMSG WHERE UMSG.server_group_id = SG.id),
(SELECT COUNT(*) FROM rhnServerGroupMembers SGM WHERE SGM.server_group_id = SG.id),
0, SYSDATE, MAX_MEMBERS
FROM rhnVisibleServerGroup SG