AlarmCounter database stored procedure
- Last UpdatedJul 22, 2024
- 1 minute read
This stored procedure returns the number of times a unique alarm occurred in a time interval. A unique alarm is identified by its TagName, Provider, Alarm Type, and Category.
The counter only applies to the number of alarm originations (not transitions such as acknowledges or returns-to-normal). So, for example, if an alarm occurred and then was acknowledged and then returned to normal, the count for that alarm is only 1 (not 3).
The query must specify the starting and ending date and time. It has five optional parameters: TagName, Class, Type, Provider and Comment.
An example question answered by this view: How many times did object TIC101 (TagName) on provider Node1|InTouch (Provider) go into a Value alarm (Category) that was HiHi (Type) during a time span?
Note: The AlarmCounter stored procedure applies only to the Detailed logging mode and is not supported by Consolidated logging.
sp_AlarmCounter
|
Column Name |
Datatype |
Description |
|---|---|---|
|
TagName |
Nchar |
Name of the object that generated the alarm, such as TIC101. |
|
GroupName |
Nchar |
Name of the area or group for the alarm |
|
AlarmType |
Nchar |
Type of alarm such as Hi, HiHi, ROC, PV, HiAlarm. |
|
AlarmClass |
Nchar |
Alarm class or alarm category such, as Value, Process, Batch, etc. |
|
AlarmCount |
Integer |
Number of onsets of the alarm during the time range. |
|
Priority |
Integer |
Alarm priority. |
|
Provider |
Nchar |
Provider of alarm, such as node/InTouch, or GalaxyName. |
|
Comment |
Nchar |
The alarm comment. |
An example query is:
EXECUTE sp_AlarmCounter @StartDate=’2007-01-01 23:23:23’, @EndDate=’2007-03-31 23:23:23’, @Tagname = ’$NewAlarm’