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
Subscribe to:
Post Comments (Atom)
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...
-
Application app enforcement deployment status with installation errors select distinct vrs.user_name0,fn.machinename,fn.applicationnam...
-
select SMS_R_System.Name, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS...
-
select Name0, netbios_name0,user_name0,ProdID0 ,Displayname0, installdate0,publisher0,version0 from v_r_system inner join v_Add_Remove_Prog...
No comments:
Post a Comment