Alarm history view
- Last UpdatedJul 22, 2024
- 2 minute read
The v_AlarmHistory view contains all historical alarms and alarm transition events that occurred over a selected time range. The query specifies start and end date and time (the EventStamp or EventStampUTC column). The returned records include alarm origination, alarm acknowledge, alarm enable, alarm disable, and alarm return-to-normal events.
The following table describes the view columns:
|
Column Name |
Datatype |
Description |
|---|---|---|
|
EventStamp |
Datetime |
Date and time of alarm event (in local time of database). |
|
AlarmState |
nChar |
State of alarm: one of UNACK, UNACK_RTN, ACK, ACK_RTN, LATCHED. |
|
TagName |
nChar |
Name of the object that generated the alarm, such as TIC101. |
|
Description |
nVarchar |
Description string of the alarm. Can default to object description (or comment in
the InTouch HMI). |
|
Area |
nChar |
Name of the Area or Group for the alarm. |
|
Type |
nChar |
Type of alarm, such as Hi, HiHi, ROC, PV.HiAlarm. |
|
Value |
nChar |
Value of alarm variable at time of alarm. |
|
CheckValue |
nChar |
Value of alarm limit at time of alarm. |
|
Priority |
Integer |
Alarm priority. |
|
Category |
nChar |
Alarm class or alarm category. Such as Value, Dev, ROC, Process, Batch, System, and so on. |
|
Provider |
nChar |
Provider of alarm: node/InTouch, or GalaxyName. |
|
Operator |
nChar |
Name of the operator. |
|
DomainName |
nChar |
Name of the domain. |
|
UserFullName |
nChar |
Full name of user in operator |
|
UNACKDuration |
Float |
The time between the most recent alarm transition (alarm or sub-state) and the acknowledgement, if any. |
|
User1 |
Float |
User-defined field number 1. |
|
User2 |
Float |
User-defined field number 2. |
|
User 3 |
nChar |
User-defined field, string. |
|
EventStampUTC |
DateTime |
UTC date/ time of alarm event. |
|
Millisec |
Small Int |
Fractional seconds for event stamp in increments |
|
OperatorNode |
nvarchar(32) |
Name of the node where the operator acknowledged the alarm. |
The v_AlarmHistory2 view is a variation of the v_AlarmHistory view.
|
Column Name |
Datatype |
Description |
|---|---|---|
|
EventStamp |
Datetime |
Date and time of alarm event (in local time of database). |
|
AlarmState |
nChar |
State of alarm: one of UNACK, UNACK_RTN, ACK, ACK_RTN, ACK_ALM, UNACK_ALM, LATCHED |
|
TagName |
nChar |
Name of the object that generated the alarm, such as TIC101. |
|
Description |
nVarchar |
Description string of the alarm. Can default to object description (or comment in InTouch). Or acknowledge comment for acknowledgement records. |
|
Area |
nChar |
Name of the Area or Group for the alarm. |
|
Type |
nChar |
Type of alarm, such as Hi, HiHi, ROC, PV.HiAlarm. |
|
Value |
nChar |
Value of alarm variable at time of alarm. |
|
CheckValue |
nChar |
Value of alarm limit at time of alarm. |
|
Priority |
Integer |
Alarm priority. |
|
Category |
nChar |
Alarm class or alarm category. Such as Value, Dev, ROC, Process, Batch, System, and so on. |
|
Provider |
nChar |
Provider of alarm: node/InTouch, or GalaxyName. |
|
Operator |
nChar |
Name of operator: JoeR (if any). |
|
DomainName |
nChar |
Name of domain. |
|
UserFullName |
nChar |
Full name of user in operator |
|
AlarmDuration |
Float |
The time between onset of the alarm and return to normal. |
|
User1 |
Float |
User-defined field number 1. |
|
User2 |
Float |
User-defined field number 2. |
|
User 3 |
nChar |
User-defined field, string. |
|
EventStampUTC |
DateTime |
UTC date/ time of alarm event. |
|
Millisec |
Small Int |
Fractional seconds for event stamp in increments |