SQL Compliance Manager is ONLY compatible with IDERA Dashboard version 4.8.1 and with limited support.
The Home tab is the default overview page of the product. This tab provides a high-level status of your audited instances and enterprise activity occurring within your environment.
Alerts
IDERA SQL Compliance Manager performs health checks on your registered instances to help you monitor the most important issues across your environment. On this section of the Overview tab, SQL Compliance Manager shows you the active alerts for your environment, grouped by alert type, and ordered by level of criticality, where:
- Level 4 = Severe
- Level 3 = Critical
- Level 2 = Warning
- Level 1 = Informational
If you have no active alerts, you will see the message: No alerts.
You can click the options available for each alert to:
- Show Details of instances or databases affected by the respective alert.
- Individually Acknowledge the alert.
- Individually Dismiss the alert.
- Individually Clear the alert.
If you do not want to see these details, click Hide Details.
You can also get the most updated information for your alerts by clicking Refresh.
Enterprise Activity Report Card
The Enterprise Activity Report Card allows you to review the status of your audited SQL Servers and the recent activity that has occurred on them for up to 30 days of SQL Server activity. Activity Report Cards allow you to view the SQL Server activity at the enterprise and individual SQL Server instance levels. These report cards allow you to quickly check activity in each event category audited, view SQL Server activity statistics, and short-term activity trends. Use Activity Report Cards to identify problems that might require more in-depth analysis based on:
- Overall Activity.
- Event Alerts.
- Failed Logins.
- Security.
- DDL.
- Privileged User.
For more information about the Enterprise Activity Report Card, see Explore Activity - Audited SQL Servers Summary tab.
Audited Instances
All audited SQL Server instances in your environment appear in the Audited Instances section of the Home tab. The default sort order displays the first five instances based on instance name. If you have more than five registered instances, SQL Compliance Manager allows you to page through the results. This table includes:
- Instance Name. Displays the name of the audited SQL Server instance.
- Agent Status Text. Displays the current status of the SQL Compliance Manager Agent. Options include OK, Informational, Warning, and Critical.
- Alerts. Displays the number of alerts associated with that instance.
- SQL Server Version. Displays the SQL Server version installed on that instance.
- Number of Audited DBs. Displays the number of databases audited by SQL Compliance Manager on that instance.
- Agent Actions. Displays a list of actions you can perform on the Agent associated with the instance. Options include Enable Auditing, Disable Auditing, and Upgrade Agent.
Click the name of a SQL Server instance, and SQL Compliance Manager opens the Instance Details view for that instance.
System Status and Recent Alerts area
On the right side of the IDERA Dashboard SQL Compliance Manager Home page, you can view the number of SQL Server instances and databases needing your immediate attention in addition to a count of recent alerts by severity.
System Status
Indicates whether IDERA SQL Compliance Manager encountered any issues while auditing your SQL Server environment. Click the status link to open the more detailed Audited Instances view. Use view to see the status of the audited databases on this instance, validate audit settings, and check the SQL Compliance Manager Agent status.
Registered SQL Servers
Displays the number of SQL Server instances that are registered with SQL Compliance Manager.
Audited SQL Servers
Displays the number of instances currently audited. This number does not include instances where auditing is not yet configured or is disabled.
Audited Databases
Displays the number of databases currently audited. These databases are hosted by SQL Server instances that are registered with SQL Compliance Manager. This number does not include databases where auditing is not yet configured or is disabled.
For more information about the System Status area, see Explore Activity - Audited SQL Servers Summary tab.
Recent Alerts
The Recent Alerts pane displays the number of alerts that are generated for each alert category in the selected time span. If you see an unexpected number of alerts, consider reviewing the current alert messages and then modifying your alert rules to better fit your compliance and auditing needs.
For more information about specific alerts, see View alerts and alert rules. You can view which alerts are generated from multiple instances across your environment or from a particular instance.