Hi,
I ran an SQL query (below) on a computer that is not reporting or showing the greendot in SEPM and returned three different Client ID records with the same HardwareID. All three records have the same DomainID, GroupID, Policy_Mode, ComputerID, and HardwareKey. For comparison, I ran the SQL query on a computer that is reporting and shows a greendot in SEPM and returned only one record. I'm thinking duplicate records in the database is causing the issue.
SELECT [CLIENT_ID]
,[DOMAIN_ID]
,[GROUP_ID]
,[POLICY_MODE]
,[COMPUTER_ID]
,[HARDWARE_KEY]
FROM [sem5].[dbo].[SEM_CLIENT] where [HARDWARE_KEY] = 'put HardwareID from above reg key'
I ran the above SQL query after pasting
http://127.0.0.1:9090/servlet/ConsoleServlet?ActionType=ConfigServer&action=CleanClients string in the browser...which returned
<?xml version="1.0" encoding="UTF-8" ?>
<Response ResponseCode="0" />
Is there another way to remove duplicates in the database via a SQL script?
Thanks,
Dan.