Renamed Pcs / Laptops report

[LithiumKid1976]

hi
is there any report available, where it would list pcs / Laptops that have been renamed ?

[RCorbeil]

Try this as a starting point:

Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssetComments.Comment,
  tblAssetComments.Added,
  tblAssetComments.AddedBy
From
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetComments ON tblAssetComments.AssetID = tblAssets.AssetID
Where
  tblAssetCustom.State = 1
  AND tblAssetComments.Comment LIKE 'Renamed %'
Order By
  tblAssets.AssetName,
  tblAssetComments.Added