Duplicate assetname report

[icon]

Hi,

I'm trying to create a report which only shows items that have duplicate AssetNames. There are default reports showing duplicate serial numbers and SIDs but I'm struggling to apply the same logic to AssetName.

Can anyone help?

Thanks.

[Hemoco · Accepted solution]

Please try this report:

Select Top 1000000 tblAssetCustom.AssetID As DB_AssetID,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
tblAssets.IPAddress,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join (Select Top 1000000 tblAssets.AssetName
From tblAssets
Group By tblAssets.AssetName
Having Count(tblAssets.AssetID) > 1) Dups On tblAssets.AssetName =
Dups.AssetName
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
tblAssets.IPAddress,
tblAssets.Lastseen