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.
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 PDF, XLS, or XML file.
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 Audited Instances list with current data.
Upgrade Agent
Allows you to upgrade the SQLcompliance 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.
Check Agent Status
Allows you to check the status of the SQLcompliance Agent on the selected SQL Server instance, such as whether the agent is active.
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. For more information about using this window, see 5.3 - Viewing Agent Properties.
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. For more information about using this window, see 5.3 - Viewing Instance Properties.
Permissions Check
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
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 Manager audits all activity on your server. Learn more > >