Bump - I'm looking for one of these also...
I would try this
To see just the dupes in sql
SET NOCOUNT ON
DECLARE @Address varchar(255), @Check int
DECLARE change_cursor CURSOR FOR
SELECT Address FROM TCP
GROUP BY Address
HAVING COUNT(Address) > 1
thanks - primarily I am focused on duplicate device names - I'm not very experienced with SQL - any way to alter this to show duplicate device ID's?
select computer.DEVICENAME, count(*) from computer group by
DEVICENAME having count (*) <> 1