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.

[Community Alums]

Hi Nataliya,

I actually spent most of yesterday working with this issue and the best results I received was with the following SQL;

SELECT

MachineID as ResourceID,
InstanceKey as GroupID,
TimeKey as DelDate

FROM INSTALLED_SOFTWARE_HIST

Please note that I'm using the SCCM 2016 Removed Software (AI) data source

I'm going to leave that running for the next week or so and see what results I get.

[nataliya_b]

hi Reece

just fyi: SCCM expert advised us to activate triggers

tr_Add_Remove_Programs_DATA_DD

tr_Add_Remove_Programs_DATA_64_DD

on SCCM tables Add_Remove_Programs_DATA_DD and Add_Remove_Programs_DATA_64_DD

They were deactivated due to upgrade on our side. It is possible cause of not bringing data with SQL query we had.

We will be activating these triggers and testing remove software with old SQL.

Will keep you posted 🙂

[nataliya_b · Accepted solution]

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.

[Kirsten2]

Hello,

We now have the same issue as many others with the deprecated triggers in SCCM for Removed Software. Did you end up enabling the triggers and, if so, did you encounter any issues with SCCM? Also, did it indeed get you the correct Removed Software records?

Thank you!

[Frank1975]

Hi all, 

we are facing the same issue, but even worse, the triggers in SCCM for tr_Add_Remove_Programs_DATA_DD,  tr_Add_Remove_Programs_DATA_64_DD are gone. (folder is empty) Since i am not an SCCM Expert, can someone provide this triggers (file) or the records (SQL Query od the file )?

thanks
Frank