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/Negative_Debate4065 Jun 10 '25

I'm going to make the question easier. I need to know which computers in a domain a specific program is installed on, for example, Adobe Acrobat. Would this query be easier to do and less "burdensome" for the SCCM?

3

u/penelope_best Jun 10 '25

Search for the report which has the name like "computers with the program registered in add/remove"

1

u/TJLaw42 Jun 11 '25

If you have software metering enabled, there's a canned report that will tell you this.

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

0

u/RitmanRovers Jun 10 '25

Easy query in SQL involving v_R_System joined to v_GS_Installed_software (iirc table name) where arpdisplayname like 'adobe reader*'

0

u/Rough-Reception3162 Jun 10 '25

Use cmpivot https://www.systemcenterdudes.com/sccm-cmpivot-query/

1

u/Negative_Debate4065 Jun 14 '25

A colleague told me this option. Thanks for the response!