Skip to content

Instantly share code, notes, and snippets.

@assertivist

assertivist/sccm_removed_sw.sql

Created June 4, 2020 21:01
Show Gist options
  • Save assertivist/41842b24f5ef3658cd6cf3c3f5d69502 to your computer and use it in GitHub Desktop.
Save assertivist/41842b24f5ef3658cd6cf3c3f5d69502 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sccm_removed_sw.sql
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment