Example 2: Federate SM Incident Tickets 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.

Navigate to Modeling > Modeling Studio > Resources.

For Resource Type, select Queries from the list.

Click New > Query.

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

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

Click the Create Relationship button

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_1). Click OK.

Specify UCMDB as the data source for the BusinessService query node.

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.