The IDERA Dashboard SQL CM Home tab is the default home page of the product. This tab provides a high-level status of your audited instances and SQL Server alerts occurring within your environment. 

The overview provides the following sections:

Audited SQL Servers

All audited SQL Server instances in your environment appear in the Audited SQL Servers 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:

• SQL Server. Displays the name of the audited SQL Server instance.
• Agent Status. Displays the current status of the SQL Compliance Manager Agent. Options include OK, Informational, Warning, and Critical.
• Enabled Event Categories. Displays the total number of SQL Server event categories, such as Security, DDL, Administrative, etc., that you are using to filter from your audit data.
• Collected Events. Displays the total number of SQL Server events collected based on the enabled event categories.
• Number of Databases. Displays the total number of audited databases.
• Last Heartbeat. Displays the most recent date and time that the SQLcompliance Agent deployed for this instance contacted the Collection Server..

SQL Server Alerts

On this section of the Overview tab, SQL Compliance Manager shows you the most recent alerts occurring on the audited SQL Server instances in your environment, ordered by level of criticality. SQL Compliance Manager displays the first five instances and includes the ability to page through results. This table includes:

• Time. Displays the date and time when the alert was generated.
• SQL Server. Displays the name of the SQL Server instance where the alert occurred.
• Alert status. Displays the current status of the SQL Server, including OK, Informational, Warning, and Critical
• Alert Type. Displays the product component status change that generated the alert.
• Source Rule. Displays the name of the alert rule used to generate the alert.

SQL Database Alerts

The Current Audited SQL Database Alerts section of the Overview tab shows you the most recent alerts occurring on the databases in your environment, ordered by level of criticality. SQL Compliance Manager displays the first five databases and includes the ability to page through results. This table includes:

• SQL Server database name
• Alert status, including Low, Medium, High, and Severe
• Rule type, such as Event, Data, Status, etc.
• Rule name
• Name of the SQL Server instance where the database resides
• Timestamp when the alert was triggered

My CM Environment area

On the right side of the IDERA Dashboard overview, SQL Compliance Manager provides a summary your environment that includes:

• Registered SQL Server instances. Displays the total number of SQL Server instances registered in SQL Compliance Manager.
• Audited SQL Server instances. Displays the total number of SQL Server instances audited in SQL Compliance Manager.
• Audited databases. Displays the total number of databases audited in SQL Compliance Manager.
• Processed events. Displays the current total number of audit events stored in the Repository event databases. This number does not include events previously archived or groomed.

In addition, SQL Compliance Manager includes a nested, selectable list of the items in your environment.

Audited SQL Servers area

On the right side of the IDERA Dashboard overview, SQL Compliance Manager provides an instance and database tree for you to click and quickly access a specific instance or database.