--  category:  IBM i Services for BRMS
--  description:  Application - BRMS Control Group IFS Entry Views
--  minvrm: V7R3M0
--  last updated: 3/14/2023

--
-- To show ALL IFS control group entries 
--
SELECT *
    FROM QUSRBRM.BRMS_CONTROL_GROUP_IFS_ENTRY;

--
-- To show ALL IFS control group backup items showing IFS included with along with any assigned omits
--
SELECT CONTROL_GROUP,
       SEQUENCE_NUMBER,
       BACKUP_ITEM,
       LIST_OMIT,
       PATH_NAME
    FROM QUSRBRM.BRMS_CONTROL_GROUP_IFS_ENTRY
    ORDER BY CONTROL_GROUP,
             SEQUENCE_NUMBER;

--
-- To show ALL control groups with IFS Omits
--
SELECT CONTROL_GROUP,
       SEQUENCE_NUMBER,
       BACKUP_ITEM,
       LIST_OMIT,
       PATH_NAME
    FROM QUSRBRM.BRMS_CONTROL_GROUP_IFS_ENTRY
    WHERE LIST_OMIT = 'OMIT'
    ORDER BY CONTROL_GROUP,
             SEQUENCE_NUMBER;