Versions Compared

Key

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

These The Specify Event Filter Criteria windows allow you to use words, phrases, and wildcards to further define your audit event filter criteria. For example, you can use this window to filter out events that occur on all databases in your environment that use a naming convention such as "dbname01".

Available actions

Filter events on objects whose names match the listed words, phrases, or wildcards

...

Use the following examples to help you define wildcard match criteria. Note that wildcard matches are not case-sensitive.

If you want to match …Use …Examples
 
 


One digit#You want:
All databases with name of testNN
You specify:
test##
You get:
Test00Test01test#1
One character?You want:
All databases with name of testXX
You specify:
test??
You get:
Test00Test01TEST?htester
Any character*You want:
All databases that start with test
You specify:
test*
You get:
Test00Test01test0101test4metest#1TEST?htest*devtestertest

<Event filter criteria> to match

Allows to you change the list of match criteria. You can add a new criterion or remove an existing criterion.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 

...

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

...

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

...