Endpoint Protection

It doesn't happen often, but somtimes I will see one PC with the green dot and another one without it and it's the same PC.

PC1 and PC1

Yes, click on Search Clients on the Clients page.

Search Field: Computer name

Comparison Operator: LIKE

Value: Enter in the PC name

Click Search :)

The problem is all of our PC's start with the same name (First 7 letters). So the like will list everything... :-(

It will but you can export to csv and go thru

That's what I did, I am letting my Excel Guru do the dupe search :-)

You can find Duplicated HWID in SQL database

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

Duplicated HWID query - result shows:
♦ Client computer ID and IP address
♦ Logged-in user
♦ Hardware Id

DECLARE @TimeZoneDiff int   
SELECT @TimeZoneDiff = datediff(minute, getutcdate(), getdate())
SELECT UPPER([COMPUTER_NAME])
   , [COMPUTER_ID]
   , [HARDWARE_KEY]
   , [CURRENT_LOGIN_USER]
   , dateadd(minute, @TimeZoneDiff, dateadd(second, [TIME_STAMP]/1000, '01/01/1970')) as [Time Stamp]
   , [IP_ADDR1_TEXT]
FROM [V_SEM_COMPUTER]
WHERE [COMPUTER_NAME] in
   (
      SELECT [COMPUTER_NAME]
      FROM [V_SEM_COMPUTER]
      WHERE [DELETED] = 0
      GROUP BY [COMPUTER_NAME]
      HAVING COUNT([COMPUTER_NAME]) >1
   )
ORDER BY [COMPUTER_NAME]
   , [Time Stamp] DESC

Good deal, quickest and easiest way to go!

Agreed, she did it in less than 30 seconds.