Video Screencast Help

Symantec Tables in DataBase

Created: 10 Aug 2012 | 8 comments

Hi Guys,

          What exactly is stored in the db of symantec. I would like to know if the policies and settings I made are stored in the db and if they are what is the name of the table they are stored in.

Comments 8 CommentsJump to latest comment

Mithun Sanghavi's picture

Hello,

Yes, Policies and Settings of SEPM 12.1 are stored in the Database.

You could check the Database Schema Guide provided above for the same.

Secondly, incase you are trying to restore a SEPM, then follow the Disaster Recovery Steps: http://www.symantec.com/docs/TECH160736

Hope that helps!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

Mick2009's picture

Hi Frank,

One important reminder.... Whether you have the embedded database or MS SQL, it is completely unsupported to attempt to manually change any data in any table.  And details that admins need to see, and reports that need to be run, etc, can be accessed through the SEPM.  Using other tools to alter the DB info can result incorruption and the failure of the SEPM altogether.  Be very careful! 

With thanks and best regards,

Mick

greg12's picture

Policies, settings, client logs, compressed content, client packages ...

Have a look at this thread with SQL queries:

https://www-secure.symantec.com/connect/forums/sql-querys-database

pete_4u2002's picture

Agree with MIck2009, why not pull the report/logs from SEPM?

Ashish-Sharma's picture

Architecture

Symantec Endpoint Protection contains four main architectural components that work together to protect your company from security threats:

• Symantec Endpoint Protection Manager (“SEPM” or “manager”)– The management server that is used to configure clients, reports, and alerts.

• Symantec Endpoint Protection SQL Data Store (“database”) – The database that stores all configuration, updates, and reporting information.

• Symantec Endpoint Protection Client (“client”)— Software that is deployed to networked computers. The client is used to monitor policies and automate policy compliance activities.

• Symantec Protection Center (formerly, the Symantec Endpoint Protection console)— A lightweight user interface that is used to access the Symantec Endpoint Protection Manager. The Symantec Protection Center is used to manage and view deployment activity, configurations, updates, and Symantec Endpoint Protection client reports.

AttachmentSize
Endpoint Protection Sizing and Scalability Best Practices_ v2.3.pdf 688.76 KB

Thanks In Advance

Ashish Sharma

 

 

Dushan Gomez's picture

thanks for sharing the information here.

Dushan Gomez
IT Manager
VCP 4 and 5 | MCITP Exchange Server | MCTS SharePoint Server | MCP Windows XP

 

Ashish-Sharma's picture

have you received you answer ?

Thanks In Advance

Ashish Sharma