Return
-
Title
Which ChangeAuditor database table in SQL shows all the active and inactive agent connections? -
Description
Administrators may want to query the Change Auditor database directly to determine agent status. Which ChangeAuditor database table in SQL shows all the active and inactive agent connections? -
Resolution
The table System.AgentStatus in the ChangeAuditor database lists the Agent IDs and the Status:
- Status 2 is Inactive
- Status 3 is Active
- Status 4 is Uninstalled
The AgentID column in this table can be cross-referenced with the Topology.Server table to return the Servername or serverFQDN.