Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
