While running the 500_sccm_inv_raw_arp.xml; an error is recieved:
"Conversion failed when converting date and/or time from character string."
The import fails because SCCM has different types of date format stored on InstallDate0.
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.
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]
END AS installation_date