Spacewalk DB Schema - View-RHNSERVERFEATURESVIEW

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

RHNSERVERFEATURESVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable	Comment
SERVER_ID	NUMBER(38)	N	NO	NO	NO
LABEL	VARCHAR2(32)	N	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select
   distinct
   sgm.server_id,
   f.label
from
   rhnFeature f,
   rhnServerGroupTypeFeature sgtf,
   rhnServerGroupMembers sgm,
   rhnServerGroup sg
where
   sg.id = sgm.server_group_id
   and sgtf.feature_id = f.id
   and sg.group_type = sgtf.server_group_type_id