Skip to main content

SQL query to audit Event Listener current status

Article # 307319 - Page views: 133


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:  

Product Version Category
KAFC 2.1 Configuration


Author:   Eric Roque

  • Was this article helpful?