Discover Scan Issues In Your Lansweeper Installation
Get an overview of all the scanning errors in your Lansweeper installation with details on what the error is, and which credentials have been tried in the past or were successful at some point in time. Using this information you can more accurately pinpoint what is causing issues with scanning in your network and more easily find out how you can resolve those issues. You can always find more information about any scanning issue you come across in our knowledgebase which has a huge library of articles to help you troubleshoot and resolve issues. To get more info on error handling you can also check out the related Pro Tips blog post.
Scan Issues with Credentials Used Lansweeper Classic Query
Select Top (1000000) tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetName,
tblAssets.AssetID,
tblErrors.CFGname,
tsysasseterrortypes.ErrorMsg As Issue,
tblErrors.ErrorText As [Issue Message],
tblassets.LastseenCredentials as [Last Successful Credentail],
tblassets.LasttriedCredentials as [Last Tried Credential],
tblassets.LasttriggeredCredentials as [Last Manually Triggered Tried Credential],
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan],
tblAssets.Lasttried,
tblErrors.Lastchanged
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 Outer 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
