How to Populate the CMDB with Data from SCCM/SMS

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

1. Define the SMS integration

   1. In UCMDB, navigate to Data Flow Management > Integration Studio.

   2. 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 Data Flow Management section of the UCMDB Help.

   • 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.

   3. Click Test connection to verify the connectivity, and click OK.

   4. 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.

2. 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 Data Flow Management section of the UCMDB Help.

3. 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 Administer section of the UCMDB Help.

   
   

   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.