Page History
The Alerting option from the SQL Compliance Manager Menu allows users to configure their preferred email and SNMP settings, as well as to groom undesired alerts on your SQL Servers. Alert Rules report shows a lists of all the existing alert rules in your environment, you can filter the alerts by the rule name, by the alert level or by selecting the rule type. Use this report to monitor all types of alert rules in your environment.
A filter can include a list of wildcards, separated by commas, where a wildcard is a string, which may contain asterisks. The following parameters are specific to the selected report and enable you to filter the data to include in the report. (Screenshot)
Available actions
Server Instance
The
Rule
Rule Type
Event Log
The
Alert Level
...
Allows you to select a registered instance on which you want to report. Select ALL to report on all instances.
Rule
Allows you to type the name of one or more rules on which you want to report.
Rule Type
Allows you to select the rule type on which you want to report. Select between the following rule types; All, Event Rules, Status Rules or Data Rules.
Event Log
Choose to filter alert rules based on alerts which log events or do not log events. Select ALL to report on all alert rules.
Alert Level
Choose to filter alerts by their different levels; Severe, High, Medium, or Low.
Allows you to select whether display Alert Rules with an email associated to the rule or display Alert Rules with no email associated to it. Select All to display all Alert Rules.
Run Report
Click this button to Run the report.
...
Default columns
Rule
The Time Rule column displays the date and time when the event was captured.
SQL Server
name of the alert rule.
Server Instance
The Server Instance column displays the name of the Instance Server where the event was captured.The Alert Level column displays the ...
Alert Level
The Event Alert Level column displays a description of the event captured. the level the alert is configured to.
The Login column displays the ...Email column specifies whether the alert rule has an email address associated to it, in order to receive the alerts.
Log
The Host Log column displays the ... specifies whether the alert rule is configured to log events.
...