Alarm event history view
- Last UpdatedJul 22, 2024
- 2 minute read
The v_AlarmEventHistory database view provides a historical list of all events and alarms that occurred over a selected time range. The query client specifies start and end date and time. The returned records include all alarms and events. This view combines the alarm view and event view into one and represents the union of the records from those views.
|
Column Name |
Datatype |
Description |
|---|---|---|
|
EventStamp |
Datetime |
Date and time of event. |
|
AlarmState |
nChar |
State of alarm: one of UNACK, UNACK_RTN, ACK, ACK_RTN, LATCHED. Does not apply for events. |
|
TagName |
nChar |
Name of the object that generated the alarm, such as TIC101. |
|
Description |
nVarchar |
Description string of the alarm/event. Can default to object description (or comment
in InTouch). |
|
Area |
nChar |
Name of the Area or Group for the alarm. |
|
Type |
nChar |
Type of alarm or event, such as Hi, HiHi, ROC, PV.HiAlarm, Operator data change, and so on. |
|
Value |
nChar |
Value of alarm variable at time of alarm. |
|
CheckValue |
nChar |
Value of alarm limit at time of alarm, or old value for event. |
|
Priority |
Integer |
Alarm priority. |
|
Category |
nChar |
Alarm or event class, or alarm category, such as Value, Process, Batch, System, and so on. |
|
Provider |
nChar |
Provider of alarm, such as node/InTouch, or GalaxyName. |
|
Operator |
nChar |
Name of acknowledgement operator or data change operator. |
|
DomainName |
nChar |
Name of domain. |
|
UserFullName |
nChar |
Full name of user in operator |
|
UNACKDuration |
Float |
Number of milliseconds from the most recent alarm transition to ACK. |
|
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 event. |
|
Millisec |
Small Int |
Fractional seconds for event stamp in increments |
The v_AlarmEventHistory2 view is a variation of the v_AlarmEventHistory view.
|
Column Name |
Datatype |
Description |
|---|---|---|
|
EventStamp |
Datetime |
Date and time of event. |
|
AlarmState |
nChar |
State of alarm: one of UNACK, UNACK_RTN, ACK, ACK_RTN, LATCHED. Does not apply for events. |
|
TagName |
nChar |
Name of the object that generated the alarm, such as TIC101. |
|
Description |
nVarchar |
Description string of the alarm/event. Can default to object description (or comment
in InTouch). |
|
Area |
nChar |
Name of the Area or Group for the alarm. |
|
Type |
nChar |
Type of alarm or event, such as Hi, HiHi, ROC, PV.HiAlarm, Operator data change, and so on. |
|
Value |
nChar |
Value of alarm variable at time of alarm. |
|
CheckValue |
nChar |
Value of alarm limit at time of alarm, or old value for event. |
|
Priority |
Integer |
Alarm priority. |
|
Category |
nChar |
Alarm or event class, or alarm category, such as Value, Process, Batch, System, and so on. |
|
Provider |
nChar |
Provider of alarm, such as node/InTouch, or GalaxyName. |
|
Operator |
nChar |
Name of acknowledgement operator or data change operator. |
|
DomainName |
nChar |
Name of domain. |
|
UserFullName |
nChar |
Full name of user in operator |
|
AlarmDuration |
Float |
Number of milliseconds from the onset of alarm to the return to normal (RTN). |
|
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 event. |
|
Millisec |
Small Int |
Fractional seconds for event stamp in increments of 0.1 msec. |