Front Panel Widget to Show Scanning Errors?

[rvdsabu4life]

Is there a report or widget I can add to the front page of Lansweeper to show the total scanning errors of devices? Something that might total or display similar to the attachment.

[Susan_A · Accepted solution]

We received and answered this question via email as well. I'm pasting a copy of the response we sent via email, for anyone else interested.

Thank you for your email. We've included two sample reports below, one that lists the non-Windows device errors and one that counts the number of devices in error, per error message. You can display the report results of any report on your dashboard with the built-in Data Report widget.

Instructions for adding the reports below to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tsysasseterrortypes.ErrorMsg,
  tblErrors.CFGname,
  tblErrors.ErrorText,
  tblErrors.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
  Inner Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
    tblErrors.ErrorType
Where tsysAssetTypes.AssetTypename <> 'Windows' And tblAssetCustom.State = 1
Order By tblErrors.Lastchanged Desc

Select Distinct Top 1000000 tsysasseterrortypes.ErrorMsg,
  Count(tblAssets.AssetID) As Count
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
  Inner Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
    tblErrors.ErrorType
Where tsysAssetTypes.AssetTypename <> 'Windows' And tblAssetCustom.State = 1
Group By tsysasseterrortypes.ErrorMsg