:::: MENU ::::

All “Microsoft Office%” Versions

SELECT DISTINCT
c.Name0 AS [Machine Name], a.DisplayName0 AS [ARP Entry], a.Version0 AS Version, c.Operating_System_Name_and0, dbo.v_GS_OPERATING_SYSTEM.Caption0,
c.User_Domain0, c.User_Name0, c.AD_Site_Name0
FROM dbo.v_GS_ADD_REMOVE_PROGRAMS AS a INNER JOIN
dbo.v_R_System AS c ON a.ResourceID = c.ResourceID INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON c.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
WHERE (a.DisplayName0 LIKE ‘Microsoft Office%’) AND (NOT (a.DisplayName0 LIKE ‘%update%’)) AND (NOT (a.DisplayName0 LIKE ‘%Microsoft Office XP Web Components’))
AND (NOT (a.DisplayName0 LIKE ‘%server%’))


So, what do you think ?