Endpoint Protection

I'd like to create a report showing SEP clients, and their locations, which are defined in SEPM based in IP subnets.  I see the LOCATIONs that were created in the SEPM, in the dbo_IDENTITY_MAP SQL table, with a unique ID number.  However, I cannot find a table, which contains client info (such as computer name) and a link to the LOCATION ID field in the dbo_IDENTITY_MAP table.

Can someone tell  me how to link SEP client information to the location?

Thanks!

Kindly find the below link in which the database schema is given

http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008063014073748

Regards...
Ramji Iyyer

very good information Ramji.


Can you tell me how to view the tables while using an Embeded database.

how to login to the database.
wil osql command work ?

The table name is Computer Application schema

You can downlaod the SEP schema from http://www.symantec.com/connect/sites/default/files/DB_Schema_Ref_Guide.pdf

Navigate to the

C:\Program Files\Symantec\Symantec Policy Manager\ASA\win32

Run DBISQLC.EXE

Then the ODBC window would appear , you have to then  use user name as dba and then the  DBA user password as entered during the product installation,    Then  the query editor for sybase would appear and you can wright the query accordingly.

Thanks Prachand.  The Computer Applications table is empty in our SEP database.  Do you know how this table is populated?