I created this based on the report from ">RichardLetts . This report just changes the timeframe from this hour to today on the field InErrorsThisHour to InErrorsToday. Then I just change the TOP 25 to TOP 10 but you can play with that as you like.
Here is the special part about this report. It will not actually generate a result when you Execute SQL Query in Report Writer as this will generate a "SQL Error: Syntax error or access violation" because of the WHERE statement having the ${NodeID} variable.
This report can only be run as it is embedded in a type of Node details view. The report dynamically chooses the node to which the report is associated by using the WHERE ( Interfaces.NodeID = ${NodeID} ) statement.
Comments are appreciated.
