Top 10 Errors This Hour by Node (Web Only Report)

Version 1

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