SQL Compliance Manager is ONLY compatible with IDERA Dashboard version 4.8.1 and with limited support.

After you register an instance in IDERA SQL Compliance Manager, you can access the Instance Details view by clicking an instance name.

The Instance Details view allows you to view a list of audit events occurring on the databases for that instance, information about its databases, bar graphs, other relevant information, and also get access to audit configuration details.

The instance Details view provides a high-level status of the audited events and the activity occurring in the selected instance.  


Alerts

On this SQL Compliance Manager shows you the active alerts for the selected instance, grouped by alert type, and ordered by level of criticality, where:

  • Level 4 = Severe
  • Level 3 = Critical
  • Level 2 = Warning
  • Level 1 = Informational

If you have no active alerts, you will see the message: No alerts.


Server Activity Report Card

The Server Activity Report Card allows you to review the status of the selected instance and the recent activity on it for up to 30 days.  Use Server 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.


Audit Events

All audited events for the selected instance appear in the Audited Events section of the Instance Details page. This table includes:

  • Database Name
  • Event
  • Date
  • Time
  • Login

Users can also view the Event Properties by clicking the gear icon and selecting the Event Properties option.

Server Status

On the right side of the Instance Details page, users can check the Server Status. This section displays.

Audited Databases

Displays the number of databases currently audited. These databases are hosted by SQL Server instances that are registered with SQL Compliance Manager. This number does not include databases where auditing is not yet configured or is disabled.

Audit Configuration      

Displays the audit configurations set for the selected instance.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal