This tab lists events and alerts initiated by the SQL Compliance Manager components, allowing you to monitor SQL CM operations and diagnose issues.
Available actions
View activity details
To view detailed information about a particular event, double-click the event entry in the Activity Log.
View system alerts
To view detailed information about a system alert, double-click the event entry in the Activity Log.
SQL compliance manager generates the following types of system alerts.
System Alert | Caused by ... | Resolves when ... | ||||
|---|---|---|---|---|---|---|
Agent Configuration Error |
|
| ||||
Collection Service Connection Error | Collection Server is offline or the SQL Server instance hosting the Repository is offline | Connection to the collection service is established | ||||
CLR Error | Error when enabling CLR, creating or modifying the before-after data trigger, or performing a health check | SQL compliance Agent configuration update or health check is successful | ||||
Server Connection Error | Error when connecting to the audited instances, due to invalid permissions or the SQL Server instance being offline | Connection is established | ||||
SQL Trace Error | Error when starting or stopping the audit traces | Audit traces are started or stopped | ||||
Trace Directory Error | Error when creating trace directory or when reaching the maximum size allocated for the trace directory | Trace directory is created or the trace files are transferred to the Collection Server for processing |
Page through activities
Allows you to page through the list of activities. Use the previous and next arrows to navigate from page to page, up and down the list.
Filters
Allows you to filter the listed activities by time span (for example, last seven days).
Enable Groups
Allows you to group activities by a specific property, such as the computers on which the activities occurred or the times the activities occurred. Enable groups when you want to sort the activities or focus on a particular activity attribute.
Refresh
Allows you to update the activity list with current data.
Available columns
Date
Provides the date that the event occurred.
Time
Provides the time that the event occurred.
SQL Server
Provides the name of the SQL Server instance, using the format SQLServerName\InstanceName.
Event
Provides the type of event that occurred.
Details
Displays the first line of the event details.