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 CM 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 CM 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..
Click the name of a SQL Server instance, and SQL CM opens the Audited SQL Server view for that instance.
SQL Server Alerts
On this section of the Overview tab, SQL CM shows you the most recent alerts occurring on the audited SQL Server instances in your environment, ordered by level of criticality. SQL CM 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 CM 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
Click the name of a database, and SQL CM opens the Audited Database view for that database.
My CM Environment area
On the right side of the Idera Dashboard overview, SQL CM provides a summary your environment that includes:
- Registered SQL Server instances. Displays the total number of SQL Server instances registered in SQL CM.
- Audited SQL Server instances. Displays the total number of SQL Server instances audited in SQL CM.
- Audited databases. Displays the total number of databases audited in SQL CM.
- 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 CM includes a nested, selectable list of the items in your environment.
Click a database name, and SQL CM opens the Individual Database view for that database. Click a SQL Server instance name, and SQL CM opens the Individual SQL Server view for that instance.
Audited SQL Servers area
On the right side of the Idera Dashboard overview, SQL CM provides an instance and database tree for you to click and quickly access a specific instance or database.