Looking for a report that will show Duplicate asset names (for Laptops and Desktops)

[dlafleur]

Good morning folks.  I am Looking for a report that will show Duplicate asset names (for Laptops and Desktops).  I looked through the online stuff I could find, but nothing related to what I am looking for.  Does anyone have or know where I can find a report for this?

Thanks

Dave

[rinks · Accepted solution]

This is the report I created for this, based upon serial numbers:

Select tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Serialnumber,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join (Select Count(tblAssetCustom.AssetID) As Total,
Coalesce(tblAssetCustom.Serialnumber, N'') As Serial
From tblAssetCustom
Where tblAssetCustom.State = 1
Group By Coalesce(tblAssetCustom.Serialnumber, N'')
Having Count(tblAssetCustom.AssetID) > 1 And
Coalesce(tblAssetCustom.Serialnumber, N'') <> '') As Dups On
tblAssetCustom.Serialnumber = Dups.Serial
Left Outer Join tsysIPLocations On tblAssets.LocationID =
tsysIPLocations.LocationID
Where tblAssetCustom.State = 1

[Mercedes_O]

Thank you for picking these report queries up @Mister_Nobody !

[Mister_Nobody]

Try this:

https://community.lansweeper.com/t5/reports-analytics/what-reports-do-you-use-daily-share-here/m-p/6...