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.
Available actions
Server Instance
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.
Start Date
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.
End Date
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.
Start Time of Day
End Time of Day
Agent
Event
Run Report
Click this button to Run the report.
Available fields
Time
The Time column displays the date and time when the event was captured.
Agent
The Agent column displays the name of the SQL Server Agent.
Server Instance
The Server Instance column displays the name of the Instance Server.
Event
The Event column displays a description of the event captured.