Tuesday, July 25, 2017

Office installed machine report for 64 & 32 - bit machines

Office installed machine report for 64 - bit machines :


SELECT DISTINCT v_GS_SYSTEM.Name0 as 'Machine Name',v_R_System.User_Name0,
v_GS_SYSTEM.Domain0, v_R_system.User_Domain0,v_R_System.operatingSystem0,
v_R_system.User_Domain0,v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0
FROM v_GS_SYSTEM
INNER JOIN v_GS_ADD_REMOVE_PROGRAMS_64 ON v_GS_SYSTEM.ResourceID = v_GS_ADD_REMOVE_PROGRAMS_64.ResourceID
 Inner join v_R_System ON v_GS_SYSTEM.ResourceID = v_R_System.ResourceID
WHERE (v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0) LIKE '%Microsoft Office Standard%' or
(v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0) Like 'Microsoft Office Professional%'or
(v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0) LIke 'Microsoft Office Enterprise %'





Office installed machine report for 32 - bit machines :


SELECT DISTINCT v_GS_SYSTEM.Name0 AS ' Machine Name', v_R_System.User_Name0,v_GS_SYSTEM.Domain0, v_R_system.User_Domain0,
v_R_System.operatingSystem0, v_R_system.User_Domain0,v_GS_ADD_REMOVE_PROGRAMS.DisplayName0
FROM v_GS_SYSTEM
INNER JOIN v_GS_ADD_REMOVE_PROGRAMS ON v_GS_SYSTEM.ResourceID = v_GS_ADD_REMOVE_PROGRAMS.ResourceID
Inner join v_R_System ON v_GS_SYSTEM.ResourceID = v_R_System.ResourceID
WHERE (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) LIKE '%Microsoft % Standard%' or
(v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) Like 'Microsoft % Professional%' or
(v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) LIke 'Microsoft % Enterprise %'

Order by v_GS_SYSTEM.Name0

No comments:

Post a Comment

site backup job manually

Start a scheduled SCCM 2012 site backup job manually You might want to start a scheduled SCCM 2012 site backup job manually. off co...