Event history view
- Last UpdatedJul 22, 2024
- 1 minute read
The v_EventHistory database view lists all historical events that occurred over a selected time range. The query client specifies the starting and ending date and time range. The returned records include all non-alarm events.
|
Column Name |
Datatype |
Description |
|---|---|---|
|
EventStamp |
Datetime |
Date and time of event. |
|
TagName |
nChar |
Name of the object that generated the event, such as Pump1. |
|
Description |
nVarChar |
Description string of the event. Can default to object description, or comment in InTouch. |
|
Area |
nChar |
Name of the Area or Group for the event. |
|
Type |
nChar |
Type of event, such as "Operator data change", "Startup", and so on. |
|
Value |
nChar |
New Value (if any). |
|
CheckValue |
nChar |
Old Value (if any). |
|
Category |
nChar |
Event category or class, such as Value, Process, Batch, System, and so on. |
|
Provider |
nChar |
Generator of event, such as node/InTouch, or View Engine name for user change. |
|
Operator |
nChar |
Name of operator1: JoeR (if any). |
|
DomainName |
nChar |
Name of domain. |
|
UserFullName |
nChar |
Full name of user in operator |
|
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. |