How to Define an Enrichment Rule – Scenario

This task describes how to create the following Enrichment rule:

An IP Address CI is connected to two identical Node CIs: one Node CI is identified by its IP address and the other is identified by its lowest MAC address. For every such instance, delete the Node CI that is identified by its IP address from the CMDB.

1. Create an Enrichment TQL Query

   To create an Enrichment TQL query, you need to define an Enrichment rule and then add the regular TQL query nodes and relationships that define the query.

   Note You can add Enrichment query nodes and relationships only after at least one regular query node has been added to the query.

   Select Managers > Modeling > Enrichment Manager. For details about how to create an Enrichment TQL query, see New Enrichment Rule/Enrichment Rule Properties/Save As Enrichment Rule Wizard. For details about how to add query nodes and relationships to a query, see How to Add Query Nodes and Relationships to a TQL Query.

   You can add query nodes of a federated CI type to the Enrichment TQL query, but if the actions defined in the Enrichment rule affect those query nodes, their source is automatically set to UCMDB when you save the rule. You cannot update or delete a federated query node or a relationship to or from a federated query node.

   Example of an Enrichment TQL Query:

   A new Enrichment TQL query called doubleHosts1 (located under the Network folder) is created in Enrichment Manager.

   

   The doubleHosts1 Enrichment rule is displayed in the Enrichment Rules pane.

   

   In this Enrichment TQL query, an IP Address query node is linked to two query nodes of type Node by a Containment relationship. The query results must comply with the direction of the arrows.

   

   Note A TQL query is subject to certain validation restrictions. For details, see Troubleshooting and Limitations – Topology Query Language.

2. Define the Query Node of Type Node that Is Identified by its Lowest MAC Address

   At the top of the Enrichment Manager page, select Query mode. In the editing pane, right-click the required query node of type Node, select Query Node Properties to open the Query Node Properties dialog box. Then define an attribute condition in the Attribute tab. For details on how to define an attribute condition, see Query Node/Relationship Properties Dialog Box.

   Example of an Attribute Condition Definition that Identifies the Node by its Lowest MAC Address:

   In the Attribute tab, this attribute condition definition identifies the required Node by its lowest MAC address.

   • Attribute name — Node is Complete

   • Operator — Equal

   • Value — True

3. Define the Query Node of Type Node that is Identified by its IP Address

   At the top of the Enrichment Manager page, select Query mode. In the editing pane, right-click the required query node of type Node, and select Query Node Properties to open the Query Node Properties dialog box. Then define two attribute conditions in the Attribute tab. For details on how to define an attribute condition, see Query Node/Relationship Properties Dialog Box.

   Example of an Attribute Condition that Enables a Node to Be Identified by its IP Address:

   This attribute condition is the first attribute condition you need to define in the Attribute tab to enable the query node of type node to be identified by its IP Address.

   Attribute name — Node is Complete

   Operator — Equal

   Value — False

   This is the second attribute condition you need to define in the Attribute tab to enable the query node of type node to be identified by its IP address.

   Attribute name — Node is Complete

   Operator — Is null

   Value — Value cannot be changed

4. Define the Enrichment Rule

   Define the Enrichment rule that deletes all instances of the query node of type Node that are identified by their IP addresses. From the toolbar, select Enrichment mode. In the Enrichment Rules pane, select the doubleHosts1 Enrichment rule. Then right-click the query node of type Node that is identified by its IP address and select Delete Relationship/Query Node Item.

   Example of a Query Node of Type Node Containing a Removed Indicator:

   The query node of type Node now has a removed indicator to denote that all node instances that have identical attribute and cardinality settings are removed from the CMDB. The Enrichment query now looks like this.

   

Related Information