Endpoint Protection

 View Only
  • 1.  Report for duplicate "Unique ID"

    Posted Jan 24, 2011 09:41 AM

    Hello,

    Someone can help -me, do someone know report for unique ID duplicate? I want help, in my park of machine. I have cases of duplicate unique id. I would like report for find machines in unique id duplicate.
    Someone can help-me?



  • 2.  RE: Report for duplicate "Unique ID"

    Posted Jan 24, 2011 09:51 AM


  • 3.  RE: Report for duplicate "Unique ID"

    Posted Jan 24, 2011 09:55 AM

    I don't think any reports that you can create, but what i can hekp you to find the list of machines that have dublicate Hardware Id
    You can get this information from the  exsecreg from C:\Program Files\Symantec\Symantec Endpoint Protection Manager\data\inbox\log

    In the file locate the hardware key and try to find the ip address corresponding to that, this may hekp you to create a report for the Hardware id



  • 4.  RE: Report for duplicate "Unique ID"

    Posted Jan 24, 2011 11:20 AM

     

    Try the following SQL queries, but backup your database first!
     
     
    - To get list of currently duplicated clients:
    select computer_name, count(*) from sem_client where deleted = 0 group by computer_name having count(*) > 1 order by count(*) desc;
     
    - To find the name of systems with duplicate hardware IDs:
    SELECT COMPUTER_NAME, HARDWARE_KEY FROM SEM_CLIENT WHERE COMPUTER_NAME IN (SELECT COMPUTER_NAME FROM SEM_CLIENT WHERE DELETED = 0 AND GROUP_IS_OU = 0 AND POLICY_MODE = 1 GROUP BY COMPUTER_NAME HAVING (COUNT(computer_name)>1)) OR HARDWARE_KEY IN (SELECT HARDWARE_KEY FROM SEM_CLIENT WHERE DELETED = 0  AND GROUP_IS_OU = 0 AND POLICY_MODE = 1 GROUP BY HARDWARE_KEY HAVING (COUNT(hardware_key)>1)) ORDER BY COMPUTER_NAME


  • 5.  RE: Report for duplicate "Unique ID"
    Best Answer

    Posted Feb 22, 2011 02:43 PM

    Sorry but not funcion...