Get an overview of the spread of successful and unsuccessful scans in your Lansweeper installation to get an instant glimpse of the health of your installation. 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.
To use this in a chart widget, prefix the report name with „Chart:“ and select it in the chart report widget found on a dashboard.
Successful vs Unsuccessful Scans Chart Lansweeper Classic Query
Select sub.Name,
sub.Number
From (Select Top 1000000
'Assets with Errors' as [Name],
count(tblAssets.AssetID) as Number
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
Max(tblErrors.Teller) As ErrorID
From tblErrors
Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
ScanningError.ID
Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
Where tblState.Statename = 'Active' and (tblErrors.ErrorText Is Not Null Or
tblErrors.ErrorText != '')
UNION
Select Top 1000000
'Successful Scans' as [Name],
count(tblAssets.AssetID) as Number
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
Max(tblErrors.Teller) As ErrorID
From tblErrors
Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
ScanningError.ID
Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
Where tblState.Statename = 'Active' and (tblErrors.ErrorText Is Null Or
tblErrors.ErrorText = '')) as sub
