Endpoint Protection

 View Only

  • 1.  SQL to find "Latest from Symantec" Windows Definitions.

    Posted Apr 23, 2014 11:13 AM

    I'm pretty quick at finding a query to figure out the net difference between a client and the SEPM manager. However, I'm looking for the SQL used to get the following that is located on the login page of SEPM:

     

    Windows Definitions   

    Latest from Symantec: 04/23/2014 r3   <-- Really like to know where in the DB this is stored.
    Latest on Manager: 04/22/2014 r1  

    Capture.PNG

    Kudos for anyone who can find it in the DB. :)

    Thanks in advance!



  • 2.  RE: SQL to find "Latest from Symantec" Windows Definitions.

    Posted Apr 23, 2014 11:17 AM

    Best I can offer is the 12.1 DB schema :)

    Symantec™ Endpoint Protection Manager Database Schema Reference 12.1

    The symantec date is not stored in the DB, it's via Internet check



  • 3.  RE: SQL to find "Latest from Symantec" Windows Definitions.

    Posted Apr 23, 2014 11:17 AM

    check this, let me also find in the mean time

    http://service1.symantec.com/support/ent-security.nsf/841ef36170d8f9148825703600668010/4069b62b27af10ea8825747800740c9f/$FILE/DB_Schema_Ref_Guide.pdf



  • 4.  RE: SQL to find "Latest from Symantec" Windows Definitions.

    Broadcom Employee
    Posted Apr 23, 2014 11:18 AM

    Latest from Symantec: 04/23/2014 r3  ---> this is from Symantec site not from SEPM , this is checked on internet

     

    this is from SEPM database Latest on Manager: 04/22/2014 r1 



  • 5.  RE: SQL to find "Latest from Symantec" Windows Definitions.

    Posted Apr 23, 2014 12:08 PM

    yesThumbs up to Pete!

    The "Latest from Symantec" is available from the Symantec site under "File-based Protection" on the below page:

    http://www.symantec.com/security_response/definitions.jsp

    As such, I'd question if it would even make it into the DB, as it would serve no purpose (that I can think of off the top of my head).



  • 6.  RE: SQL to find "Latest from Symantec" Windows Definitions.

    Posted Apr 23, 2014 12:39 PM

    Hello, 

    Latest from manager means the file based protection definitions available from Symantec latest on manger means current file based definitions with local SEPM.

    Regards

    Ajin



  • 7.  RE: SQL to find "Latest from Symantec" Windows Definitions.

    Broadcom Employee
    Posted Apr 23, 2014 03:27 PM

    Hi,

    Thank you for posting in Symantec community.

    Refer this article as well: Symantec Endpoint Protection Managers using a Microsoft SQL database no longer host the latest definitions and client install packages.

    http://www.symantec.com/docs/TECH106075