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