Endpoint Protection

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.

check the DB schema guide.

http://www.symantec.com/business/support/index?page=content&id=DOC4324

it has the details of DB and information related to columns

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

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! 

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

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

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.

Attachment(s)

Endpoint Protection Sizing and Scalability Best Practices...3_1   688 KB 1 version

thanks for sharing the information here.

have you received you answer ?