How to Create a Query to Push Each Relationship Type of the CI Type

Once you have created CI Relationship types for the new CI type, you must create a query for each relationship type to push it to Service Manager.

To create a new query called cost_costcategory_ownership_relation_push 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 displays.
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 button.
   2. Click the Cost node, and drag the arrow from it to the CostCategory node.
   3. Select Regular Relationship, and click OK.
   4. Select Connection > Ownership, 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 button, and save the query as described in the following.
   1. Enter a query name. For example, cost_costcategory_ownership_relation_push.
   2. Select the Integration > SM Sync > 9.xx folder.
   3. Click OK.

      

The query is now created. You are ready to map this query to an XSL transformation file.