Skip to main content
Kofax

SQL query to audit Event Listener current status

 
307790

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

statuslistener.jpg

Applies to:  

Product Version Category
KAFC 2.1 Configuration

 

Author:   Eric Roque