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)`

Universal DiscoveryContent Pack 28.00 (CP28)

Integrate > Third Party Integrations > Microsoft SCCM/SMS Integration > How to Customize the Integration Data Model in UCMDB

How to Customize the Integration Data Model in UCMDB

Out-of-the-box CIs for SCCM/SMS integration can be extended in one of the following ways:

To add an attribute to an existing CI type:

If the attribute you want to add does not already exist in the CMDB, you need to add it. For details, see "Add/Edit Attribute Dialog Box" in the Modeling section of the UCMDB Help.

Go to the orm.xml file as follows: Data Flow Management > Adapter Management > SMS Adapter > Configuration Files > orm.xml.
Locate the generic_db_adapter.[CI type] to be changed, and add the new attribute.
Ensure that the TQL queries that include this CI type have the new attribute in their layouts as follows:
1. In the Modeling Studio, right-click the node where you want to include the attribute.
2. Select Query Node Properties.
3. Click Advanced Layout Settings and select the new attribute.

To add a new CI Type to the Generic DB Adapter:

In UCMDB, create the CI Type that you want to add to the adapter, if it does not already exist. For details, see "Create a CI Type" in the Modeling section of the UCMDB Help.
Go to the orm.xml file as follows: Data Flow Management > Adapter Management > SMS Adapter > Configuration Files > orm.xml.
Map the new CI type by adding a new entity called generic_db_adapter.[CI type].

For more details, see "The orm.xml File" in the Developer Reference section of the UCMDB Help.

Create queries to support the new CI types that you have added. Make sure that all mapped attributes are selected in the Advanced Layout settings:
1. In the Modeling Studio, right-click the node where you want to include the attribute.
2. Select Query Node Properties.
3. Click Advanced layout settings and select the new attribute.
In UCMDB, navigate to Data Flow Management > Integration Studio.
Edit the SMS integration point to support the new CI type by selecting it either for population or for federation.
If the new CI type is for population, edit the population job that you created above.

Send Help Center feedback