How to find installed software in SCCM?

Question

System administration

Hello. Please tell me the request. Which would allow you to see the installed software, or another method.

Answer 1

Right all-all-all? Try like this:

SELECT sys.Name0, sys.AD_Site_Name0, FCM.SiteCode, ARP.DisplayName0, ARP.Version0, ARP.InstallDate0
FROM dbo.v_R_System AS sys INNER JOIN
dbo.v_Add_Remove_Programs AS ARP ON ARP.ResourceID = sys.ResourceID INNER JOIN
dbo.v_FullCollectionMembership AS FCM ON FCM.ResourceID = sys.ResourceID AND ARP.DisplayName0 LIKE '%reader%'

Replacing %reader% with another name or void.
Source: https://social.technet.microsoft.com/Forums/en-RU/...

Answer 2

What for to you to fence reports manually when you can use the ready decision in SCCM. Report server + Software scan, there are already all ready-made reports for all occasions.