SCCM report for Installed a application, machine name make and model

Below SQL query will provide a installed specific application, Machine Name, Machine Manufacturer and Machine model.

Change the Application name to a desired app name.

**************************************************************************

SELECT     arp.DisplayName0 AS [Application Name], arp.Version0 AS [App Version], v_GS_COMPUTER_SYSTEM.Name0 AS [Machine Name],

                      v_GS_COMPUTER_SYSTEM.Manufacturer0 AS [Manufacturer Name], v_GS_COMPUTER_SYSTEM.Model0 AS [Machine Model]

FROM         v_Add_Remove_Programs AS arp INNER JOIN

                      v_GS_COMPUTER_SYSTEM ON arp.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID

WHERE     (arp.DisplayName0 LIKE '%Firefox%')

**************************************************************************

More SCCM custom reports can be found here