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, navigate 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 icon , and then type a query name and select a location in which to save the query (for example, select the Root folder).

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

   UCMDB returns the query result count. For example, the following figure shows that there are a total of 116 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 record from the list, and click the Properties icon to view its details.