What is the SQL query to return the latest definitions date that are on the Endpoint Protection Manager?

Products

• Endpoint Protection

Issue/Introduction

You want to know the SQL query to obtain the latest definitions installed on the Symantec Endpoint Protection Manager (SEPM) directly from the SEPM database without logging into the SEPM.

Resolution

In the Microsoft SQL Server Management Studio open a new Query and type the following:
(Note- Select the SEPM site database (generally named "sem5" before entering query)

select * from guiparms
where parameter='latest_av_defs'

The query and results are shown below: