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.
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.
Allows you to filter the listed alert messages by time span (for example, last seven days) or alert level (for example, high).
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.
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.
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.
Allows you to update the Data Alerts list with current data.
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.
Provides the date when the alert was generated.
Provides the time when the alert was generated.
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.
Provides the name of the alert rule that generated this alert.
Provides the name of the audited event that triggered this alert.
Provides the name of the audited SQL Server instance where this event occurred.
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.
Provides the first line of the alert message associated with this alert.
Provides the subject line of the alert message associated with this alert.