How do you set a severity color in modern dashboard?

I have this custom table widget in modern dashboard.
The goal is to have a status color depending on the value of the polling engine completion and beside it is the actual completion rate.

I can't seem to relate the Severity Color Value as to what value should I display. I have this in my SWQL query:

e.PollingCompletion AS [Polling Completion], CASE WHEN e.PollingCompletion < 95 THEN 'red' ELSE 'green' END AS [PollingCompletionColor],

any help is appreciated.

Find more posts tagged with

Modern Dashboards

Accepted answers

chad.every

It seems to be working in my lab. Showing a green status dot. I did remove the JOINs on applications and nodes since my lab isn't set up exactly like your deployment.

Changing the SWQL from 0 to 3 does update the icon

All comments

chad.every

Based on my tests it looks like Severity Color Value is looking for a numeric number between 0 and 5.

,CASE WHEN e.PollingCompletion < 95 THEN 3 ELSE 0 END AS [PollingCompletionColor] --Show critical when below 95

--Other Severity counts
--0 = Green (OK)
--1 = Blue (Informational)
--2 = Yellow (Warning)
--3 = Red (Critical)
--4 = Dark Red (Down)

kenyamson

Hi @chad.every , appreciate the help.
Unfortunately, it didn't work on my end.

I tried changing the values from 1 to 5 but the color is not changing.

chad.every

Can you paste the full swql query?

kenyamson

Here's for your reference.

SELECT 
  a.Node.Caption AS [Polling Engine],
  a.Name AS [Orion Services],
  a.DetailsUrl AS [_LinkFor_Orion Services],
  a.Status AS [ApplicationStatus],
  n.DetailsUrl AS [_LinkFor_Polling Engine],
  n.Status,
  e.IP AS [IP Address],
  e.ServerType AS [Server Type],
  e.EngineVersion AS [Engine Version],
  e.PollingCompletion AS [Polling Completion],
  CASE
    WHEN e.PollingCompletion < 95 THEN '3'
    ELSE '0'
  END AS [PollingCompletionColor],
  SECONDDIFF(e.KeepAlive, GETUTCDATE()) AS [Last Database Sync]

--Other Severity counts
--0 = Green (OK)
--1 = Blue (Informational)
--2 = Yellow (Warning)
--3 = Red (Critical)
--4 = Dark Red (Down)

FROM Orion.APM.Application a
JOIN Orion.Engines e ON a.Node.Caption = e.ServerName
JOIN Orion.Nodes n ON e.IP = n.IP_Address