Filter High Errors & Discards Today to just device you are looking at

Question

Hi All,

I'm trying to figure out how to filter "High Errors & Discards Today" down to just the device you are viewing. I have added the following to the SQL filter for this element on the page "Nodes.NodeID like '${NodeID}'" but with no luck has anyone managed to achieve this.JonG

solarwooky · Answer

So here is what I did to get around this issue. I created 3 Advance 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.

solarwooky · Answer

Yes please ">DanielleH it's been almost a year and I don't see a response on this one. Can anyone provide a way to make this happen? I've tried everything I can think of and can find on Thwack. Please Solarwinds gurus respond and provide a quick answer. Its basically a dynamic filter, so as to show only the current node's contribution to the resource. A timely response is greatly appreciated as we are really ramping up our Solarwinds usage in our environment.

danielleh · Answer

Hi JonnyG--

I have this marked for the PM to review.

Thanks,
DH