Example 3: Federate Incident, Change, and Problem Record Data from Service Manager for UCMDB CIs

The following example illustrates how to retrieve information of Incident, Change and Problem records in Service Manager that affect a UCMDB Business Service CI.

1. Log in to UCMDB as an administrator.
2. Navigate to Modeling > Modeling Studio > Resources.
3. For Resource Type, select Queries from the list.
4. Click New > Query.
5. On the CI Type tab, go to ConfigurationItem > BusinessElement > Service > BusinessService, and drag it to the query pane on the right side.
6. Go to ItProcessRecord, and drag Incident, Problem, and RequestForChange to the query pane.

7. Click the Create Relationship icon to create regular relationships between the BusinessService node and the other nodes, as shown in the following figure.

   

8. Select each node and click the Data Sources tab to specify a data source for each node.
   1. For the BusinessService node, specify UCMDB as the data source.
   2. For the Incident, Problem, and RequestForChange nodes, specify your integration point as the data source (sm_integration in this example).
9. Save the query.
10. Optionally, edit the BusinessService node properties as needed.
    1. Select the BusinessServic node, and click Edit on the lower right pane.

    2. Click the Cardinality tab. The default Cardinality setting is displayed.

       

    3. If you wish, change either or both of the AND operators to OR. This will change the filter criteria and therefore the query results.

       

11. Click the Preview icon to view the query results.

    

     

12. Select each SM Incident record from either the CI Selector pane or the query pane, and click the Properties icon to view its details.
13. Select each UCMDB CI record from either the CI Selector pane or the query pane, and on the Related CIs tab click Show Related CIs to view its related CIs in both SM and UCMDB.