Endpoint Protection

Hi guys, I would like to know if it's possible to connect via an odbc driver ( or anything else ) to the embedded database of sepm ? I need to get other reports that's not in the reporting tool to put in an asp page. I've read an other post on the forum speaking about adaptive server anywhere 9.0 but i couldn't found any driver or code sample to get my asp server connecting to the database. Any help will be greatfull.

The other possibility is use a daily backup: the backup file are the db  tables in CSV  "zipped" together ( plus some other "nice" things)

It would be intresting if the reports you are looking for are the same that I am, ie a report on defined computers contra active clients.
I will probably  use PowerShell to create my report and save as a webpage on the SEPM
(PowerShell program is posted on forum).

Note: I use MS SQL Server as DB backend, but the table colums used are the same as embedded

Have a look at this download and thread.I think these will be useful to you
Custom Report with Original SQL (embedded database)
Embedded Database Editor

You can login to embedded database by using dbisqlc.exe.Look at the one of the example how you can login
Renaming Client name in SEPM console.

:)

really interessing links gonna read carefully them and post back if i found what i need.
Thnaks guys for the reply.

Have a look at this schema guide also
SQL Database Schema Information and Database Planning for Symantec Endpoint Protection Manager

héhé i was reading it to find the tables needed.
Thanks !

Thumbs up! Your hints leads me solution too. Btw, I'm trying to have a look on my embedded database with this tool but it's asking user and pass, which pass should I provide? is the same that I use to log on the console? or the symantec embedded datbase got a default user and pass?

Stephanie,
Your Forex Robot enthusiast

Although it might be written somewhere in the docs, the way I find username for embedded db access is:

SEPM Console->Admin->Servers->db server "localhost"->Database User (DBA on mine)

The password is the site specific password

This can help you?
How to find the Database password for Embedded Database