Find duplicate Windows computers
This reports gives a list of all computers that will be merged if you enable windows rename detection.SELECT '/asset.aspx?assetid=' + Cast(d.y As NVARCHAR(1000)) As [hyperlink_Asset A], y.AssetName As [hyperlink_name_Asset A], y.IpAddress [IP ...