Specify Node Group Additional Filters

[Note to writers: do not show examples with * or ? wildcards at beginning of search string for this feature. It is allowed but performance is bad.]

Use the Additional Filters Editor to create expressions that refine the requirements for membership in a Node Group. Make sure to design any complex Additional Filters offline as a Boolean expression first. This method can help to minimize errors when entering your expressions using the Additional Filters Editor.

If any Additional Filters are created, NNMi combines any Device Filters and Additional Filters using the AND Boolean operator as follows: 

  • NNMi first evaluates any Device Filters. Nodes must match at least one Device Filter specification to belong to this Node Group.
  • NNMi then evaluates the Additional Filters expression. Nodes must also match all Additional Filters expression specifications to belong to this Node Group.

To create an Additional Filters expression:

  1. Establish the appropriate settings for the Additional Filters you need (see the Additional Filters Editor Choices and Additional Filters Editor Buttons table). See Guidelines for Creating Additional Filters for Node Groups for more information.

    1. Plan out the logic needed for your Filter String.
    2. Use the buttons on the bottom half of the Additional Filters Editor to establish the logic structure.

      For example, to establish the following structure, select Insert, then click AND, then NOT, and then AND a second time:

      (( ) AND NOT ( ))

    3. Now place your cursor in a location within the displayed Filter String, and use the top half of the filter editor to define the parameters of the selected filter requirement.

      For example, select a set of parentheses and use the Insert button to specify the filter requirement within those parentheses:

  2. Click  Save and Close.
Additional Filters Editor Choices for Node Groups
Attribute Description
Attribute

NNMi provides Additional Filters codes for a subset of object attributes. For more information about the available Additional Filter codes for each NNMi object type, click the link:

Operator

The standard query language (SQL) operations to be used for the search.

Note Only the is null Operator returns null values in its search.

Valid operators are described below.

Value

The value for which you want NNMi to search.

Note the following:

  • The values you enter are case sensitive.
  • NNMi displays a variable number of value fields depending on the Operator selected. For example, the between Operator causes two value fields to be displayed.
  • The in and not in operators require that each value be entered on a separate line.
  • When entering a value for the Capability attribute, copy and paste the Unique Key value from the Node form: Capability tab.

Additional Filters Editor Buttons
Button Description
Append Appends the current expression (Attribute, Operator, and Value) to the selected expression already included in the Filter String.
Insert Inserts the current expression (Attribute, Operator, and Value) in front of the cursor location within the Filter String.
Replace Replaces the selected expression with the expression displayed in the Attribute, Operator, and Value fields.
AND

Inserts the AND Boolean Operator in the selected cursor location.

Note View the expression displayed under Filter String to see the logic of the expression as it is created.

OR

Inserts the OR Boolean Operator in the current cursor location.

Note View the expression displayed under Filter String to see the logic of the expression as it is created.

NOT

Can be used in any part of the Filter String to specify that NNMi should exclude nodes with values that pass the expression that immediately follows the NOT.

For example, when evaluating the following Filter String, NNMi includes nodes with a hostname that contains router, followed by any number of characters, followed by xyz.com and excludes any nodes with a Device Profile that includes Cisco as the Vendor value:

(hostname like router*.xyz.com OR NOT (devVendorNode = Cisco))

EXISTS

Used for filters that include Capabilities or Custom Attribute names and values in the Filer String. Indicates that you want NNMi to consider nodes that have Capabilities or Custom Attributes when evaluating the Filter String.

Tip When creating complex Filter Strings that include customAttrName and customAttrValue pairs as one component of an "or" statement, to prevent NNMi from excluding Nodes that have zero Custom Attributes, use EXISTS or NOT EXISTS criteria for the customAttrName and customAttrValue pair definitions.

Otherwise Nodes that do not have any Custom Attributes are automatically excluded even if they have values that pass other aspects of your filter.

For example, when evaluating the following Filter String, NNMi includes nodes with a hostname that includes router, followed by any number of characters, followed by xyz.com as well as any nodes that have the Custom Attribute edge and that edge value is true:

(hostname like router*.xyz.com OR EXISTS((customAttrName=edge AND customAttrValue=true)))

NOT EXISTS

Used for filters that include Capabilities or Custom Attribute names and values in the Filer String. Indicates that you want NNMi to consider nodes that do not have any Capabilities or Custom Attributes when evaluating the Filter String, but exclude the nodes that match the expression that follows the NOT EXISTS.

Tip When creating complex Filter Strings that include customAttrName and customAttrValue pairs as one component of an "or" statement, to prevent NNMi from excluding Nodes that have zero Custom Attributes, use EXISTS or NOT EXISTS criteria for the customAttrName and customAttrValue pair definitions.

Otherwise Nodes that do not have any Custom Attributes are automatically excluded even if they have values that pass other aspects of your filter.

For example, when evaluating the following Filter String, NNMi includes nodes with a hostname that includes router, followed by any number of characters, followed by xyz.com and excludes any nodes with Custom Attribute edge and that edge value is true.

(hostname like router*.xyz.com OR NOT EXISTS((customAttrName=edge AND customAttrValue=true)))

Delete

Deletes the selected expression.

Note If the Boolean Operator is selected, the Additional Filters Editor deletes all expressions associated with the Boolean Operator.