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
