PercentLoss not working

Question

Hi All,

Remarkably simple query I hope. Creating a dashboard widget using the "Availability of Each Node". I don't want it to display nodes which have 100% availability as the list is massive.

I've tried

Node.PercentLoss < 95

PercentLoss < 95

PercentLoss <> 100

With and without spaces. Each time I get "Custom SWQL filter is incorrectly formatted."

KMSigma.SWI · Answer

Ah - a classic dashboard.  I misunderstood thinking you were asking about a Modern Dashboard.

I copied the existing widget from the Network Summary and then put in...

PercentLoss > 50

...for the filter.

What version are you running and what's the type of widget you placed on the page?

The above was tested on SolarWinds Platform 2023.4.0 and using the "All Nodes - Tree" widget type.

ZakWooldridge · Answer

PercentLoss > 10

Like this

ZakWooldridge · Answer

This is within the "Edit Resource" menu of the widget. The section reads:

Filter Nodes (SWQL): PercentLoss<>100

Filters are optional and can be used to limit the list of Nodes displayed.
This is an advanced feature. We recommend you have a basic understanding of SWQL Queries.

If I use say "status = 2", the filter works and returns nodes that are down. I can see the node property "PercentLoss" exists in the list but I am unsure if I am using the correct syntax.