cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
LithiumKid1976
Champion Sweeper
hi
is there any report available, where it would list pcs / Laptops that have been renamed ?
1 REPLY 1
RCorbeil
Honored Sweeper II
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