Page History
Audited SQL Servers Summary
The Audited SQL Servers Summary tab 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
The System Status pane displays the overall status of your SQL Server environment.
Status
Indicates whether SQL Compliance Manager has encountered any issues while auditing your SQL Server environment.
Clicking the status link opens the more detailed Registered SQL Servers tab under Administration. Use this tab to see the status of audited databases on this instance, validate audit settings, and check the SQLcompliance 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 CM.
Audited SQL Servers
Displays the number of instances currently being audited. This number does not include instances where auditing is not yet configured or is disabled.
Audited Databases
Displays the number of databases currently being audited. These databases are hosted by SQL Server instances that are registered with SQL CM. This number does not include databases where auditing is not yet configured or is disabled.
Processed Events
Displays the number of audit events stored in the Repository event databases for the selected time span. This number does not include events that were previously archived or groomed.
Understanding the Enterprise Activity Report Card status
Each tab of the Enterprise Activity Report Card provides an auditing status for the corresponding event category. You can use this status to help you determine whether you are effectively auditing events in your environment.
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 being audited on instances in your environment but auditing thresholds are not set for this event category. |
Critical | red icon | The event activity during the selected time span is higher than the defined critical threshold. |
OK | green check | This event category is being audited on instances in your environment and auditing thresholds are set for this event category. |
Not audited | red icon | This event category is not being audited on instances in your environment even though auditing thresholds are set for this event category. |
Not audited and no thresholds set | gray circle | This event category is not being audited on any instances in your environment. Auditing thresholds are not set for this event category. |
Warning | yellow icon | The event activity during the selected time span is higher than the defined warning threshold. |
...