The General tab of the SQLcompliance Agent Properties window allows you to monitor the health of the SQLcompliance Agent that is auditing the selected SQL Server instance.
If you modifying properties for a SQLcompliance 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. SQLcompliance 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 SQLcompliance Agent. The SQLcompliance Agent service applies your updates immediately.
Available fields
SQLcompliance Agent Computer
Provides the name of the computer on which the SQLcompliance 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 SQLcompliance 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 SQLcompliance 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.