Working with criteria and filter expressions in the Operations Manager 2007 adapter
This section provides information about working with criteria and filter expressions in the BMC Atrium Orchestrator Application Adapter for Microsoft System Center Operations Manager 2007.
Filter expressions
The following table illustrates examples of using different operators with filter expressions.
Table of filter operators
Operator |
Example |
True/False |
---|---|---|
equals |
10 equals 10 |
true |
not equals |
10 not equals 10 |
false |
matches |
"book" matches "[iou]" |
true |
For the operator matches, the expression can assume the following formats:
Formats for matches filter operator
Format |
Logic |
Example |
---|---|---|
value |
Matches exact characters anywhere in the original value |
"book" matches "oo" |
. (dot) |
Matches any single character |
"copy" matches "c..y" |
[value] |
Matches at least one of the characters in the brackets |
"big" matches "b[iou]g" |
[range] |
Matches at least one of the characters within the range Use hyphen (-) to specify contiguous characters. |
"and" matches "[a-e]nd" |
Criteria expression syntax
You can construct a criteria expression to retrieve objects in the Microsoft System Center Operations Manager 2007 database. The following sections provide syntax reference information that is useful when creating a criteria expression.
Comparison operators
You can use the following comparison operators when constructing a criteria expression:
Comparison operators
Operator |
Description |
Syntax |
---|---|---|
equals |
Evaluates to true if the left and right operands are equal |
mymachine.mydomain.com |
not equals |
Evaluates to true if the left and right operands are unequal |
mymachine.mydomain.com |
like |
Evaluates to true if the left operand matches the pattern that is defined by the right operand |
'SQL%' |
in |
Evaluates to true if the value of the left operand is in the list of values defined by the right operand Note The in operator is valid for use only with properties of type globally unique identifier (GUID). |
080F192C-52D2-423D-8953-B3EC8C3CD001,080F192C-53B2-403D-8753-B3EC8C3CD002 |
and |
Evaluates to true if the left and right operands are both true |
Name = 'SQL%' and Description LIKE 'MyData%' |
or |
Evaluates to true if the left or right operand is true |
Name = 'SQL%' or Description LIKE 'MyData%' |
Note
For all the operators except in, if the value contains a comma (,) as one of the characters, the value is included in single quotation marks so that the value is interpreted as single value rather than a set of comma-separated values. For example, 'test,test'.
Wildcard characters
The following table defines the wildcard characters that you can use to construct a pattern when using the LIKE operator:
Wildcard characters
Wildcard |
Description |
Example |
---|---|---|
% |
Specifies a wildcard that matches any number of characters |
Name LIKE 'SQL%' |
_ (underscore) |
Specifies a wildcard that matches a single character |
Name LIKE 'SQL200_' Note The expression evaluates to false for "SQL200" because the symbol _ must match exactly one character in the Name value. |
[ ] |
Specifies a wildcard that matches any one character that is enclosed in the character set Note Brackets are also used when qualifying references to MonitoringObject properties. |
Name LIKE 'SQL200[05]' |
Comments
Log in or register to comment.