The Data Alerts tab allows you to view previously generated Data Alerts. A Data Alert is generated when the Collection Server processes a SQL Server event that matches the alert rule criteria. Use Data Alerts to identify and investigate data manipulation on specific databases, tables, or columns.
The Collection Server generates one alert per SELECT event, even though the query may have accessed multiple audited columns.
Available actions
Page through alerts
Allows you to page through the list of alerts. Use the previous and next arrows to navigate from page to page, up and down the list.
Create customized view
Allows you to create a custom version of this tab. You can change the data that is displayed by selecting different columns. You also can save your customizations to view later.
Filters
Allows you to filter the listed alert messages by time span (for example, last seven days) or alert level (for example, high).
Enable Groups
Allows you to group alerts by a specific property, such as the audited SQL Servers affected by the alerts or the times the alerts occurred. Enable groups when you want to sort the alerts or focus on a particular alert attribute.
Event Properties
Allows you to view details about the SQL Server event that triggered this alert. This option is available from the right-click context menu. You can also view event properties by double-clicking an alert from the list. For more information, see Event Properties.
Alert Message
Allows you to view the message IDERA SQL Compliance Manager generated when this alert was triggered. Depending on your alert rule criteria, this message is written to the application event log and emailed to the specified email addresses. The Management Console displays an alert message only when the corresponding alert rule is configured to generate a message.
This action is available from the right-click context menu only.
Refresh
Allows you to update the Data Alerts list with current data.
Default columns
Icon
Provides a visual indication of the alert level so you can quickly scan the listed alerts for a specific alert type, such as a severe alert.
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 Data 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.
SQL Server
Provides the name of the audited SQL Server instance where this event occurred.
Additional columns
You can add any of these columns to this tab using the Select Column action. After you add a new column, you can save the tab as a custom view to reference later.
Details
Provides the first line of the alert message associated with this alert.
Subject
Provides the subject line of the alert message associated with this alert.