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.
The overview provides the following sections:
Alerts
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, 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.
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.
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 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
The System Status area provides a summary your environment that includes the number of each device type needing attention, grouped by:
- Registered SQL Servers. Displays the total number of SQL Server instances registered in SQL Compliance Manager.
- Audited SQL Servers. 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.
Recent Alerts
View a count of recent alerts based on severity, whether Severe, High, Medium, or Low.
SQL Compliance Manager audits all activity on your server. Learn more > >