Page History
| Note |
|---|
SQL Compliance Manager is ONLY compatible with IDERA Dashboard version 4.6 and with limited support. |
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.
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 section of the Overview tab, SQL Compliance Manager shows you the active alerts for your environment, grouped by alert type, and ordered by level of criticality, where:
- Level 4 = Severe
- Level 3 = criticalCritical
- Level 2 = warningWarning
- Level 1 = informationalInformational
| Info |
|---|
...
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:
...
| Info |
|---|
Click the name of a SQL Server instance, and SQL Compliance Manager opens the Instance Details view for that instance. |
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 View alerts and alert rules. You can view which alerts are generated from multiple instances across your environment or from a particular instance.
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
| Excerpt |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > |
...