Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The IDERA SQL Compliance Manager Database Summary tab displays the status of audit activity for a particular database hosted by the selected SQL Server instance. Use the statistics and graphs on this tab to quickly and easily identify database-level issues so you can continue to ensure the correct level of compliance.

Image Added

Understanding Event Distribution

...

Configure Alerting

Opens the Alert Rules tab under Administration, allowing you to configure alerting to track specific activity on this database or other SQL Server instances across your environment.

Configure Event Filters

Opens the Event Filters tab under Administration, allowing you to configure Event Filters that exclude specific types of events from your audit trail, allowing you to eliminate unnecessary events before they are processed by the Collection Server.

...

Disabling auditing at the database level does not disable auditing at the server level or auditing of other databases hosted on the SQL Server instance. For more information, see Disabling auditing on a database.

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

...

Allows you to change the audit settings for the selected SQL Server database. For more information, see Audited Database Properties.

Apply Regulation Guideline

Allows you to select one or more regulations to apply to this audited SQL Server database. If you want to apply regulation guidelines to all audited databases on a SQL Server instance, use the Apply Regulation Guideline feature from the Explore Activity - Instance Summary tab. For more information, see Apply Regulation Guideline.

Trusted Users

Allows you to change which SQL Server logins or roles are considered trusted users on the selected SQL Server database. Logins designated as trusted users are not audited at the database level. All events resulting from trusted user activity are filtered from the audit trail before the trace file is sent to the Collection Server for processing. For more information, see Audited Database Properties window - Trusted Users tab.

Import

Allows you to import audit settings previously exported from another audited instance or database. For more information, see Import your audit settings wizard.

Export

Allows you to export audit settings for this SQL Server database to an XML file. This file includes audit settings configured at the database level. You can later use this file to import audit settings across multiple databases, ensuring consistent auditing and compliance on a given instance or throughout your environment.

...