Scaning for Symantec Antivirus virus definition version

[JBARRETT]

How can lansweeper be configured to scan for Symantec Antivirus virus definition version? Application version is 10.1.6.

[atwitty]

I am now getting a general parsing error whenever I try to add RIGHT to the query. This seems to work fine as a SQL query but complains when I run it in report builder..
Thanks!

[Hemoco]

You should be able to use the "right" function in your query.

http://msdn.microsoft.com/en-us/library/ms177532.aspx

[JBARRETT]

We found a registry key that has the date of the latest virus definitions. Now all we need is a way to trim the key down.
HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\SharedDefs
NAVCORP_70=C:\\PROGRA~2\\SYMANTEC\\DEFINI~1\\VIRUSD~1\\20091104.009
The key contains a full string path of the latest definition. The last folder name is the date of th latest definitions downloaded. Is there any way to trim the string down to just the numbers at the end? I.E. 20091104.009
Thanks!

[Hemoco]

Is the version stored somewhere in the registry or in a file version?