I'm fairly new to SWQL and SQL. Im having a hard time to make this swql query work.
SELECT COUNT(1) as Count_Items, a.Status
FROM Orion.APM.Application a
JOIN Orion.Nodes n
ON n.NodeID = a.NodeID
WHERE Status = 14 AND n.CustomProperties.Device_Prio LIKE 'Prio1%'
GROUP BY a.Status
This counts the critical applications with a custom property. To make it more presentable I would like to show it as zero when null is returned instead of blank in the widget. Thank in advance!