CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more


Eventlog Errors Last 14 Days Chart

Chart Operating System Security

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

The Windows error events are often a good indication whether issues are present within your network. A large influx of error events often indicates an issue.  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.
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.
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




Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.