Page History

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.

Image Modified

The overview provides the following sections:

Alerts

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 On the SQL Server Alerts section of the Overview tab, SQL Compliance Manager shows you the most recent alerts occurring on the audited SQL Server instances in your environment, active alerts for your environment, grouped by alert type, and ordered by level of criticality. SQL Compliance Manager displays the first five instances and includes the ability to page through results. This table includes:

...

, where:

• Level 4 = Severe
• Level 3 = Critical
• Level 2 = Warning
• Level 1 = Informational

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:

...

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 SQLcompliance SQL Compliance Manager Agent status.

Registered SQL Servers

...

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 5.3 - Viewing alerts View alerts and alert rules. You can view which alerts are generated from multiple instances across your environment or from a particular instance.

...

Save

Save

Save

Save

Save

...