Based on the criteria defined in your alert rules, IDERA SQL Compliance Manager generates alerts against your audit data stream for events that occur on a specified SQL Server instance, database, or database object. If a SQL Server instance, database, or database object is not specified, the alert rule criteria is applied against all audit data collected from your SQL Server environment.
You can change the type of audit data that triggers an alert. For example, you can alert on a different event type or a different database. You can also copy an existing alert rule and use it as a template to create a new rule. For more information, see Use an alert rule as a template.
To change the type of audit data that triggers an alert:
- Select Alert Rules in the Administration tree.
- Right-click the rule for the alert you want to change, and then select Properties on the context menu.
- On the SQL Server Event Type window, select the type of event (event category) that you want to alert on, and then click Next.
- On the SQL Server Object Type window, select the type of object you want to alert on for the selected event type, and then click Next. By default, the alert rule will generate an alert when the selected event occurs on any registered SQL Server instance, database, or database object. Use the links provided on the rule details pane to narrow your alert rule to specific objects or objects that match a naming convention.
- On the Additional Event Filters window, define the criteria under which the alert should trigger. Use the criteria to narrow your alert rule to generate alerts only under specific conditions. To specify values that the event should match, use the links provided on the rule details pane.
- Click Finish.