Hi all, need some assistance please creating a modern dashboard KPI widget for Application Availability and KPI Widget showing Up/Down
The following returns the value, any way for it to display Up or Down?
SELECT count(1) as count_apps From orion.Apm.Application where DisplayName = 'SolarWinds Health' AND statusDescription = 'Up'
OR
SELECT count(1) as count_apps From Orion.APM.Application where DisplayName = 'SolarWinds Health' AND Status = '2'
Thanks