RHNVISSERVERGROUPOVERVIEWLITE
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 org_id,
case when exists (
select 1
from rhnServerGroupOVLiteHelper
where server_group_id = sg.id
and advisory_type = 'Security Advisory'
)
then 1
else 0
end security_errata,
case when exists (
select 1
from rhnServerGroupOVLiteHelper
where server_group_id = sg.id
and advisory_type = 'Bug Fix Advisory'
)
then 1
else 0
end bug_errata,
case when exists (
select 1
from rhnServerGroupOVLiteHelper
where server_group_id = sg.id
and advisory_type = 'Product Enhancement Advisory'
)
then 1
else 0
end enhancement_errata,
sg.id group_id,
sg.name group_name,
( select count(*)
from rhnUserManagedServerGroups umsg
where umsg.server_group_id = sg.id
) group_admins,
( select count(*)
from rhnServerGroupMembers sgm
where sgm.server_group_id = sg.id
) server_count,
0 note_count,
sysdate modified,
max_members max_members
from rhnVisibleServerGroup sg