This article explains how to get a list of all services available in Narrowcast and their status
SELECT A1.MR_OBJECT_ID, A2.MR_OBJECT_NAME, A1.MR_STATUS FROM TutorialMSTROBJINFO A1, TutorialMSTROBJNAMES A2 where A1.mr_object_type =19 AND A1.MR_OBJECT_ID= A2.MR_OBJECT_ID
MR_STATUS = 1 = Active and MR_STATUS = 2 = Inactive.
Connect to the Narrowcast Server Repository.
Run the SQL below to get a list of all the services, the name and the status.
