Page tree

The IDERA SQL Compliance Manager Alerts view allows you to view the current alerts and 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.

View By

Allows you to select whether Alerts or Alert Rules appear in this view.

Filtered By

Allows you to select the type of Alerts displayed in this view. You can view all Alerts, only your Event Alerts, only Data Alerts, or only Status Alerts based on this selection.

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 Alert Rules list with current data.

Alerts view

Configurations can be set up via the SQL Compliance Manager Windows Console.

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, available from the Filtered By selection, 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

The Data Alerts view, available from the Filtered By selection,  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.

Status Alerts view

The Status Alerts view, available from the Filtered By selection, allows you to view previously generated Status Alerts. A Status Alert is generated when the status of the specified product components matches the alert rule criteria. Use Status Alerts to identify and investigate possible issues with IDERA SQL Compliance Manager operations, such as deployed agents that may have stopped running.

Alert Rules view

Configurations can be set up via the SQL Compliance Manager Windows Console.

Default columns

Rule

Provides the name you specified when you created each alert rule. By default, SQL Compliance Manager names each new rule New Rule.

Rule Type

Indicates whether this rule generates an Event Alert or a Status Alert.

Server

Provides the name of the registered SQL Server instance associated with this alert rule. By default, Event and Status Alerts apply to all registered SQL Server instances. For better focused Event Alerts, you can specify a different target SQL Server using the Edit Alert Rule wizard.

Level

Provides the alert level, such as High. Depending on the rule type, you can change the alert level using either the Edit Event Alert Rule or Edit Status Alert Rule wizard.

Email

Indicates whether the alert rule criteria includes email notification. When email notification is configured, SQL Compliance Manager sends an alert message to the specified addresses. Depending on the rule type, you can set up email notification using either the Edit Event Alert Rule or Edit Status Alert Rule wizard.

Event Log

Indicates whether the alert rule criteria includes event log notification. When event log notification is configured, SQL Compliance Manager writes an alert message to the application event log. Depending on the rule type, you can set up event log notification using either the Edit Event Alert Rule or Edit Status Alert Rule wizard.

SNMP Trap

Indicates whether the alert rule criteria includes sending SNMP Trap messages to a specified network management console. When SNMP Trap is configured, SQL Compliance Manager sends an alert message to the specified network management console. Depending on the rule type, you can set up SNMP Trap notification using either the Edit Event Alert Rule or Edit Status Alert Rule wizard.



IDERA |  Products | Purchase | Support |  Community | Resources |  About Us | Legal