Full data is not getting populating from SCCM to ServiceNow.

[Mayura1997]

Hi,

Records imported in servicenow is very less as compared to the data in SCCM. We are using OOB SCCM query only.

Is there any kind of setting in ServiceNow to be changed?

Thanks,

Mayura

[Community Alums · Accepted solution]

HI @Mayura Thatikonda ,

Go to import set table and include state and comments field in there... In comments you will get the reason why the record is ignored or skipped.

Also, 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.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Check the SQL Statement used in the data sources. Is it fetching the same results when you execute on the SQL Server directly.

[#4]

It would be helpful if you gave some examples of what is not being populated.  As a general statement ServiceNow and SCCM have 2 different data models so not every field from SCCM will translate to a field in ServiceNow.  Having specific fields that you are concerned about would help the community help answer your inquiry.