ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

SCCM connector fails on import 500_sccm_inv_raw_arp.xml


Article ID: 4424


Updated On:


CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


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.



(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]





END AS installation_date