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

Question

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!

Answer 1

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.

Answer 2

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.

Answer 3

What is wrong with the built in report for this?