Page History

The IDERA SQL Compliance Manager Instances view displays the status of audit activity across your SQL Server environment. Use the statistics and graphs on this view to quickly and easily identify issues so you can continue to ensure the correct level of compliance. Image RemovedBe sure to review the associated topics about managing properties for the registered SQL Server instance and the Agent:

Image Added

Available actions

Filtering

Allows you to filter the listed instances by status, instance name, status text, number of audited databases, SQL Server version, audit status, and timestamp for the last time the agent was contacted.

Add SQL Server Instance

Starts the Server Configuration wizard, allowing you to enable and configure auditing on another SQL Server instance.

Export

Allows you to export the list of audited SQL Server instances to a in PDF, XLS, or XML fileformat.

Enable Auditing / Disable AuditingRefresh

Allows you to

...

update the Audited Instances list with current data.

To re-enable auditing, right-click the instance from the Explore Activity tree, and then click Enable Auditing on the context menu.

Refresh

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

Import

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

Edit Filter

Allows you to change an existing event filter using the New Event Filter wizard.

Enable / Disable

Allows you to enable or disable the associated event filter. When an event filter is enabled, SQL Compliance Manager processes audited events using the selected criteria in this filter.  If an event matches the filter criteria , SQL Compliance Manager removes the event from the audit data. Use the Audit Events tab to see the resultant set of processed events. When an event filter is disabled, you temporarily stop using the selected event filter. SQL Compliance Manager no longer uses this filter when processing events. All previously processed audit data stored in the Repository remains intact. To reinstate this filter, enable it.

Delete

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.

...