SCCM/MECM report - how to get machines that run Office 2016?

Eaven Huang 1,816 Reputation points

Dear experts,

We have quite some client PCs that are still running Office 2016 and we need to find them out for reporting purpose. Some of them are running Office x64 and some are still running x86.

Any report mechanism in SCCM/MECM server that we can retrieve such report?

Any advice would be really appreciated!

Microsoft Configuration Manager
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Rahul Jindal [MVP] 7,536 Reputation points MVP

    There are multiple ways you can retrieve the data on this. You can create collections to get the members. 1 for ARP, other for ARP64 and third that combines the members of both 1 and 2. There is a default software installed report that you can use to fetch the information. Then you have the option to fetch the details directly from SQL by querying against v_add_remove_programs.

  2. AllenLiu-MSFT 27,981 Reputation points Microsoft Vendor

    Hi, @Eaven Huang

    Thank you for posting in Microsoft Q&A forum.

    If we do not configure the built-in report, we can use a SQL query like below:
    Open SQL Server management studio, click "New Query", select the SCCM database "CM_XXX", copy and paste the query and click "Execute".

    select Name0,v_add_remove_programs.* from v_add_remove_programs  
    left join v_R_System on v_add_remove_programs.ResourceID = v_R_System.ResourceID  
     where v_add_remove_programs.DisplayName0 like '%office%2016%'  


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  3. Garth 5,011 Reputation points MVP

    What is wrong with the built in report for this?