SCCM connector fails on import 500_sccm_inv_raw_arp.xml

Document ID : KB000004424
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

While running the 500_sccm_inv_raw_arp.xml; an error is recieved:

"Conversion failed when converting date and/or time from character string."

 

Environment:
All
Cause:

The import fails because SCCM has different types of date format stored on InstallDate0. 

Resolution:

There are some non-US systems in SCCM and their install date is recorded slightly different on those systems. Our OOTB connector cannot handle that difference and would need some work to correct.

The immediate solution is to just comment out lines where this is referenced (date). Missing this data will not impact any compliance calculations.

 

 

(example below)

Put /* before CASE and follow with */ immediately after END AS installation_date

You will also need to remove the comma after the line right before CASE

 

Looks like this....

 

newestDevices.Netbios_Name0 AS import_device_id [comma removed from this line]

 

/*

CASE

Stuff

END AS installation_date

*/