Page History
The Audited SQL Servers Summary tab (Management Console) displays the status of audit activity across your SQL Server environment. Use the statistics and graphs on this tab to quickly and easily identify issues so you can continue to ensure the correct level of compliance.
Understanding System Status
...
Clicking the status link opens the more detailed Registered SQL Servers tab under Administration. Use this tab to view the status of audited databases on this instance, validate audit settings, and check the SQL Compliance Manager Agent status.
Status Type | Possible Causes |
---|---|
Alert/Error |
|
OK | SQL Compliance Manager is performing as expected. |
Warning |
|
Registered SQL Servers
Displays the number of SQL Server instances that are registered with SQL Compliance Manager.
...
You can also use auditing thresholds to display critical issues or warnings should a particular activity, such as privileged user events, be higher than expected. These thresholds can notify you about issues related to increased activity levels, such as a security breach, that may be occurring on this instance. Use thresholds to supplement the alert rules you have configured for your environment.
Status Type | Indication | Meaning |
---|---|---|
Audited without thresholds | gray check | This event category is audited on instances in your environment, but auditing thresholds are not set for this event category. Consider setting audit thresholds so you can track peaks in activity and identify any suspicious events. |
Critical | red icon | The event activity during the selected time span is higher than the defined critical threshold. To see more information about this activity, navigate to the Audit Events tab and search for events in the flagged event category. You can view the detailed properties of an event by double-clicking the listed event. |
OK | green check | This event category is audited on instances in your environment and auditing thresholds are set for this event category. |
Not audited | red icon | This event category is not audited on instances in your environment even though auditing thresholds are set for this event category. To track this activity, change your audit settings to include the corresponding event category. To ignore this activity, disable the auditing threshold set for this event category. |
Not audited and no thresholds set | gray circle | This event category is not audited on any instances in your environment. Auditing thresholds are not set for this event category. Review whether you need to audit and track this activity on any of your SQL Server instance. |
Warning | yellow icon | The event activity during the selected time span is higher than the defined warning threshold. To see more information about this activity, navigate to the Audit Events tab and search for events in the event category that is flagged. You can view the detailed properties of an event by double-clicking the listed event. |
Understanding the Enterprise Activity Report Card tabs
...
Register SQL Server
Starts the New Registered SQL Server wizard, allowing you to enable and configure auditing on another SQL Server instance.
Monitor
Opens the Change Log tab under Administration, allowing you to monitor what types of changes are made to audit settings across your environment.
Configure Access
Opens the SQL Logins tab under Administration, allowing you to control who has access to view and report on audit data or change configuration settings.
Self-Audit
Allows you to perform an integrity check on the audit data currently stored in Repository.
Configure Alerting
Opens the Alert Rules tab under Administration, allowing you to configure alerting to track specific activity on SQL Server instances across your environment.
...