We are in the process of reducing the unwanted/irrelevant active alarms in the system and we want to see how we managed to reduce the total number of alarms over a period of time via a histogram. Is there a way to do a report?
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th October 2023
Hi Charles,
In a dashboard you could create the following query:
- Data Source: Get Alarms
- Filter: Select the column IsActive and set the value to False (This filter will allow you to look for history alarms)
- Filter: Root time. Here you can define a time filter. In case you would like to use a time range, you could define two filters instead of one. Another option is passing the selection from a time range feed
- Aggregate based on Alarm ID (choose 'Get the Count')
- Group by: Select the column 'Parameter Description'. Using 'Parameter Description'
You can display the result of the query in a table component or a column and bar chart component.
Please keep in mind that the query could take some time to display the result.
Hope it helps.
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th October 2023