Versions Compared

Key

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

Event Filters determine which collected SQL events should be kept for processing by the Collection Server. Like Same as your audit settings, the Event Filters should correlate with the SQL events you need to track on the SQL server in order to meet your compliance objectives.

After receiving the trace files from the SQLcompliance SQL Compliance Manager Agent, the Collection Server applies your Event Filters. Any matching events are permanently deleted and eliminated from the data stream. All remaining events are processed for alerts and stored in the appropriate Repository database.

Info

Anchor
When you enable
SQLCM-6132
SQLCM-6132
When enabling Sensitive Column auditing on a table, the Collection Server preserves all SELECT events SELECT and DML events associated with the audited columns even though you may have created an event filter to exclude SELECT and/or DML events.

Excerpt
SQL Compliance Manager audits all activity on your server. Learn more > >

...

Therefore, when using an Event Filter for a specific Login, all events captured get filtered except for the Sensitive Column SELECT and/or DML operations. 



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

...