Try this:
DECLARE @v1_TrusteeScope nvarchar(max)
SET @v1_TrusteeScope = N'%TrusteeScope%'
SELECT
[vri2_Computer].[Guid] AS [_ItemGuid],
[vri2_Computer].[Name],
arp.DisplayName as 'Office Name',
arp.DisplayVersion as 'Office Version',
[dca4_MOEVersion].[MOEVersion] as 'MOE Version',
[dca3_AeX AC Identification].[Last Logon User],
[vri2_Computer].[IsManaged]
FROM
[vRM_Computer_Item] AS [vri2_Computer]
LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca3_AeX AC Identification]
ON ([vri2_Computer].[Guid] = [dca3_AeX AC Identification].[_ResourceGuid])
LEFT OUTER JOIN [Inv_MOEVersion] AS [dca4_MOEVersion]
ON ([vri2_Computer].[Guid] = [dca4_MOEVersion].[_ResourceGuid])
INNER JOIN [Inv_AeX_AC_Client_Agent] AS [ajs5_Inv_AeX_AC_Client_Agent]
ON ([vri2_Computer].[Guid] = [ajs5_Inv_AeX_AC_Client_Agent].[_ResourceGuid])
JOIN Inv_AddRemoveProgram arp ON arp._ResourceGuid=vri2_Computer.Guid
WHERE
(
([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
AND
arp.DisplayName LIKE 'Microsoft Office Professional%' AND arp.InstallFlag=1
)
GROUP BY
[vri2_Computer].[Guid],
[dca4_MOEVersion].[MOEVersion],
[vri2_Computer].[Name],
[vri2_Computer].[IsManaged],
[dca3_AeX AC Identification].[Last Logon User]
ORDER BY
[dca4_MOEVersion].[MOEVersion] DESC
Also, compare your first query with my posted query at a site like textdiff.com to learn how I combined them.