How to Create a Query to Synchronize the CI Type

The integration uses queries to gather CI attribute values and pass them to your Service Manager system. You must create a query for any CI type you add to the integration. Any query you create must conform to the Query Requirements.

The following steps illustrate how to create a new query named rdbmsData for the SM RDBMS CI type described in previous sections.

1. Log in to UCMDB as an administrator.
2. Navigate to Modeling > Modeling Studio.
3. From the Queries navigation tree, click Integration > Service Manager.
4. Right-click Service Manager, and select the New > Query.

   The Query Definition window opens.

5. Find the CI type that will be the root node of your query from the CI Type Selector. This CI type is typically the one that provides the most attributes for the CI. For example, Managed Object > ConfigurationItem > InfrastructureElement > RunningSoftware > Database > SM RDBMS.
6. Drag the root CI type from the CI Type Selector and drop it into the empty Editing pane. UCMDB displays the icon of the CI type.

   

7. Right-click the CI type icon, and select Query Node Properties. The Node Properties window opens.
8. Change the Element Name to Root.

9. Click OK to save the node properties.

   

10. Find any additional CI types you want to add to the query from the CI Type Selector. These CI types typically provide additional CI attributes. For example, Managed Object > ConfigurationItem > Infrastructure Element > Node.

11. Drag the additional CI type from the CI Type Selector and drop it into the Query Definition pane. UCMDB displays the icon of the additional CI type.

    

12. Create relationships between the Root CI type and the additional CI types as needed. For example, create an SM Link between Root and Node.
    1. Select Root and control-click the additional CI type. For example, Node.
    2. Right-click one of the selected items, and click Add Relationship. The Add Relationship window opens.
    3. Type a Relationship Name. For example SM Link.
    4. Select the relationship direction.

    5. Click OK to add the relationship.

       

13. Repeat step 10 to step 12 for each additional CI type you want to add to the query. For example, SM RDBMS does not need any additional CI types.
14. Click the Save icon to save the query.
    1. In Query Name, type the unique name you want to use for the new query. For example, rdbmsData.
    2. In the folder tree, select the folder in which you want to save the query. For example, Root > Integration > Service Manager > Push.
    3. Click OK. UCMDB adds your new query to the query list.