Where Clauses allow case-insensitive 'string' pattern matching operations with specific wildcard characters in conjunction with the 'Matches' and 'Matches Regex' operators. The specified wildcard characters are as follows:
* Matches zero or more of any character
? Matches one of any character
\* Matches literal '*'
\? Matches literal '?'
\\ Matches literal '\'
\x Matches literal '\' and literal 'x' if x is not * or ? or \
NTJOBS.NAME MATCHES "ir*.exe"
This will return job names starting with "ir" string and ending with ".exe".
Wildcard Button on the Windows Client
When using the Windows Client, the Where Clause tab of the Threshold or Data View Definition properties dialog will contain a Wildcard button. Using this button will open a dialog box containing the permitted Wildcard characters, as illustrated below:
Any of these options can be selected for insertion into the Where Clause statement.