Overview
When one wishes to prepare a report or simply view the alarm history, certain features are of importance to highlight. Among these features is the duration of alarms that were triggered in the past and are recorded in the system. This document elucidates the procedure for configuring this aspect.
On this page:
Alarm Duration
Duration is defined only for alarms that require user ACK, measuring the time from trigger to ACK. The following model presents a step-by-step method on how to obtain the total duration of an alarm and occurrences per alarm.
By default, into de SQL tables that register the alarm events there is a column called "Duration", since the data shown in the AlarmWindow comes from this database, viewing the duration of alarms is based on how to display this information in the AlarmWindow or in a separate data grid, so this procedure requires some historical alarm data in which there was an ACK from the user.
To obtain the duration of an alarm and other related information, configure the AlarmWindow to show the Historical values in the project and set "Duration" column to visible by double click AlarmViewer and follow the steps below.
Step 1 - Set the "List" comboBox to "AlarmHistory".
Step 2 - Set "Duration" column visible. On the columns list, find and select the "Duration" one then checks the right-side checkbox called "visible".
Now the column "Duration" will be visible on AlarmViewer.
Number of Occurrences
You can group alarms listed in an AlarmViewer to get an idea of how many times the alarm has gone off.
To achieve this, the AlarmViewer component features a drag-and-drop column functionality, which is, by default, disabled. However, it is possible to enable it by double-clicking on the AlarmViewer, then checking the 'Show Header' checkbox. This will activate the option only during runtime.
To utilize it, select the column "TagName", drag it to the new area in the AlarmViewer's "Drag columns titles here to group data", like the following example.
If you have a substantial number of alarms, it is possible to collapse the grouped elements to enhance visualization. Simply click on the plus and minus icons to expand or contract them.
To show the duration of all individual alarms as a sum:
An example would be sorting the TagNames by the number of items to find the alarms that occur most often, to see which generates more "beeps" or micro-stops.
It is possible to show the duration of all individual alarms through a query. Here is the code below:
// @Dataset.Query.Query1.SqlStatement = "SELECT COUNT(TagName) como AlarmCount, TagName, SUM(Duration/10000000) como DurationSum FROM Alarms GROUP BY TagName ORDER BY COUNT(TagName);"; @Tag.Table1 = @Dataset.Query.Query1.SelectCommand(); ?//
In this section: