Custom Query: Color for node's status

I have a Custom Query Resource to display Nodes with their CPU/Ram,etc....

SELECT
'' AS n,
n.Caption as NODE,
n.Stats.CPULoad AS CPU,
n.Stats.PercentMemoryUsed AS RAM,
'/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_n],
'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.NodeID) AS [_LinkFor_NODE]
FROM
Orion.Nodes(nolock=true) n
ORDER BY
n.Stats.CPULoad DESC , n.Stats.PercentMemoryUsed DESC

It works quite well, but I wonder if there is a way to change the warning color for CPU & RAM fields (red as critical, yellow as warning, link is a plus....). As of right now, they are shown as plain text.

Find more posts tagged with

color_indicator

query

SWQL

npm

custom

Accepted answers

All comments

tdanner

Custom Query Resource does not have a way to specify conditional styles for columns, but that's a great idea.

lonton

That's a shame, I thought we could include them as icon or link within the query, since that features already there