KPI widget to display down/critical applications with a custom property filter.

dthompson2

Hello all,

I'm new to Modern Dashboards and I'm trying to create a KPI widget that shows a down/critical application count but I need to filter by a custom property. I'm using a simple count but I'm not sure how to add the filter. Below is my count query:

SELECT COUNT(1) AS KPI_Numbe from Orion.APM.Application WHERE  (Status = 2 OR Status = 14)

The custom property I'm attempting to filter by is APM_ApplicationCustomProperties.Environment and I only want to display applications that are marked 'Prod'. I tried the following query:

SELECT COUNT(1) AS KPI_Numbe from Orion.APM.Application WHERE (${APM_ApplicationCustomProperties.Environment = 'Prod') (Status = 2 OR Status = 14)) 

For those of you who know SQL you know, that didn't work... Can someone help with this? 

christopher.t.jones123

@dthompson2, is the below what you're looking for

SELECT COUNT(APM.ApplicationID) AS KPI_Number 
from Orion.APM.Application APM
WHERE APM.APM_ApplicationCustomProperties.Environment = 'Prod' and (APM.Status = 2 OR APM.Status = 14)