Today I was asked to create a report in SCCM / ConfigMgr that shows all installed products in Add & Remove Programs.
My customer wanted to know all applications installed on all computers…
Instead of writing the whole thing myself, I searched on the internet and found the following query here.
Declare @CollID char(8)
Set @CollID = 'SMS00001'
SELECT DisplayName0, Count(*) AS 'Count', Publisher0, Version0, @CollID as CollectionID
FROM v_Add_Remove_Programs arp
JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = @CollID
GROUP BY DisplayName0, Publisher0, Version0
ORDER BY Publisher0, Version0
Hope you find it as useful as I have 🙂
Isn´t that built-in? Report in “Software – Companies” named “Count all inventoried products and Versions” …
Msg 208, Level 16, State 1, Line 3
Invalid object name ‘v_Add_Remove_Programs’.
I am having SCCM 2012 R2
Kindly I need computer name also how can I add computer name too
Computers with specific software registered in Add Remove Programs. make sure you put the % and the collection you want.
I need to take out the ALL INSTALLED SOFTWARE, inventory report which having VERSION, INSTALL DATE information.
Could anyone please suggest the best QUERY or path to take out the Inventory report? I have tried “Software Registered in Add remove on a specific computer but this is not as much useful as i wanna.
Thaks in Advance
I uninstalled software from one of my computer and was trying to get the updated report using the above query. Result is still I am getting the uninstalled application information which I was not looking for.
Please let me know how I can achieve this using this query.