Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

...

Info

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:

...

Info

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:

...

Info

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.

SQL Compliance Manager audits all activity on your server. Learn more > >