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.
Click to Open - 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