Example 2: Federate SM Incident Records that Affect a UCMDB Business Service CI

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

The following example illustrates how to federate a list of Service Manager Incident records whose Affected Service or Affected CI field contains a UCMDB Business Service CI.

In this example, IM10005 in SM has an affected service named bizservice1, which was pushed from UCMDB.

Navigate to Modeling > Modeling Studio > Resources.

For Resource Type, select Queries from the list.

Click New > Query.

On the CI Type tab, navigate to ConfigurationItem > BusinessElement > Service > BusinessService, and drag it to the query pane on the right side.

Navigate to ItProcessRecord > Incident, and drag the icon to the query pane.

Click the Create Relationship icon

Select the Incident query node, and drag the arrow from this node to the BusinessService node to create a regular relationship between the nodes.

Select Regular Relationship, and click OK.
Select Membership, and optionally enter a relationship name (for example, Membership). Click OK.

Specify UCMDB as the data source for the BusinessService query node. To do this, follow these steps:

Select the BusinessService query node.
On the lower right pane, click the Data Sources tab and then click Edit.
Make sure that the Local data source (UCMDB only) option is selected.
Click OK.

Repeat the steps above to specify your integration point as the data source for the Incident query node (for example, sm_integration).

Click the Calculate Query Result Count icon . The number of SM Incidents and the number of their affected UCMDB Business Service CIs are displayed.