Integrate > Micro Focus UCMDB > Using the ServiceManagerAdapter9.41 Adapter > Integration Setup > Federating SM Ticket Data to UCMDB > Example 3: Federate SM Incident, Change and Problem Ticket Data of UCMDB CIs

Example 3: Federate SM Incident, Change and Problem Ticket Data of UCMDB CIs

The following example illustrates how you retrieve information of SM Incident, Change and Problem tickets 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 button to create regular relationships between the BusinessService node and the other nodes as shown in the following figure.

  8. For the BusinessService node, specify UCMDB as the data source.
  9. For the Incident, Problem, and RequestForChange nodes, specify your integration point as the data source.
  10. Save the query.
  11. 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.
    4. This will change the filter criteria and therefore the query result.

  12. Click the Preview button to view the query result.

  13. Select each SM Incident record from either the CI Selector pane or the query pane, and click the Properties button to view its details.
  14. 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.