→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
icon
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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