Which ChangeAuditor database table in SQL shows all the active and inactive agent connections?
说明
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?
解决办法
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.
