Query to Identify Microsoft Office Versions Installed on agents

Question

What is the best way to write a query to detect machines that have Microsoft Office installed, including the specific version details?

Answer 1

Hi,

To identify machines with Microsoft Office installed and retrieve specific version details, you can use a query in SCCM:

SELECT DISTINCT SYS.Name0, 
                ADD_REMOVE_PROGRAMS.DisplayName0, 
                ADD_REMOVE_PROGRAMS.Version0 
FROM v_R_System SYS 
INNER JOIN v_Add_Remove_Programs ADD_REMOVE_PROGRAMS 
ON SYS.ResourceID = ADD_REMOVE_PROGRAMS.ResourceID 
WHERE ADD_REMOVE_PROGRAMS.DisplayName0 LIKE '%Microsoft Office%'