Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Which SQL table contains the client's LOCATION information?

Updated: 22 May 2010 | 5 comments
David Fanning's picture
0 0 Votes
Login to vote

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!

Comments

Ramji Iyyer's picture
04
Oct
2009
1 Vote +1
Login to vote

Check this

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

Regards...
Ramji Iyyer

Bijay.Swain's picture
04
Oct
2009
0 Votes 0
Login to vote

very good information

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 ?

Prachand's picture
04
Oct
2009
0 Votes 0
Login to vote

Navigate to the C:\Program

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.

Prachand Kumar MCSE-2003 Symantec Technical Specialist (SCTS)

Prachand's picture
04
Oct
2009
1 Vote +1
Login to vote

The table name is Computer

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

Prachand Kumar MCSE-2003 Symantec Technical Specialist (SCTS)

David Fanning's picture
05
Oct
2009
0 Votes 0
Login to vote

Thanks Prachand.  The

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