Working with criteria and filter expressions in the Operations Manager 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.
The following table illustrates examples of using different operators with filter expressions.
Table of filter operators
10 equals 10
10 not equals 10
"book" matches "[iou]"
For the operator matches, the expression can assume the following formats:
Formats for matches filter operator
Matches exact characters anywhere in the original value
"book" matches "oo"
Matches any single character
"copy" matches "c..y"
Matches at least one of the characters in the brackets
"big" matches "b[iou]g"
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.
You can use the following comparison operators when constructing a criteria expression:
Evaluates to true if the left and right operands are equal
Evaluates to true if the left and right operands are unequal
Evaluates to true if the left operand matches the pattern that is defined by the right operand
Evaluates to true if the value of the left operand is in the list of values defined by the right operand
The in operator is valid for use only with properties of type globally unique identifier (GUID).
Evaluates to true if the left and right operands are both true
Name = 'SQL%' and Description LIKE 'MyData%'
Evaluates to true if the left or right operand is true
Name = 'SQL%' or Description LIKE 'MyData%'
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'.
The following table defines the wildcard characters that you can use to construct a pattern when using the LIKE operator:
Specifies a wildcard that matches any number of characters
Name LIKE 'SQL%'
Specifies a wildcard that matches a single character
Name LIKE 'SQL200_'
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
Brackets are also used when qualifying references to MonitoringObject properties.
Name LIKE 'SQL200'