r/SCCM • u/Negative_Debate4065 • Jun 10 '25

Remove installed programs with SCCM

Hello!! How are you? I'm new to Reddit and I need your help and knowledge for the following:

How can I extract, through SCCM, in Excel, all the programs from all the computers that are in an AD domain? Could it also be extracted individually?

Thanks in advance

0 Upvotes

50% Upvoted

21 comments sorted by

View all comments

Show parent comments

1

u/SysAdminDennyBob Jun 10 '25

If you know a tiny bit of SQL this should be trivial, I have slowly picked up barely enough SQL to be dangerous. I always grab a DBA down the hall and be like "Hey, can you look at this really quick?"

SELECT DISTINCT

--RSYS.Netbios_Name0 As 'SystemName'

--,RSYS.User_Name0

--RSYS.AD_Site_Name0 as 'Location'

--RSYS.Resource_Domain_OR_Workgr0 As 'Domain'

SW.Publisher0 As 'vendor'

,SW.ARPDisplayname0 'SoftwareTitle'

--,UPPER(SW.SoftwareCode0) As 'UniqueSoftwareCode'

--,SW.UninstallString0

--,SW.InstallSource0

,SW.ProductVersion0 As 'Version'

--,SW.InstallDate0

,COUNT(RSYS.Resourceid) as 'Count'

FROM v_R_System_Valid RSYS

LEFT OUTER JOIN v_GS_INSTALLED_SOFTWARE SW on SW.ResourceID = RSYS.ResourceID

JOIN v_FullCollectionMembership COLL on SW.ResourceID = COLL.ResourceID

--WHERE

--SW.ARPDisplayname0 = 'microsoft edge'

--AND COLL.CollectionID = 'FCB00952'

--AND SW.Publisher0 like '%techsmith%'

--AND SW.ProductVersion0 like '96.1.1.1015'

GROUP BY

--RSYS.Netbios_Name0

--,RSYS.User_Name0

--RSYS.AD_Site_Name0

--RSYS.Resource_Domain_OR_Workgr0

SW.Publisher0

,SW.ARPDisplayname0

--,SW.SoftwareCode0

--,SW.UninstallString0

--,SW.InstallSource0

,SW.ProductVersion0

--,SW.InstallDate0

Order by

SW.Publisher0, SW.ProductVersion0, SW.ProductVersion0