Example 1: Federate All SM Incident Tickets

This example illustrates how you retrieve information of all Incident records that exist in Service Manager.

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 Types tab, go to ItProcessRecord > Incident, and drag it to the query pane on the right side.

   

6. Specify Service Manager as the data source for the Incident query node.
   1. Select the Incident query node, click the Data Sources tab on the lower right pane, and then click Edit.
   2. Select the Select integration points option, and then select your integration point name (for example, sm_integration). Click OK.

   

7. Click the Save button , and then type a query name and select a location in which to save the query (for example, select the Root > Integration > SM Query folder).

   

8. Select the Incident query node, and then click the Calculate Query Result Count button .

   UCMDB returns the query result count. For example, the following figure shows that there are a total of 131 Incident records in Service Manager.

   

9. Right-click the Incident query node, and select Show Element Instances. UCMDB displays a list of all Incident records that exist in Service Manager.

   

10. Select an Incident ticket from the list, and click the Properties button to view its details.