Alert Acknowledge Count in Modern Dashboard


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

Parents Reply Children
No Data