Friday, August 15, 2014

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

4 comments:

  1. Thank you for the report you have created for me.

    ReplyDelete
  2. I'm wondering if anyone has an SCCM 2007 report that would show versions of Microsoft SQL versions ?

    ReplyDelete
    Replies
    1. Hi There,
      You can use above query and change the Firefox to SQL.
      That should provide you the machine names.

      Regards,
      Venu

      Delete
    2. Thanks for your help !!!!

      Delete