Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Table of Contents
maxLevel3
stylenone


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.

Duration is defined only for alarms that require user ACK, measuring the time from trigger to ACK.

This method 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, then is necessary 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 alarms to show the Historical values in the project .

You can leave the Duration column visible in the AlarmWindow configuration to display the alarm duration at runtime, as shown in the image below.

Image Removed

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.

Image Removed

Image Removed

Number of Occurrences

and set "Duration" column to visible by double click AlarmViewer and follow the steps below.

Step 1 - Set the "List" comboBox to "AlarmHistory". 

Image Added

Step 2 - Set "Duration" column visible. On the columns list, find and select the "Duration" one then checks the right-side checkbox called "visible".

Image Added

Now the column "Duration" will be visible on AlarmViewer.

Number of Occurrences

It's possible group de listed alarms in a AlarmViewer to 

To count how often an alarm occurs:

We have a solution for this by setting the AlarmWindow as shown below.


Then you go in Runtime and drag the "TagName" column to "Drag columns titles here to group data".

The result will be like this, and you can see the count:


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
root@parent
spacesV10