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.
(Screenshot)
Available actions
Configure Email Settings
The Configure Email Settings window allows you to configure IDERA SQL Compliance Manager to connect to your mail server. This configuration is required to send alert email notifications. For more information, see Configure Email Settings window.
Configure SNMP Settings
The SNMP Configuration window allows you to specify the server address, port number, and community name of the network management console that you want to receive a IDERA SQL Compliance Manager alert notification as SNMP Trap messages. For more information, see SNMP Configuration window.
Groom Alerts Now
The Groom Alerts Now window allows you to groom alert messages currently stored in the Repository databases. Grooming permanently deletes any alert message that is older than the age limit you specify. For more information, see Groom Alerts Now window.
Available fields
Configure Email Settings
The Configure Email Settings window allows you to configure IDERA SQL Compliance Manager to connect to your mail server. This configuration is required to send alert email notifications. For more information, see Configure Email Settings window.
Configure SNMP Settings
The SNMP Configuration window allows you to specify the server address, port number, and community name of the network management console that you want to receive a IDERA SQL Compliance Manager alert notification as SNMP Trap messages. For more information, see SNMP Configuration window.
Groom Alerts Now
...
Server Instance
The
Databases
Table Name
Login
Start Date
The
End Date
The
Start Time of Day
End Time of Day
Schema
Column Name
Application
Event
Row Count Threshold
Show SQL
Privileged Users Only
Run Report
Click this button to Run the report.
Available fields
Server Instance
The Server Instance column displays the ...
Database
The Database column displays the ...
Schema Name
The Schema Name column displays the ...
Table Name
The Target Object column displays the ...
Column Name
The ...
Login
The Login column displays the ...
Role
Number of Rows
Application
The Application column displays the ...
Event
The Event column displays a description of the event captured.
Date/Time
SPID
The SPID column displays ...
SQL
...