This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Alert Acknowledge Count in Modern Dashboard

WinterSoldier over 3 years ago

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

0 tony.johnson over 3 years ago

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.
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 tony.johnson over 3 years ago

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.
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 WinterSoldier over 3 years ago in reply to tony.johnson

Hi Tony,

Thank you for responding.

We don't have custom property created for alert limitation category. Please refer below article : Alert limitation category (solarwinds.com)
Cancel
Vote Up 0 Vote Down

Cancel