Video Screencast Help

Symantec ESM 10 Database location

Created: 08 Sep 2011 • Updated: 09 Sep 2011 | 2 comments

Hi,

      We are in the process of upgrading to ESM 10.

      We found that using the "Synchronize Local Database" option, creates a MS Access DB file named <consoleuser>.mdb in the Database folder.

      We are curious to know if this location can be changed to a Network location.

      This is so to ensure that we do not lose the data if we have issues on the User machine.

      Kindly let me know if this is possible and how to do it.

      Thanks in advance.

Regards,

Kumaran Ravichandran

Comments 2 CommentsJump to latest comment

kevin_stultz's picture

Kumaran,

"Synchronize Local Database"  was designed so an end user could perform SQL queries/reports.  Reporting Database Link (RDL) or dbConvert tool should be utilitzed if you want a centralized ESM SQL database.  We highly recommend using CCS for Reporting(free for ESM customers) instead of building custom SQL based reports. 

For more details on CCS for ESM Customers see:

https://www-secure.symantec.com/connect/videos/ccs-esm-customers-compliance-webinar

 

Kevin

Sunny G's picture

Hello,

the local access database file is only created where the user's ESM console is installed.  Therefore, multiple console clients can have multiple access databases.  You do not need to back this up really, as the data comes from the ESM Manager server in the db directory - which is stored in a proprietary and encrypted database.

You can use the dbexport command line option, or the RDL reporting database link java based application to copy/synch data from the ESM database in to an SQL db for reporting use.  I know that Symc recommends to use CCS for reporting, but if you haven't upgraded yet it is a big step and personally I don't find the reports as good as what I could get from the SQL DB using the Symantec Enterprise Reporting (end of life) application.  Which was basically Cognos Reportnet OEM'd and with pre-built report packages.

I do still have this software available somewhere and can share it if you want.  It is free as you are entitled to it as part of the ESM license, however there is no support available for it.

Cheers,

Sunny