SCCM 2016 Integration is not removing software

Susan Davidson
Giga Guru

We have SCCM 2016 Removed Software installed as part of our integration software. The triggers are as follow

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

This is not actually removing any software - on devices where i know it has been removed and the machine has subsequently checked in, scanned and updated in SCCM and in ServiceNow the software is still showing in ServiceNow but nowhere else.

I found reference to a KB that said i needed a graph plug in (that we do not own and can't justify spending the money on) Is there another way to do this.. to get the software to delete? Am i missing soemthing obvious?

1 REPLY 1

Chad Peterson
Tera Contributor

Reference this community answer here. 

 

New versions of SCCM 1906 and higher will most likely continue to have this issue,  Triggers are getting deactivated by Microsoft for the two dedicated tables. I've dealt with this at clients in recent past as well.  Have your SCCM team re-enable the triggers on the two tables below if they are disabled. 

SCCM_Ext.Add_Remove_Programs_DATA_DD

SCCM_Ext.Add_Remove_Programs_64_DATA_DD)t

https://community.servicenow.com/community?id=community_question&sys_id=8b7f1198db380c546064eeb5ca96...

 

Let me know if this solves your issue