SCCM Computer Identity Import not populating cmdb_ci_computer table

[John Snow1]

Hello,

SCCM import is not pulling computers into the CMDB_CI_Computers table. Previously this function worked but, I had created a duplicate transform map that was pulling in duplicate devices. I removed that duplicate transform map and deleted the table entries in the CMDB_CI_Computers table via the Tables and Columns module, and now the default "Computer Identity" import is not pulling in anything from our SCCM tables. I copied the SQL query in the default data source and it is working fine outside of Servicenow in SQL studio.

[John Snow1]

Also when I go to load 20 test results this is what I am getting.

[Brent Sutton · Accepted solution]

Hi John, when you went to reload the data did you clear the "Last run datetime" field in the "SCCM 2012 v2 Computer Identity" data source? If not, you would only see the changes from the previous scheduled load.

If you clear any values in the "Last run datetime" field, save the data source, and then rerun the data load you should see all the SCCM records get loaded.

If this fails then you could look at your "versions" related list (you'll need to add it to the data source form). You can then compare your current version against the OOB version and try to troubleshoot from there.

Hope this helps,

Brent

[John Snow1]

You Got me half way there THANKS!!, It managed to pull the correct number of devices into the import set. However when it went to transform all records had the error,

"Unable to resolve target record, coalesce values not present"

After digging through google I found the cause of that error and a possible solution but I am not sure.

Data imports are successful, and the records can be seen in the staging table. However, the corresponding records in the target table are not created/updated, indicating problems during the transform.

The error: Unable to resolve target record, coalesce values not present can be seen in the Error field of the records in the staging table that failed.

• Asynchronous transform - Most scheduled data imports are asynchronous. All the import data is first saved in the import set table and transformed only after the import is complete.

• For asynchronous imports, ensure that the coalesce value is not empty or NULL.
  • If the coalesce value is empty, check Coalesce empty fields box in the transform map.
• For Coalesce empty fields — Select this check box to match an empty source field value to an empty target field value. For example, the user transform map coalesces on the email field. With this option selected, a source record containing an empty email address coalesces to a target record containing an empty email address.

So I checked the Coalesce empty fields box and boom my import went smoothly.

And right as I found this my HI-Portal rep instructed me to do the exact same thing. The OOB SCCM plugin coalesces on the Sys ID and that Sys ID   had already been discovered before so it would not transform. Checking that box allowed the transform to happen.  

[Brent Sutton]

Glad you got it working John! Bit of team effort