SCCM – Report all software in Add and Remove Programs for all computers

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.

Hope you find it as useful as I have 🙂


  1. David - SCCM-newbie says:

    Isn´t that built-in? Report in “Software – Companies” named “Count all inventoried products and Versions” …

  2. Rishi Pandit says:

    Msg 208, Level 16, State 1, Line 3

    Invalid object name ‘v_Add_Remove_Programs’.

    I am having SCCM 2012 R2

  3. Dana says:

    Kindly I need computer name also how can I add computer name too

  4. Andrea says:

    Under Reports,

    Computers with specific software registered in Add Remove Programs. make sure you put the % and the collection you want.

  5. Abhinav says:

    Hi All,

    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


  6. Saikat Chakraborty says:

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *