Get last history alarm of every alarm tree with a GQI query

Solved350 viewsalarm GQI
0
0 Comments

I want to show a table with history alarms in a dashboard, but I only want to show the latest alarm for every alarm tree. Basically like the History Tracking feature in the Cube alarm console.

If I use the "Get Alarms" data source, there will be multiple alarms returned with the same root ID (if the alarm was updated in some way). Is there any way (with a custom operator?) to only have the latest (highest Alarm ID/timestamp) alarm of every tree?

Matthijs Favorel [SLC] [DevOps Advocate] Selected answer as best 30th August 2024

1 Answer

0
12.71K 1 Comment

Hi Matthijs,

Indeed, a custom operator sounds like the way to go here. You can sort the alarms by time in descending order and return the first root alarm you encounter. A HashSet can be used to track these efficiently.

Matthijs Favorel [SLC] [DevOps Advocate] Selected answer as best 30th August 2024