Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Privileged/Trusted Users report lists all trusted and privileged users set in each server instance and database. Use this report to monitor which Trusted and Privileged Users were set to during a snapshot in time. 

Image Added

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.

Available actions

Server Instance

Allows you to select a registered instance on which you want to report. Select ALL to report on all instances.

Databases

Allows you to select or type the name of one or more databases on which you want to report.

Login

Allows you to select the login from the drop down list of available logins. Select ALL to report on all logins.

Role

Allows you to define the type of role for which you want this report to filter on. Select one of the Roles to filter the report on from the drop down menu option.

User Type

Allows you to select the type of user for which you want this report to filter on. Select between the following options; Both, Trusted or Privileged.

Default columns

Logins/Roles

The Logins/Roles column displays the name of the login or role. 

Server/Database

The Server/Database column displays the name of the server or database. 


Image Added



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...