Monday, February 11, 2013

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





1 comment:

  1. Thank you for the useful report.
    I need to run similar report to provide a management report on few applications.
    How can I add multiple applications to a single report so I don't have to modify the report for each individual application?
    Thanks

    ReplyDelete