Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2020 06:11 AM
Sure, pretty much out of the box, issue is that
SCCM_Ext.Add_Remove_Programs_DATA_DD and
SCCM_Ext.Add_Remove_Programs_64_DATA_DD
does no longer have any data in SCCM , since there is no triggers available which can be activated to feed these tables in SCCM.
here is the SQL Statement
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