SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit

office 32 Bit
SELECT DISTINCT v_GS_SYSTEM.Name0, 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
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 %’

office 64 Bit
SELECT DISTINCT v_GS_SYSTEM.Name0, 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
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 %’

offfice 32 bit ve 64 Bit
SELECT DISTINCT
SYS.Name0
,ARP.DisplayName0 As ‘Software Name’
,ARP.Version0 As ‘Version’
,ARP.InstallDate0 As ‘Installed Date’
FROM
dbo.v_R_System As SYS
INNER JOIN dbo.v_FullCollectionMembership FCM On FCM.ResourceID = SYS.ResourceID
INNER JOIN dbo.v_Add_REMOVE_PROGRAMS As ARP On SYS.ResourceID = ARP.ResourceID
WHERE
(ARP.DisplayName0 LIKE ‘%Microsoft % Standard%’
OR ARP.DisplayName0 LIKE ‘Microsoft % Professional%’
OR ARP.DisplayName0 LIKE ‘Microsoft % Enterprise %’)
ORDER BY Name0 ASC

Bir cevap yazın