Endpoint Protection

Hi,

   I have a bit doubt on field computer_id in sem_computer table. Actually , I ran following query in SEPM database:

  select computer_name from sem_computer where computer_id = (select computer_id from sem_client where computer_name = 'AAA')

   The output above query gives is 'BBB'. This is quite surprising because ideally it should come as 'AAA' only ( assuming computer_id should be unique). 

   Can anybody suggest something about this problem? 

Tabish

check the schema

ftp://ftp.symantec.com/public/english_us_canada/products/symantec_endpoint_protection/11.0/manuals/mr2/schema_reference_guide.pdf

Does duplicate hardware ID available ?

See this articles help you

Compilation of SQL queries to the SEPM database

https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database

https://www-secure.symantec.com/connect/forums/sql-querys-database

I check hardware key for both PCs (AAA and BBB). But they are different.

What do you want to check? 

Computer_ID is a primary key, so these values should be unique.

Its adaptive Sqlserver anywhere , doesn't act like SQL you know :) 

I was seeing a different IP address for AAA ( IP address of BBB) in SEPM console. The same is happening for some other PCs as well. That is why I checked into SQL Server and found this problem. Now, what shall  I do? 

I checked into SEPM databse again. I found that AAA hostname has multiple COMPUTER IDs in sem_client. Can you tell me how shall rectify multiple COMPUTER ID problem in sem_client ? 

Tabish

for IP you should check in SEM_computer table

here is the complete db schema...

extract it and open the index

http://www.symantec.com/business/support/index?page=content&id=DOC6039

here is some SQl query

https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database