RHNSERVERGROUPMEMBERSHIP
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ORG_ID | NUMBER(38) | N | NO | NO | NO | |
| SERVER_ID | NUMBER(38) | Y | NO | NO | NO | |
| GROUP_ID | NUMBER(38) | N | NO | NO | NO | |
| GROUP_NAME | VARCHAR2(64) | N | NO | NO | NO | |
| GROUP_TYPE | VARCHAR2(32) | Y | NO | NO | NO | |
| CURRENT_MEMBERS | NUMBER(38) | N | NO | NO | NO | |
| MAX_MEMBERS | NUMBER(38) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
SELECT SG.org_id, SGM.server_id, SG.id, SG.name, SGT.label, SG.current_members, SG.max_members
FROM rhnServerGroupType SGT,
rhnServerGroupMembers SGM,
rhnServerGroup SG
WHERE SG.id = SGM.server_group_id(+)
AND SG.group_type = SGT.id(+)