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.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels