custom sql query to filter the "Top XX Errors & Discards This Hour"?

The SQL Filter will need to be:

Nodes.DeviceType = 'WAN_Router'

Appreciated

Thanks for the tip - One question, How is the Node ID assigned?

by assorted node attributes or is it a SQL function or....?

tks

">sean.martinez how do I get this done for a single node dynamically. I'd like to use the errors and discards resource on a single node basis. I've tried things like Nodes.NodeID = ${NodeID} but this only give a custom sql error on the web interface.

Any clues or ideas?

sean.martinez here is what I did to get around this single node dynamic query issue. I created 3 Advanced SQL reports in Report Writer, 2 of which directly address the challenge but do not resolve the overall inquiry.

I created the reports based on the report from RichardLetts Top 25 Errors This Hour report. Here they are:

If they work for you, just hit that little "Like" button on the side there. And make it better if you have the skill. My SQL skills are limited. I would love to see this for as much as a week or multiday.