Video Screencast Help

How can I find out PcAnywhere version on each workstation

Created: 23 Jul 2012 | 6 comments

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

 

 

 

Comments 6 CommentsJump to latest comment

mclemson's picture

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's picture

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

JimChud's picture

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.

llian's picture

Thank you so much, I can use this report, it very helpful

JimChud's picture

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.