Hi THWACK community,
I'm trying to build a custom SWQL widget (or report) in SolarWinds NPM to show the **top 20 interfaces with the highest errors** (ErrorsIn + ErrorsOut), but only for interfaces with names like:
- *** Connect
Here’s what I want to achieve: Filter interfaces by those naming patterns
Only show ones with ErrorsIn or ErrorsOut > 0
Sort by total errors (ErrorsIn + ErrorsOut)
Display InterfaceID, FullName, ErrorsIn, ErrorsOut, DetailsUrl
But when I try to do this in SWQL (especially the `ORDER BY (ErrorsIn + ErrorsOut)`), I get an error. I understand SWQL doesn’t support math expressions directly in ORDER BY. Is there a workaround that works in the Custom Table Widget?
Any working SWQL or creative workarounds would be appreciated!
Thanks in advance
– Julio