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 CMDB

Integrations > Third Party Integrations > Microsoft SCCM/SMS Integration > How to Populate the CMDB with Data from SCCM/SMS

How to Populate the CMDB with Data from SCCM/SMS

This task describes how to install and use the SMS adapter.

Define the SMS integration

In UCMDB, navigate to Data Flow Management > Integration Studio.
Click the New Integration Point button to open the new integration point Dialog Box.

Click , select the Microsoft SMS adapter, and click OK.

Each out-of-the-box adapter comes predefined with the basic setup needed to perform integration with UCMDB. For information about changing these settings, see "Integration Studio Page" in the HPE Universal CMDB Data Flow Management Guide.

Enter the following information, and click OK:

Name	Description
Credentials	Allows you to set credentials for integration points. For credential information, see Supported Protocols.
Hostname/IP	The host name of the machine where the database of SCCM/SMS is running.
Integration Name	The name you assign to the integration point.
Is Integration Activated	Select this check box to create an active integration point. You clear the check box if you want to deactivate an integration, for instance, to set up an integration point without actually connecting to a remote machine.
Port	The port through which you access the MSSQL database.

Click Test connection to verify the connectivity, and click OK.
Click Next and verify that the following message is displayed: A connection has been successfully created. If it does not, check the integration point parameters and try again.

Define a population job (optional)

The Microsoft SMS adapter comes out-of-the-box with the hostFromSMS Population job, which runs the following predefined query: hostDataFromSMS. For details about this query, see Predefined Query for Population Jobs. This job runs according to a default schedule setting.

You can also create additional jobs. To do this, select the Population tab to define a population job that uses the integration point you defined in Define the SMS integration. For details, see "New Integration Job/Edit Integration Job Dialog Box" in the HPE Universal CMDB Data Flow Management Guide.
Run the population job
Activate the population job in one of the following ways:
- To immediately run a full population job, click . In a full population job, all appropriate data is transferred, without taking the last run of the population job into consideration.
- To immediately run a differential population job, click . In a differential population job, the previous population time stamp is sent to SCCM/SMS, and SCCM/SMS returns changes from that time stamp to the present. These changes are then entered into the UCMDB database.
- To schedule a differential population job to run at a later time or periodically, define a scheduled task. For details, see "Define Tasks that Are Activated on a Periodic Basis" in the HPE Universal CMDB Administration Guide.
Note the replicated CIs are controlled by the integration TQL that is used. You can create additional TQL queries that contain different topologies for use in other jobs.