Overview
When one wishes to prepare preparing a report or simply view viewing the alarm history, it is important to highlight certain features are of importance to highlight. Among these features . One key feature is the duration of alarms that were triggered in the past and are past alarms recorded in the system. This document elucidates explains the procedure for configuring this aspect.
On this page:
Table of Contents maxLevel 3 style none
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 AlarmViewer Control 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 - At Columns, select Duration and check the Visible checkbox at the bottom right.
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 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" option, like the as 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:
| Code Block |
|---|
//
@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:
| Page Tree | ||||
|---|---|---|---|---|
|