Hi all,
In the legacy reports we have an option to get the percentage amount of time in a specific alarm state for elements using the "Top 10 states/New alarm count" building block.
How this could be possible to retrieve with a query in our new dashboards so we can manipulate or export the information as csv?
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023
Hi Edson,
I guess you'll have to use a custom operator for this. In that operator you can
- subtract the alarm root time from the current time
- calculate the percentage based on your time window
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023
Do note that this comes increasingly more complex for elements, services and views. Ideally we also support this natively in our new dashboards application.
Fyi this component is also available in the new Dashboards app by dragging a view on a “column & bar chart” visualization. But that doesn’t let you manipulate/export the data, you’ll indeed need a GQI query for this.