Would anyone be able to help with changing the Color of a KPI Widget when the Alert Count is greater than 0. When it's 0 I would like it to be green and when it's greater than 0 I would like it to change to red. In addition it would be nice if it would flash Yellow when a new alert appears, but not necessary. Thank you!!
SELECT COUNT(1) AS PROD
FROM [orion].[AlertActive] aa
LEFT OUTER JOIN [orion].[AlertObjects] ao ON aa.alertobjectid = ao.alertobjectid
LEFT OUTER JOIN [orion].[Nodes] n ON ao.RelatedNodeId = n.NodeID
LEFT OUTER JOIN orion.NodesCustomProperties nc ON nc.NodeID = n.NodeID
LEFT OUTER JOIN orion.AlertConfigurations ac ON ac.AlertID = ao.AlertID
where aa.Acknowledged is null
and nc.Environment = 'Prod'
