Eventlog Errors Last 14 Days Chart

Find all Error Event logs in Your Network in the Last 2 Weeks

With this chart report, you can have a quick overview of the number of error events scanned in your environment. This can be used on your dashboard so you always have the information available at a glance. Below you can find an example of one of the chart types available in the chart report widget which gives a view of the number of error events scanned per day.

Errorlog events chart

Eventlog Errors Last 14 Days Chart Query

Select Top 1000000 Convert(nVARCHAR(10),tblNtlog.TimeGenerated,102) As Thedate,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1 And
  tblNtlog.Eventtype = 1 And tblNtlog.TimeGenerated > GetDate() - 14
Group By Convert(nVARCHAR(10),tblNtlog.TimeGenerated,102)
Order By Thedate Desc

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting