Spacewalk DB Schema - View-RHNENTITLEDSERVERS

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

RHNENTITLEDSERVERS

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
ID	NUMBER(38)	N	NO	NO	NO
ORG_ID	NUMBER(38)	N	NO	NO	NO
DIGITAL_SERVER_ID	VARCHAR2(64)	N	NO	NO	NO
SERVER_ARCH_ID	NUMBER(38)	N	NO	NO	NO
OS	VARCHAR2(64)	N	NO	NO	NO
RELEASE	VARCHAR2(64)	N	NO	NO	NO
NAME	VARCHAR2(128)	Y	NO	NO	NO
DESCRIPTION	VARCHAR2(256)	Y	NO	NO	NO
INFO	VARCHAR2(128)	Y	NO	NO	NO
SECRET	VARCHAR2(64)	N	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select distinct
    S.id,
    S.org_id,
    S.digital_server_id,
    S.server_arch_id,
    S.os,
    S.release,
    S.name,
    S.description,
    S.info,
    S.secret
from
    rhnServerGroup SG,
    rhnServerGroupType SGT,
    rhnServerGroupMembers SGM,
    rhnServer S
where
    S.id = SGM.server_id
and SG.id = SGM.server_group_id
and SGT.label IN ('enterprise_entitled')
and SG.group_type = SGT.id
and SG.org_id = S.org_id