Spacewalk DB Schema - View-RHNVISIBLESERVERGROUPMEMBERS

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

RHNVISIBLESERVERGROUPMEMBERS

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
SERVER_ID	NUMBER(38)	N	YES	YES	YES
SERVER_GROUP_ID	NUMBER(38)	N	YES	YES	YES
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	YES	YES	YES
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	YES	YES	YES

Query:

Legend: comment string keyword reserved word operator

SELECT SGM.SERVER_ID,SGM.SERVER_GROUP_ID,SGM.CREATED,SGM.MODIFIED
    FROM rhnServerGroup SG,
         rhnServerGroupMembers SGM
   WHERE SGM.server_group_id = SG.id
     AND SG.group_type IS NULL