I am trying to prepare a modern dashboard, which gives me count of Active alerts grouped by various Alert Name or by Alert limitation category.
Adding to this I also want to bifurcate between Acknowledged Alerts and Unacknowledged.
i.e : In below screenshot I have figured out total Ack and Unack active alerts with the help of swql. However, if I need to know how many Ack and Unack active alerts do I have for Volume / CPU / Memory / Node Down etc! We have alert limitation category defined for CPU, Volume, Memory, Down applications & Down Nodes.
Any suggestions would be helpful. Thanks in advance.
select count(AlertObjectID) AS Quantity From Orion.AlertActive Where IsNull(Acknowledged, 0) = 0 Order by count(AlertObjectID) DESC