Top 10 Errors Today by Node (Web Only Report)

Version 1

    I created this based on the report from RichardLetts Top 25 Errors This Hour report. 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.