--  category:  IBM i Services for BRMS
--  description:  Application - BRMS Network Views
--  minvrm: V7R3M0
--  Requires BRMS PTFs - 7.5 SI82234, 7.4 SI82233, 7.3 SI82232
--  last updated: 3/15/2023

--
-- View all the system information for the systems in the BRMS network
--
SELECT *
    FROM QUSRBRM.NETWORK_INFO;

--
-- View the system status for the system named APPN.SYSTEM1
--
SELECT SYSTEM_NAME,
       SYSTEM_STATUS,
       COMMUNICATION_STATUS
    FROM QUSRBRM.NETWORK_INFO
    WHERE SYSTEM_NAME = 'APPN.SYSTEM1';

--
-- View the systems in the BRMS network which are currently OFFLINE
--
SELECT SYSTEM_NAME,
       SYSTEM_STATUS
    FROM QUSRBRM.NETWORK_INFO
    WHERE SYSTEM_STATUS = 'OFFLINE';