SWQL Top 10 from threshold limits rather than in-built 80/90 settings

OK so I have certain servers (SQL being one of them) where I have changed the threshold limits on.

Now my query lies around the default top 10 dashboards, it shows anything that exceeds the 80% limits as yellow line graph and 90% red line graph.

However the SQL servers I only want to show them as yellow at 90% and red at 95% for example.

I have got this SWQL so far but need further assistance;

SELECT [Nodes].Caption
, '/Orion/images/StatusIcons/Small-' + [Nodes].StatusIcon AS [_IconFor_Caption]
, [Nodes].PercentMemoryUsed
, [Nodes].DetailsUrl AS [_LinkFor_Caption]
FROM Orion.Nodes AS [Nodes]
WHERE PercentMemoryUsed > 80
ORDER BY [Nodes].PercentMemoryUsed DESC

Find more posts tagged with

top 10

graph

threshold

SWQL

thresholds

npm

Memory

Accepted answers

All comments

SW_United

The top one is SQL server and the others show additional servers

SW_United

Here is an update to what I think it should be however still not working yet, would really appreciate someone's help with this;

SELECT [Nodes].Caption
, '/Orion/images/StatusIcons/Small-' + [Nodes].StatusIcon AS [_IconFor_Caption]
, [Nodes].NodesPercentMemoryUsedThreshold
, [Nodes].DetailsUrl AS [_LinkFor_Caption]
FROM Orion.Nodes AS [Nodes]
WHERE Islevel1State = 1