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.  Audit Control Changes Report lists all changes and updates to SQL Compliance Manager audit settings. Use this report to diagnose audit data integrity issues and control all changes to the audit settings in your environment. 

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.(Screenshot)

Available actions

Server Instance

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

Login

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

Start Date

The Allows you to select the start date for the range from which you want to report.   

End Date

The 

Start Time of Day

End Time of Day

...

Allows you to select the end date for the range from which you want to report. 

Start Time - Hour

Allows you to select the exact starting hour of the day for the range from which you want to report.  

Start Time - Min

Allows you to select the exact starting minute of the day for the range from which you want to report.  

Start Time - AM/PM

Select between AM or PM from the drop down list to configure the Start Time for Each Day range from which you want to report.

End Time - Hour

Allows you to select the exact ending hour of the day for the range from which you want to report.  

End Time - Min

Allows you to select the exact ending minute of the day for the range from which you want to report.  

End Time - AM/PM

Select between AM or PM from the drop down list to configure the End Time for Each Day range from which you want to report.

Event

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

Run Report

Click this button to Run the report.

...

Default columns

Time

The Time column displays the date and time when the event was captured. 

Event

The Event column displays indicates the ... type of event captured.

LoginUser

The User Login column displays a description the login name of the user who performed the event captured. 

SQL Server Instance

The SQL Server Instance column displays the ... name of the Instance Server where the event was captured.

Description

The Description column displays the ...column displays a description of the event captured. 


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

...