SCCM and ServiceNow

nataliya_b · ‎10-25-2019

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.

nataliya_b · ‎12-03-2019

Just would like to give the summary for this, in case anyone would have the issue in the future

If your SCCM gets upgraded to 1906 and your ServiceNow stops getting removed software records - possible cause - deactivated triggers (due to upgrade) in SCCM db.
These triggers shall be activated and running
tr_Add_Remove_Programs_DATA_DD, tr_Add_Remove_Programs_DATA_64_DD

for ServiceNow to receive removed software records.

The ServiceNow SCCM set up remains the same, no changes.

View solution in original post

nataliya_b · ‎01-14-2020

hi Frank, what version of SCCM did you upgrade to?

Sorry, i cannot provide files as I am not supporting SCCM, i have no sufficient access.

Btw, MS says it is their bug, is there any way you contact MS regarding this?

Frank1975 · ‎01-15-2020

Hi nataliya,

the SCCM Team has upgraded from 1902 to 1906.

thanks

Frank

Community Alums · ‎01-21-2020

Hi Frank,

Are you still facing this issue?

Can you tell me what SCCM plugin version you're using, as well as the data sources that are enabled.

Frank1975 · ‎01-21-2020

Hi reece,

yes we are still facing this issue:

Here is what we use :

Plugin : SCCM 2016

Data Source : All Data Sources except the 2 for AI (not configured in our SCCM)

Service Now Version Madrid Patch 7 Hotfix 1

thanks

Frank

Community Alums · ‎01-22-2020

Hi Frank,

Can you provide me with the SQL Statement you're using for SCCM 2016 Removed Software please?