SQL query to audit Event Listener current status

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:

1. Query the tblIntance table: SELECT * FROM tblInstance;
2. The query results show all Event Listeners configured in the system.
3. The "Status" column shows the number state:

0 = Active

1 = Suspended

2 = Turf updated pending

3 = Turf updated

4 = Stopped

Applies to: