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.
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
...
Regulation Guideline Report shows regulation guidelines details for all the guidelines applied to database on the selected instance. Use this report to audit and monitor the regulatory guidelines applied to your SQL Server instance.
Available actions
Server Instance
Allows you to select a registered instance on which you want to report. Select ALL to report on all instances.
Run Report
Click this button to Run the report.
Default columns
Server Instance
The Server Instance column displays the name of the Instance Server where the event was captured.
Database
The Database column displays the name of the database where the event was captured.
CIS
The CIS column indicates whether the this regulation guideline is applied or not to the each database in a server.
DISA
The DISA column indicates whether the this regulation guideline is applied or not to the each database in a server.
FERPA
The FERPA column indicates whether the this regulation guideline is applied or not to the each database in a server.
GDPR
The GDPR column indicates whether the this regulation guideline is applied or not to the each database in a server.
HIPPA
The HIPPA column indicates whether the this regulation guideline is applied or not to the each database in a server.
NERC
The NERC column indicates whether the this regulation guideline is applied or not to the each database in a server.
PCI
The PCI column indicates whether the this regulation guideline is applied or not to the each database in a server.
SOX
The SOX column indicates whether the this regulation guideline is applied or not to the each database in a server.
...