2 Replies Latest reply on Oct 14, 2014 9:30 AM by lonton

    Custom Query: Color for node's status

    lonton

      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.