Page History

...

Enable Auditing / Disable Auditing

Allows you to enable or disable auditing on the selected SQL Server instance. When auditing is enabled, the SQLcompliance Agent collects new event data and stores the data in a protected subdirectory of the Agent installation directory. When you disable auditing, the SQLcompliance Agent stops collecting

...

event data, and stops the corresponding SQL trace. You can continue to view and report on previously audited events or archived events.

...

Update Audit Settings

Allows you to change the audit settings for the selected SQL Server instance.

Remove

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 Agent. If you manually deployed the SQLcompliance Agent , you must manually uninstall it from the SQL Server computer.

Refresh

Allows you to update the Audit Event Filters Audited Instances list with current data.

Upgrade Agent

Check Agent Status

Agent Properties

Allows you to manage the properties for the Agent associated with the selected SQL Server instance. This action launches the SQL Compliance Agent Properties window.

Properties (instance)

Allows you to manage the properties for the selected SQL Server instance. This action launches the New Event Filter wizard, each window populated with event criteria from the selected filter.

Permissions Check

Import

Allows you to import Event Filters previously exported from another SQL Server instance. By default, the imported Event Filters are disabled.

...

Allows you to permanently delete the selected event filter. This option removes the filter from the Repository. SQL Compliance Manager will no longer use this filter when processing events. All previously processed audit data stored in the Repository remains intact.

Properties

Allows you to manage the properties for the selected event filter. This action launches the New Event Filter wizard, each window populated with event criteria from the selected filter. 

From Existing

Allows you to create a new event filter using a selected filter as a template. This action launches the New Event Filter wizard, each window populated with event criteria from the selected filter. You can change any event criterion to meet the goals of your new filter. SQL Compliance Manager stores the new event filter in the Repository. The selected filter remains unchanged.

SQL Compliance Agent Properties window

Image Added

General tab

Deployment tab

SQL Servers tab

Trace Options tab

Save