SCCM 2016 Integration is not removing software
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2021 03:40 PM
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,020 Views

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2021 10:52 AM
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
Let me know if this solves your issue