Windows computers that have been renamed

[Susan_A]

The report below lists Windows computers that have been renamed. To enable rename detection, tick the "Detect when a computer has been renamed" checkbox in the Lansweeper web console under Configuration\Scanning Setup\Server Options.

The report will only list assets that meet all of the following criteria:

• The asset is a Windows computer.
  
• The computer's state is set to "active".
  
• The computer's Comments tab has a comment that starts with the word "renamed". If rename detection is enabled in the Lansweeper web console under Configuration\Scanning Setup\Server Options, such a comment will automatically be added if the computer is renamed and then successfully rescanned.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  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 tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetComments.Comment Like 'renamed%' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  tblAssetComments.Added Desc