Page History

This The Event Alerts tab 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.

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 7 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.

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 Event 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 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.