WHERE (v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0) LIKE '%Microsoft Office Standard%' or SELECT DISTINCT v_GS_SYSTEM.Name0, v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0įROM v_GS_SYSTEM INNER JOIN v_GS_ADD_REMOVE_PROGRAMS_64 ON v_GS_SYSTEM.ResourceID = v_GS_ADD_REMOVE_PROGRAMS_64.ResourceID
The below query lists the 64 bit versions of office installed on machines. (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) LIke 'Microsoft % Enterprise %' (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) Like 'Microsoft % Professional%' or WHERE (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) LIKE '%Microsoft % Standard%' or SELECT DISTINCT v_GS_SYSTEM.Name0, v_GS_ADD_REMOVE_PROGRAMS.DisplayName0įROM v_GS_SYSTEM INNER JOIN v_GS_ADD_REMOVE_PROGRAMS ON v_GS_SYSTEM.ResourceID = v_GS_ADD_REMOVE_PROGRAMS.ResourceID The below query lists the 32 bit versions of office installed on machines. SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit Here is a forum thread that lists the difference between SQL and WQL queries. However note that these are the SQL queries and not the WQL queries. Using SQL queries it’s very easy to find out the Office versions. Listing out office versions installed on all machines is a big task. Many organizations today use Microsoft office to simply the work. This post contains the SCCM SQL query for Microsoft office 32 bit and 64 bit.
