Thank you so much

Maledesma,

This is what you would need using the other report

SELECT vc.[Name],vc.[User],ca.[Agent Name],ca.[Product Version],ca.[Build Number]
FROM vComputer vc
JOIN Inv_AeX_AC_Client_Agent ca ON ca._ResourceGuid=vc.Guid
WHERE ca.[Agent Name]='Symantec pcAnywhere Agent'

This is what i run looking for machines with the host installed and it has user and PC Name attached to it:

SELECT [vc].[Name]
   ,[vc].[User]
      ,[Product Name]
      ,[Manufacturer]
      ,[Product Version]
      ,[File Version]
      ,[File Name]
      ,[File Size (MB)]
      ,[Modification Date]
      ,[Path]
      ,[Internal name]
      ,[Virtualized (Y/N)]
      ,[File Description]
      ,[File Extension]
  FROM [RMV_Installed_File_Inventory] vif
  RIGHT OUTER JOIN [vcomputer] vc on [vif].[_ResourceGuid] = [vc].[Guid]
  where [File Name] = 'awhost32.exe'
  order by [Product Version] ASC