Page History

The General

...

 This tab tab of the SQL Compliance Manager Agent Properties window allows you to monitor the health of the SQLcompliance SQL Compliance Manager Agent that is auditing the selected SQL Server instance.

If you modifying properties for a SQLcompliance SQL Compliance Manager Agent that is auditing a virtual SQL Server, IDERA SQL compliance manager Compliance Manager applies your changes to the active node in the cluster hosting the virtual SQL Server. SQLcompliance SQL Compliance Manager Agent properties are later replicated from the active node to the passive nodes.

Image Added

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

 SQLcompliance 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.

...

SQL Compliance Manager audits all activity on your server. Learn more > >

...