Alert Management on KPI Widget with Custom Property set

jasonford1971

Hi all - i have the following swql (below) for my alerting KPI - but i need to included the following customer property - CustomProperties.CoreProductionSystem LIKE '%YES%' where would i add this into the swql - thanks

Alerts (Acknowledged)

SELECT COUNT (AlertObjectID) AS Quantity
FROM Orion.AlertActive
WHERE IsNull (Acknowledged, 0) = 1
ORDER BY COUNT (AlertObjectID) DESC

Alerts (Un-Acknowledged)

SELECT COUNT (AlertObjectID) AS Quantity
FROM Orion.AlertActive
WHERE IsNull (Acknowledged, 0) = 0
ORDER BY COUNT (AlertObjectID) DESC

Lofstrand

Hi @jasonford1971

Depends on where the custom property is placed. Is it on the alert rule? In that case the Query could look like this:

SELECT

COUNT (A.AlertObjectID) AS Quantity

FROM Orion.AlertActive AS A

WHERE

IsNull (A.Acknowledged, 0) = 0

AND A.AlertObjects.AlertConfigurations.CustomProperties.ResponsibleTeam LIKE '%YES%'

If the Custom Property is on Node, application or other, the query will be changed.