So it appears there is a chance that I have several duplicate HWID on my network. What I am trying to find is an easy way to determine which machines are impacted. And more importantly an easy way to follow up on these machines to make sure they are no longer using duplicate HWID.
I found a SQL Query that looks like it might work. The only problem at the moment I am having is comprehending the query. When I look at it I see the following fields: CURRENT_LOGIN_USER, IP Address, Machine Name, COMPUTER_ID, HARDWARE_KEY, Time Stamp
The Machine Name field, Computer ID, and Hardware Key fields are a bit confusing me. Specifically the Machine name field. I would expect no machine to show up more than once. Instead I would expect alot of different machine names and some identifier(either the Computer ID or Hardware Key) matching among several machines.
Below is the SQL Query I am using:
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