Summary Views
- Last UpdatedMar 18, 2021
- 1 minute read
The summary views allow you to query for data that was summarized by the event subsystem. Each of the views contains data for a specific source, frequency, and operation.
|
View |
Contains One Row For Each |
|---|---|
|
DynDailyAvg |
Daily average value for a tag. |
|
DynDailySum |
Daily summary value for a tag. |
|
DynHourlyAvg |
Hourly average value for a tag. |
|
DynHourlyMax |
Hourly maximum value for a tag. |
|
DynHourlyMin |
Hourly minimum value for a tag. |
|
DynHourlySum |
Hourly summary value for a tag. |
|
v_SummaryData |
Returns one row for each summarization of a tag for an associated summary event tag. |
Each table view contains the following columns:
|
Column |
Data type |
Description |
|---|---|---|
|
TagName |
nvarchar(256) NOT NULL |
The unique name of the tag within the AVEVA Historian system. |
|
SummaryDate |
datetime2(7) NOT NULL |
The date applicable to the results of the calculation. It is either the time of the beginning or end of the calculation period, as specified by the summary operation definition. |
|
Value |
float NULL |
The value of the summary. |
|
Quality |
tinyint NOT NULL |
The basic data quality indicator associated with the data value. |