SELECT
CS.Name0,
ARP64.DisplayName0,
ARP64.Version0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_GS_ADD_REMOVE_PROGRAMS_64 ARP64 on CS.ResourceID = ARP64.ResourceID
Where
ARP64.DisplayName0 like '%office%'
In response to http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/498ffe87-9a3d-433f-9927-020fd4c3777b
