Where can antivirus definition levels be found in the Sygate 5.1 database in MSSQL?
|Article:TECH158456|||||Created: 2011-04-20|||||Updated: 2014-04-04|||||Article URL http://www.symantec.com/docs/TECH158456|
With Symantec Endpoint Protection 5.1 for Windows XP Embedded, how can the antivirus definitions in use by clients be listed via a database query?
The agent antivirus definitions are listed in the "RESERVED_CHAR2" column of the "SEM_AGENT" table.
Note: In order to find the correct agent, the ID found in the "COMPUTER_ID" column of the "SEM_AGENT" table must be correlated with the "COMPUTER_ID" column of the "SEM_CLIENT" table.
Below is an example of a query that can be used:
The query will list the client group, machine name, and antivirus definition date for all clients in the database.
Article URL http://www.symantec.com/docs/TECH158456