Find duplicate Windows computers

[Michael_V]

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 Address A],
  '/asset.aspx?assetid=' + Cast(d.z As NVARCHAR(1000)) As
  [hyperlink_Asset B],  
  z.AssetName As [hyperlink_name_Asset B],
  y.IpAddress [IP Address B]
FROM
(
SELECT DISTINCT y.AssetID y, z.AssetID z FROM 
(SELECT a.AssetID, AssetUnique, m.Mac, Serialnumber, Model FROM tblAssets a JOIN tblAssetCustom c ON a.AssetID = c.AssetID JOIN tblAssetMacAddress m ON a.AssetID = m.AssetID WHERE Assettype=-1) y
JOIN
(SELECT a.AssetID, AssetUnique, m.Mac, Serialnumber, Model FROM tblAssets a JOIN tblAssetCustom c ON a.AssetID = c.AssetID JOIN tblAssetMacAddress m ON a.AssetID = m.AssetID) z
ON y.AssetUnique <> z.AssetUnique AND y.Mac = z.Mac AND y.Serialnumber = z.Serialnumber AND y.Model = z.Model AND y.AssetID > z.AssetID
)d
JOIN tblAssets y ON d.y = y.AssetID
JOIN tblAssets z ON d.z = z.AssetID

[laurentiune]

I get this error: There was an error parsing the query. [ Token line number = 1,Token line offset = 178,Token in error = Select ]

[Susan_A]

laurentiune wrote:
I get this error: There was an error parsing the query. [ Token line number = 1,Token line offset = 178,Token in error = Select ]

I cannot reproduce this behavior in SQL Compact or SQL Server. (Based on some of your other posts, I believe you're using SQL Compact.) Could you ensure that you copied the query correctly. Try pasting it in Notepad first and from there into the report builder.