How to Define Population Jobs in UCMDB

A CI or relationship population job copies certain types of CIs or relationships from Service Manager to UCMDB.

To define a CI or CI relationship population job, follow these steps:

1. Log in to UCMDB as an administrator.
2. Navigate to Data Flow Management > Integration Studio. UCMDB displays a list of existing integration points.
3. Open the integration point that you created for Service Manager.
4. Click the Population tab, and add a new job as follows.

   Note UCMDB creates several default population and data push jobs when creating an integration point. The following table lists the default population jobs and their queries. If needed, you can create, update or remove queries for each job.

   Queries for CI / CI relationship population

   Integration Job	Queries for CI / CI relationship population
   SM Configuration Item Population job	Out-of-the-box, the following queries are available for this job, which populates UCMDB with CI records from Service Manager: SM Business Service Population 2.0: Populates UCMDB with CIs of the bizservice type. SM RunningSoftware Population 2.0: Populates UCMDB with CIs of the RunningSoftware type. SM Computer Population: Populates UCMDB with CIs of the computer type. SM CLIP Down Time Population 2.0: Populates UCMDB with CIs of the planned outage type.
   SM Relations Population job	Out-of-the-box, the following queries are defined for this job, which populates UCMDB with CI Relationship records from Service Manager: SM Biz To Biz With Containment 2.0: Populates UCMDB with CI relationships in which a bizservice CI contains another. SM Biz To Biz With Usage 2.0: Populates UCMDB with CI relationships in which a bizservice CI uses another. SM Biz To Computer With Containment 2.0: Populates UCMDB with CI relationships in which a bizservice CI contains a computer CI. SM Biz To Computer With Usage 2.0: Populates UCMDB with CI relationships in which a bizservice CI uses a computer CI. SM Computer To Computer With Connects 2.0: Populates UCMDB with CI relationships in which a computer CI connects to another. SM Biz To Software With Containment 2.0: Populates UCMDB with CI relationships in which a bizservice CI contains a software CI. SM Biz To Software With Usage 2.0: Populates UCMDB with CI relationships in which a bizservice CI uses a software CI. SM Computer Composition Software 2.0: Populates UCMDB with CI relationships in which a computer CI connects to a software CI. SM CI Connection Down Time CI 2.0: Populates UCMDB with CI relationships in which a CI connects to a down time CI.

   1. Click the New Integration Job icon .
   2. Type a Name for the integration job. For example, CI_Population_Job1.
   3. Click the Add Query icon to add existing queries to the job (see the table above).
   4. Select the Allow Integration Job to delete removed data check box for the query.
   5. Click OK to save the job.
5. Run the job manually to see if the integration job works properly.
   1. To populate UCMDB with all relevant data for the job, click the icon.
   2. To populate UCMDB with only CI data changes since the job last ran, click the icon.
6. Wait for the job to complete, and click the Refresh icon multiple times as needed until the job is completed.

   Note When the job is completed, the job status becomes one of the following: Succeeded, Passed with failures, or Failed.

7. Click the Statistics tab to view the results. If the job failed, click the Query Status tab and Job Errors tab for more information. For details, see Troubleshooting Population Issues.
8. Click OK.

If the job is completed successfully, you can view the transferred CI data in UCMDB and schedule the job so that it can run automatically.