Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This The Alert Rules tab in IDERA SQL Compliance Manager tab allows you to create new alert rules and manage existing alert rules. 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.

...

Allows you to create a new alert using the New Event Alert Rule wizard. SQL CM Compliance Manager stores this alert rule in the Repository.

...

Allows you to create a new alert using the New Status Alert Rule wizard. SQL CM Compliance Manager stores this alert rule in the Repository.

...

Allows you to create a new alert using the New Data Alert Rule wizard. SQL CM Compliance Manager stores this alert rule in the Repository.

...

Allows you to create a new alert using the selected rule as a template. This action launches the New Alert Rule wizard, each window populated with alert criteria from the selected rule. You can change any alert criterion to meet the goals of your new alert rule. SQL CM Compliance Manager stores the new alert rule in the Repository. The selected rule remains unchanged.

...

Allows you to enable the selected rule. When an alert rule is enabled, SQL CM Compliance Manager processes audited events using the selected criteria in this rule. If an event matches the alert criteria and an alert action is configured , SQL CM Compliance Manager writes an alert message to the application event log or email it to the specified addresses. Alert messages are also available using the Alerts tab.

...

Allows you to temporarily stop using the selected rule. SQL CM Compliance Manager no longer uses this alert rule when processing events. All alert messages previously generated by this rule will remain available through the Management Console and the application event log, if event log notification was configured. To reinstate this alert, enable the alert rule.

...

Allows you to permanently delete the selected rule. Deleting an alert rule removes the rule from the Repository. SQL CM Compliance Manager no longer uses this alert rule when processing events. All alert messages previously generated by this rule will remain available through the Management Console and the application event log, if event log notification was configured. If you want to temporarily stop using an alert rule , disable the alert rule.

...

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

...

Indicates whether the alert rule criteria includes email notification. When email notification is configured, SQL CM 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.

...

Indicates whether the alert rule criteria includes event log notification. When event log notification is configured, SQL CM 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.

 

Excerpt
SQL Compliance Manager audits all activity on your server. Learn more > >