All Scanning Errors

Find All Lansweeper Related Scanning Errors

Report on all scanning errors within Lansweeper and identify devices that require your attention. Incorrect credentials, closed ports and other network related issues can prevent Lansweeper from scanning assets. Even OS updates can cause changes which prevent data from being retrieved from the devices. This report provides an overview of all assets which have had a scanning error. This allows you to start troubleshooting and figure out exactly why some assets are no longer being scanned.

All Scanning Errors Query

Select Top 1000000 tblAssets.AssetName,
  tblAssets.AssetID,
  'Not scanned' As OS,
  tblErrors.CFGname,
  tsysasseterrortypes.ErrorMsg As ErrorType,
  tblErrors.ErrorText As Message,
  tblErrors.Lastchanged,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  'notscanned.png' As icon
From tblAssets
  Inner Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysasseterrortypes On
    tblErrors.ErrorType = tsysasseterrortypes.Errortype
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1 And Coalesce(tblAssets.OScode, '') = ''
Order By tblErrors.Lastchanged Desc,
  tblAssets.AssetName