ConfigMgr Report All Installed Applications Listed Per Computer

A customer of a college of mine wanted a SQL Query to create a report in ConfigMgr that lists all installed software per computer. I thought about using the method that another college of mine blogged about here. That method, awesome as it is, didn’t do the trick for me this time. Why you ask? Simply because the view v_Add_Remove_Programs contains both v_GS_Add_Remove_Programs and v_GS_Add_Remove_Programs64 and only the later two are available while creating a WQL query in the Configuration Manager Console.

The SQL query I ended up using was the following

SELECT [vSMS_R_System].[Name0]
      ,[Publisher0]
          ,[DisplayName0]
      ,[Version0]
  FROM [vSMS_R_System] inner join
  [v_Add_Remove_Programs] on [v_Add_Remove_Programs].[ResourceID] = [vSMS_R_System].[ItemKey]
  order by [vSMS_R_System].[Name0] DESC, [v_Add_Remove_Programs].[DisplayName0] DESC, [v_Add_Remove_Programs].[Publisher0] DESC, [v_Add_Remove_Programs].[Version0] DESC

After creating a new report and pasting in the above query I got the following output
Report

Hope it helps!

/Tim

About The Author

Tim Nilimaa is a consultant with Lumagate in Sweden. He has been working with Configuration Manager for 8 years. His knowledge has been selected as a speaker at many events among them Microsoft Management Summit.

No Comments

Leave A Reply