Which SQL table contains the client's LOCATION information?
Updated: 22 May 2010 | 5 comments
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!
discussion Filed Under:
Comments
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
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 ?
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)
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)
Thanks Prachand. The
Thanks Prachand. The Computer Applications table is empty in our SEP database. Do you know how this table is populated?
Would you like to reply?
Login or Register to post your comment.