SCCM and ServiceNow

[nataliya_b]

Hello All

Our SCCM got updated to 1906, that made our ServiceNow Remove Software import stopped working (plugin SCCM 2012 v2 activated)

This SQL query does not bring any records. 

SELECT * FROM

(SELECT

MachineID as ResourceID,
InstanceKey + 32000000 as GroupID,
DelDate

FROM SCCM_Ext.Add_Remove_Programs_DATA_DD

UNION

SELECT
MachineID as ResourceID,
InstanceKey +64000000 as GroupID,
DelDate

FROM SCCM_Ext.Add_Remove_Programs_64_DATA_DD)t

We tried to use following query, but data validation results are not consistent. 

SELECT * FROM

(SELECT

MachineID as ResourceID,
InstanceKey + 32000000 as GroupID,
TimeKey as DelDate

FROM dbo.Add_Remove_Programs_DATA

UNION

SELECT
MachineID as ResourceID,
InstanceKey +64000000 as GroupID,
TimeKey as DelDate

FROM dbo.Add_Remove_Programs_64_DATA)t

Does anyone have similar issue? Are we using correct tables in new query? 

Please help.

[Mark Lanning]

Had the same issue

I had to update the Data Sources on SCCM Integration for SCCM 2016 Software (Al).

Time Format was incorrect.

I have updated the TimeStamp on the Data Source from '2019-05-17 19:16:58.000 +00:00' to '2019-05-17 19:16:58.000' and that fixed my Issue

Mark

[nataliya_b]

thank you Mark,what about SQL query, did you do any changes to it?

[Mark Lanning]

No I just had to change the Time Stamp

[nataliya_b]

thank you Mark

Tried to change TimeStamp, did not help, still receiving "0" records 😞