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
Hope it helps!