SELECT Distinct
b.Netbios_Name0,
b.User_Name0,
b.User_Domain0,
v_GS_OPERATING_SYSTEM.Caption0 ,
case when v_gs_processor.addresswidth0 = 64 then '64bit OS'
when v_gs_processor.addresswidth0=32 then '32bit OS'
end as [Operating System Type],
CASE
WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003'
WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007'
WHEN a.FileVersion LIKE '14.%' THEN 'Office 2010'
WHEN a.FileVersion LIKE '15.%' THEN 'Office 2013'
WHEN a.FileVersion LIKE '16.%' THEN 'Office 2016'
ELSE 'Lower Version' END AS 'Office Version',
a.FileName,
a.FileVersion,
a.FilePath,
v_GS_OPERATING_SYSTEM.Caption0
FROM
v_GS_SoftwareFile a
JOIN v_R_System b ON a.ResourceID = b.ResourceID
JOIN v_RA_System_SystemOUName c ON a.ResourceID = c.ResourceID
JOIN v_GS_OPERATING_SYSTEM ON v_GS_OPERATING_SYSTEM.ResourceID=b.ResourceID
join v_gs_processor ON b.ResourceID = v_gs_processor.ResourceID
WHERE FileName = 'outlook.exe'
GROUP BY
b.Netbios_Name0,
b.User_Name0,
b.User_Domain0,
a.FileName,
a.FileVersion,
a.FilePath,
v_GS_OPERATING_SYSTEM.Caption0,
v_gs_processor.addresswidth0
ORDER BY
b.Netbios_Name0
No comments:
Post a Comment