Report showing assetname change in the last 24 hours

[baycrest]

I'm looking for a report that would show any assets that had the Assetname changed in the last 24 hours.

[baycrest]

Amazing - Thank you

[brandon_jones · Accepted solution]

This should give you the information you need.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetComments.Comment,
tblAssetComments.AddedBy,
tblAssetComments.Added
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblAssetComments On tblAssets.AssetID = tblAssetComments.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetComments.Comment Like 'renamed%' And tblAssetComments.AddedBy =
'Lansweeper' And tblAssetComments.Added > GetDate() - 1 And
tblState.Statename = 'Active' And tsysAssetTypes.AssetTypename In ('Windows',
'Windows CE')
Order By tblAssets.Domain,
tblAssets.AssetName,
tblAssetComments.Added Desc