The IDERA SQL Compliance Manager Alerts view allows you to view the current alerts and create and manager alert rules throughout your environment. An alert rule is a set of criteria that determines when an alert should be generated as the Collection Server processes SQL Server events collected from your audited instances. Use alert rules to detect events that occur on specific databases, users, or instances.
Available actions include:
Page through alerts and alert rules
Allows you to page through the list of alerts and rules. Use the previous and next arrows to navigate from page to page, up and down the list.
Filtering
Allows you to filter the listed alerts and rules by rule, rule type, server name, alert level, user email address, event log, and SNMP traps. Filtering includes a Save View feature that lets you select all of your filtering options, and then save the settings for future use. Click Load View to select a previously-saved view for use.
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.
Export
Allows you to export the Activity Log and Change Log information to a CSV, PDF, or XML file.
Refresh
Allows you to update the activity list with current data.
For more information about the Activity Log and Change Log tabs in the SQL Compliance Manager Monitoring Console, see Activity Log tab and Change Log tab.
Alerts view
Default columns
Instance name
Provides the name of the audited SQL Server instance where this event occurred.
Date
Provides the date when the alert was generated.
Time
Provides the time when the alert was generated.
Level
Indicates the type of alert, such as Severe or Low. Use the alert level to help you identify critical issues, sort alerts by severity, and understand the overall health of your environment. You can define the alert using the Edit Alert Rule wizard.
Source Rule
Provides the name of the alert rule that generated this alert.
Event
Provides the name of the audited event that triggered this alert.
Detail
Provides additional information about the alert.
Event Alerts view
The Event Alerts view allows you to view previously generated Event Alerts. An Event Alert is generated when the Collection Server processes a SQL Server event that matches the alert rule criteria. Use Event Alerts to identify and investigate suspicious activity on specific databases, users, or instances.
Data Alerts view
Status Alerts view
Alert Rules view
SQL Compliance Manager audits all activity on your server. Learn more > >