How to Create a Query to Push a Relationship Type

Once you have created a relationship between two CI types, you must create a query to push the relationship to Service Manager.

To create a new query called Cost CostCategory Ownership Relations for Ownership relationships between the Cost and CostCategory CI types:

1. Log in to UCMDB as an administrator.
2. Navigate to Modeling > Modeling Studio.
3. Click New > Query. The Query Definition pane is displayed.

4. From the CI Type Selector, drag the Cost and CostCategory CI types to the query pane.

   

5. Create an Ownership relationship from Cost to CostCategory.
   1. Click the Create Relationship icon.
   2. Select the Cost node, and drag the arrow from it to the CostCategory node.
   3. Select Regular Relationship, and click OK.

   4. Select Connection > Ownership, enter Ownership for Relationship Name, and click OK. An Ownership relationship is created between the CI types.

      

6. Right-click the relationship arrow, and select Relationship Properties.

7. Change the element name from Ownership to Root (or a name starting with “Root_”), and then click OK.

   

   

8. Click the Save icon, and save the query as described in the following.
   1. Enter a query name. For example, Cost CostCategory Ownership Relations Push.
   2. Select the Integration > Service Manager > Push folder.
   3. Click OK.

The query is now created. You are ready to add this query to the push configuration file (smPushConf.xml).