Page History
...
Note |
---|
SQL Compliance Manager |
...
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 Compliance Manager allows you to page through the results. This table includes:
- SQL Server. Displays the name of the audited SQL Server instance.
- Agent Status. Displays the current status of the SQL Compliance Manager Agent. Options include OK, Informational, Warning, and Critical.
- Enabled Event Categories. Displays the total number of SQL Server event categories, such as Security, DDL, Administrative, etc., that you are using to filter from your audit data.
- Collected Events. Displays the total number of SQL Server events collected based on the enabled event categories.
- Number of Databases. Displays the total number of audited databases.
- Last Heartbeat. Displays the most recent date and time that the SQLcompliance Agent deployed for this instance contacted the Collection Server..
Info |
---|
Click the name of a SQL Server instance, and SQL Compliance Manager opens the Audited SQL Server view for that instance. |
SQL Server Alerts
On this 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.
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 Compliance Manager displays the first five databases and includes the ability to page through results. This table includes:
- SQL Server database name
- Alert status, including Low, Medium, High, and Severe
- Rule type, such as Event, Data, Status, etc.
- Rule name
- Name of the SQL Server instance where the database resides
- Timestamp when the alert was triggered
Info |
---|
Click the name of a database, and SQL Compliance Manager opens the Audited Database view for that database. |
My Compliance Manager Environment area
On the right side of the IDERA Dashboard overview, SQL Compliance Manager provides a summary your environment that includes:
- Registered SQL Server instances. Displays the total number of SQL Server instances registered in SQL Compliance Manager.
- Audited SQL Server instances. 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.
- Processed events. Displays the current total number of audit events stored in the Repository event databases. This number does not include events previously archived or groomed.
In addition, SQL Compliance Manager includes a nested, selectable list of the items in your environment.
Info |
---|
Click a database name, and SQL Compliance Manager opens the Individual Database view for that database. Click a SQL Server instance name, and SQL Compliance Manager opens the Individual SQL Server view for that instance. |
Audited SQL Servers area
On the right side of the IDERA Dashboard overview, SQL Compliance Manager provides an instance and database tree for you to click and quickly access a specific instance or database.
Excerpt |
---|
SQL Compliance Manager audits all activity on your server. Learn more > > |
is ONLY compatible with IDERA Dashboard version 4.8.1 and with limited support. |
The IDERA Dashboard SQL Compliance Manager Web Console provides a browser-based interface for many of the features within the SQL Compliance Manager Management (Windows) Console. the following topics help you explore what features are available to you:
Children Display |
---|
...