Process Automation: What is the location of the Agent status in the database?

Document ID : KB000011603
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

What is the location of the Agent status in the database?

Answer:

The agent status is displayed in the UI and written to the DB. In the Library database, there is table named AGENT. You can get the status of an agent from this table. You and your DBA will need to query on the IsActive column and it gives you the agent status. You will to write a join query on Agent and ConfigObject tables.