Overview
The focus of this document is to monitor the total duration of an alarm and the occurrences per alarm. This functionality allows users to have a real-time overview of the alarm system, making it easier to understand alarm behaviors and patterns. With this information at hand, operators and system administrators can optimize system functionality and mitigate potential issuesWhen preparing a report or viewing the alarm history, it is important to highlight certain features. One key feature is the duration of past alarms recorded in the system. This document explains the procedure for configuring this aspect.
On this page:
Table of Contents maxLevel 3 style none
Alarm Duration
Total alarm duration and occurrences per alarm
Duration is defined only for alarms that require user acknowledgment (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.
This methodBy default, into the 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
AlarmWindowAlarmViewer 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
with your existing alarmsto show the Historical values in the project
. You can set up when the alarm should be logged in the alarm logger under Alarm > Groups > LogEvents.You can leave the Duration column visible in the AlarmWindow configuration to display the alarm duration at runtime, as shown in the image below.
In the context of optimizing a system's productive time, it's about reducing failures. This method can be used to display an example of the top 10 (or 20) historical failures in a system, once according to the duration and once according to frequency.
You can sort the Alarms using the Duration column, or you can filter in a button using the syntax: Duration > xxx.
As in the example below.
To count how often an alarm occurs:
We have a solution for this by setting the AlarmWindow as shown below.
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.
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 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" option, 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.
In this section:
The result will be like this, and you can see the count:
To show the duration of all individual alarms as a sum, for example:
- the ability to sort 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();
?// |
| Page Tree | ||||
|---|---|---|---|---|
|