Page History
...
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:
...
| Info |
|---|
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.
| Excerpt |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > |