Alert Acknowledge Count in Modern Dashboard

Hi,

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
  • Alert limitation categories that are applied to the user account which is viewing the dashboards will be handled by SWIS i.e you do not need to modify your query. If you have created alert custom properties you will need a little bit more in the query to look at the alert configuration and customproperties entities and join all these together for the activealetrs.  I do not have an example to hand right now but I'm sure there are some examples of alert custom properties in swql to be found on thwack. Ill follow back up a in when I have some cycles to look into this more.

Reply
  • Alert limitation categories that are applied to the user account which is viewing the dashboards will be handled by SWIS i.e you do not need to modify your query. If you have created alert custom properties you will need a little bit more in the query to look at the alert configuration and customproperties entities and join all these together for the activealetrs.  I do not have an example to hand right now but I'm sure there are some examples of alert custom properties in swql to be found on thwack. Ill follow back up a in when I have some cycles to look into this more.

Children