The General tab of the SQL Compliance Manager Agent Properties window allows you to monitor the health of the SQL Compliance Manager Agent that is auditing the selected SQL Server instance.
If you modifying properties for a SQL Compliance Manager Agent that is auditing a virtual SQL Server, IDERA SQL Compliance Manager applies your changes to the active node in the cluster hosting the virtual SQL Server. SQL Compliance Manager Agent properties are later replicated from the active node to the passive nodes.
Available actions
Update now
Allows you to send any audit setting changes to the SQL Compliance Manager Agent. The SQL Compliance Manager Agent service applies your updates immediately.
Available fields
SQL Compliance Manager Agent Computer
Provides the name of the computer on which the SQL Compliance Manager Agent is installed. This computer hosts the selected SQL Server instance and audited databases.
Agent Status
Provides the status of the agent, such as OK or Not deployed.
Agent version
Provides the version number for the agent. This version number should reflect the product version number.
Agent port
Provides the port number used by the agent to communicate with the Collection Server.
Last heartbeat
Provides the last date and time when the agent successfully communicated with the Collection Server.
Heartbeat interval
Allows you to specify the interval (in minutes) at which the SQL Compliance Manager Agent calls the Collection service and receives audit setting updates. By default, the heartbeat interval is five minutes.
Logging level
Allows you to select the logging level at which the SQL Compliance Manager Agent writes events to the Application log on the computer hosting the registered SQL Server instance.
Last agent update
Provides the last date and time when the agent received audit setting updates.
Audit settings status
Indicates whether the agent is using the most current audit settings available.
Audit settings level at agent
Provides the version of the audit settings applied at the agent. If the agent audit settings level does not match the current audit settings level, consider performing an immediate update.
Current audit settings level
Provides the version of the audit settings available at the Collection Server.