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
Event
The Event column displays the...
Host
The Host column displays the ...
Login
The Login column displays the ...
Application
The Application column displays the ...
Database
The Database column displays the ...
Schema Name
The Schema Name column displays the ...
Target Object
The Target Object column displays the ...
Details
The Details column displays the ...
Time
The Time column displays the date and time when the event was captured.
SQL