SCCM report query to get installed application

The below query is useful to identify installed application based on display name in Add-remove programs and generate a report
**********************************************************************

Select

     sys.Netbios_Name0,
     sys.User_Domain0,
     sys.User_Name0,
     sys.Operating_System_Name_and0,
     arp.DisplayName0,
     ARP.Version0
FROM
     v_R_System sys
     JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
     Displayname0 like '%Application Name%'
********************************************************************

Example:

Creating a report for Adobe Reader.

Select

     sys.Netbios_Name0,
     sys.User_Domain0,
     sys.User_Name0,
     sys.Operating_System_Name_and0,
     arp.DisplayName0,
     ARP.Version0
FROM
     v_R_System sys
     JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
     Displayname0 like '%Adobe Reader%'

More SCCM custom reports can be found here