Versions Compared

Key

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

These The Specify Alert Criteria windows allow you to use words, phrases, and wildcards to further define your alert rule criteria. For example, you can use this window to find and alert on all databases in your environment that use a naming convention such as "dbname01".

Available actions

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

To alert on objects with specific names or naming conventions, click listed, and then specify the words, phrases, or wildcards the object names should match. You can add more than one criterion.

Alert on objects whose names are not listed 

To alert on objects whose names are not listed, click except those listed, and then specify the words, phrases, or wildcards the object names should not match. You can add more than one criterion.

Available fields

 Match all <alert criteria> 

Allows you to indicate whether the alert rule should generate alerts for objects that match the listed names, phrases, or wildcards.

Specify <alert criteria> to match 

Allows you to define match criteria. Match criteria can include exact names, words, phrases, or wildcards. For each match criterion you want to define, type the appropriate word, phrase, or wildcard in the provided field, and then click Add.

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

<Alert criteria> to match

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

...

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

...



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