v_EventSnapshot
- Last UpdatedMar 10, 2025
- 1 minute read
Returns one row for each snapshot value for an analog and/or discrete tag (specified by the TagName column) associated with a particular snapshot event (specified by the Event column).
|
Column |
Data type |
Description |
|---|---|---|
|
Event |
nvarchar(256) NULL |
The unique name of the tag within the AVEVA Historian system. |
|
EventTime |
datetime2(7) NOT NULL |
The timestamp reflecting when event history data was acquired. This is the time when an event actually occurred. This time reflects the time zone of the AVEVA Historian. |
|
DetectionTime |
datetime2(7) NOT NULL |
The timestamp reflecting when the event was detected by the event system. |
|
Edge |
nvarchar(8) NOT NULL |
The "edge" for the event detection. For more information on edge detection, see Edge detection for events (wwEdgeDetection) in the AVEVA Historian Retrieval Guide. |
|
TagName |
nvarchar(256) NOT NULL |
The unique name of the tag within the AVEVA Historian system. |
|
Value |
float(8) NULL |
The value of the tag at the time of the event occurrence. Measured in engineering units. |
|
Quality |
tinyint NULL |
The basic data quality indicator associated with the data value. |
|
QualityDetail |
int NULL |
An internal representation of data quality. |
Note: When an event is not linked to a snapshot action, the TagName column is set to '-' and the Value, Quality, and QualityDetail columns are set to NULL.