Question / Problem:
What SQL query can be used to get information of the Event Listener status from the tables located in the Staging database?
Answer / Solution:
The Event Listener state is found in the "Status" column from the tlbInstance from Staging database
Enter How to here:
- Query the tblIntance table: SELECT * FROM tblInstance;
- The query results show all Event Listeners configured in the system.
- The "Status" column shows the number state:
0 = Active
1 = Suspended
2 = Turf updated pending
3 = Turf updated
4 = Stopped