System Center Configuration Manager Reporting UnleasedĪdd Office365ProPlusConfiguration to your hardware inventory classes, then you can use this query: Or (v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0) LIke 'Microsoft Office Enterprise %'īoth of these are sql queries not wql queries that are needed by collections. WHERE (v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0) LIKE '%Microsoft Office Standard%' or (v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0) Like 'Microsoft Office Professional%' 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 (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) LIke 'Microsoft % Enterprise %' WHERE (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) LIKE '%Microsoft % Standard%' or (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) Like 'Microsoft % Professional%' 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 Hi find the below query, hope it will help you. If you have feedback for TechNet Subscriber Support, contact Raghu, Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact Sir, SELECT DISTINCT sys.Name, arp64.DisplayName FROM SMS_R_SYSTEM sys INNER JOIN SMS_G_SYSTEM_ADD_Remove_Programs_64 arp64 ON sys.ResourceID = arp64.ResourceID WHERE arp64.DisplayName LIKE '%Microsoft Office Standard%' or arp64.DisplayName Like 'Microsoft Office Professional%' or arp64.DisplayName LIke 'Microsoft Office Enterprise %' WHERE arp.DisplayName LIKE '%Microsoft Office Standard%' or arp.DisplayName Like 'Microsoft Office Professional%' or arp.DisplayName LIke 'Microsoft Office Enterprise %' DisplayNameįROM SMS_R_SYSTEM sys INNER JOIN SMS_G_SYSTEM_ADD_Remove_Programs arp ON sys.ResourceID = arp.ResourceID

SELECT DISTINCT sys.Name, SMS_G_SYSTEM_ADD_Remove_Programs.

See below one: (Just modified above ones and without any syntax check) 32bit Office will only in SMS_G_SYSTEM_ADD_Remove_Programs and 64bit ones are in SMS_G_SYSTEM_ADD_Remove_Programs_64.

Office 2019 64 bit vs 32 bit