Today I was asked to create a report in SCCM / ConfigMgr that shows all installed products in Add & Remove Programs.
My customer wanted to know all applications installed on all computers…
Instead of writing the whole thing myself, I searched on the internet and found the following query here.
Declare @CollID char(8) Set @CollID = 'SMS00001' SELECT DisplayName0, Count(*) AS 'Count', Publisher0, Version0, @CollID as CollectionID FROM v_Add_Remove_Programs arp JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID WHERE fcm.CollectionID = @CollID GROUP BY DisplayName0, Publisher0, Version0 ORDER BY Publisher0, Version0
Hope you find it as useful as I have 🙂