Page History

...

Allows you to enable auditing on the selected SQL Server instance. When you enable auditing, the SQLcompliance SQL Compliance Manager Agent begins collecting events on the selected SQL Server instance, and sends the SQL trace files to the Collection Server.

...

Allows you to disable auditing on the selected SQL Server instance. When you disable auditing, the SQLcompliance SQL Compliance Manager Agent stops collecting new event data, and stops the corresponding SQL trace. You can continue to view and report on previously audited events or archived events.

...

Allows you to send your audit setting changes to the SQLcompliance agent SQL Compliance Manager Agent immediately. Typically, the Collection Server sends audit setting updates at each heartbeat communication from the SQLcompliance SQL Compliance Manager Agent. By default, a heartbeat occurs every five minutes. To view the SQLcompliance SQL Compliance Manager Agent heartbeat details, use the General tab on the SQLcompliance SQL Compliance Manager Agent Properties window.

Collect Audit Data Now

Allows you to force the SQLcompliance SQL Compliance Manager Agent to send trace files to the Collection Server for processing. Typically, the SQLcompliance SQL Compliance Manager Agent sends trace files to the Collection Server at the specified collection interval. By default, a trace file collection occurs every two minutes.

...

Allows you to view and modify settings for the SQLcompliance SQL Compliance Manager Agent that is auditing the selected SQL Server instance.

...

Allows you to check the status of the SQLcompliance SQL Compliance Manager Agent on the selected SQL Server instance, such as whether or not the agent is active.

Deploy Agent

Allows you to deploy the SQLcompliance SQL Compliance Manager Agent to one or more registered SQL Server instances. Deploying the agent installs the SQLcompliance SQL Compliance Manager Agent Service on the target instance, and allows you to begin auditing events.

...

Allows you to upgrade the SQLcompliance SQL Compliance Manager Agent on the selected SQL Server instance to the current version. This option is available if the agent was remotely deployed through the Management Console. To upgrade an agent that was manually deployed, run setup.exe from the SQL compliance manager installation kit on the target SQL Server computer.

...

Allows you to specify a different trace directory for the SQLcompliance SQL Compliance Manager Agent. The agent uses the specified folder to store trace files before sending these files to the Collection Server for processing.

...

Allows you to unregister the selected SQL Server instance. When you remove a SQL Server instance, SQL Compliance Manager disables all auditing at the server and database levels on the SQL Server instance. If the selected instance is the last instance to be audited on this SQL Server , SQL Compliance Manager also uninstalls the SQLcompliance SQL Compliance Manager Agent. If you manually deployed the SQLcompliance SQL Compliance Manager Agent , you must manually uninstall it from the SQL Server computer.

...

If a system alert is triggered , the Status column displays the alert type. System alerts notify you when the health of your SQL Compliance Manager deployment may be compromised. For more information, see the Activity Log tab.

Deployment Method

Indicates the agent deployment method for the selected SQL Server.

The values in this column can be: manually deployed, console deployed, and silent installer script. 

Audit Status

Indicates whether auditing is enabled on the selected SQL Server instance. When auditing is disabled, the SQL trace is stopped and the SQLcompliance SQL Compliance Manager Agent no longer collects events.

...

Provides the date and time when the SQLcompliance SQL Compliance Manager Agent last received audit setting updates from the Collection Server (also called a heartbeat). To view the SQLcompliance SQL Compliance Manager Agent heartbeat details, use the General tab on the SQLcompliance SQL Compliance Manager Agent Properties window.

...

...