ビデオヘルプ

How can I find out PcAnywhere version on each workstation

作成: 23 Jul 2012 | コメント数: 6

I have mix of NS7.0 and NS7.1, and PcAnywhere version is different as well, how can I find out the versin of PcAnywhere is '12.6.8096', when I look at my workstion, on my Symantec Management Agent Settings;

Agents/Plug-Ins                                      Version

Symantec pcAnywhere Agent              12.6.8096

Where is the table name I can run query, I try to look into inv_addremoveprogram, but the displayversion did not show the correct version

Thanks

Lillian

コメント コメント数: 6最新のコメントを表示

mclemson の写真

Plug-in data is stored in Inv_AeX_AC_Client_Agent:

SELECT vc.Name,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'
 

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

maledesma の写真

Is it possible to add the last logon user or primary user to this report?

JimChud の写真

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

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.

JimChud の写真

No problem Llian, please remember to "Mark as Solution" those posts which resolve your problem.

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.