v_SnapshotData
- Last UpdatedMar 10, 2025
- 1 minute read
Returns one row for each snapshot value for an analog, discrete, and/or string tag (specified by the TagName column) associated with a particular snapshot event (specified by the Event column).
|
Column |
Data type |
Description |
|---|---|---|
|
Event |
TagNameType(nvarchar(256)) NULL |
The name of the event tag to which the snapshot tag is related. |
|
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. |
|
TagName |
nvarchar(256) NOT NULL |
The unique name of the tag within the AVEVA Historian system. |
|
Value |
nvarchar(512) NULL |
The value of the snapshot tag at the event timestamp. |
|
Quality |
tinyint NULL |
The basic data quality indicator associated with the data value. |
|
QualityDetail |
int NULL |
An internal representation of data quality. |