AnalogSummaryHistory (INSQL​.Runtime​.dbo​.AnalogSummaryHistory)

TagName

nvarchar(256)
NOT NULL

The name of the summary tag.

StartDateTime

datetime2(7)
NOT NULL

Start time of the retrieval cycle for which this row is returned.

EndDateTime

datetime2(7)
NOT NULL

End time of the retrieval cycle for which this row is returned.

SliceBy

int, Discrete, or String

Performs dynamic resolution/cycle computation by tag. Returns one Analog Summary value per tag per dynamic cycle with start and end date time.

SliceByValue

var

Specifies the filter criterion to get the summary values for SlicedBy, based on that filter value.

OPCQuality

int NULL

OPC quality. Normal OPC quality retrieval logic is applied if:

• All the points found and processed for this row have GOOD quality. If they all have the same GOOD quality, then that quality is returned.

• If there is a gap in the entire calculation cycle, then BAD quality is returned for the tag.

• For any other scenario with any mixture of GOOD and BAD points, a DOUBTFUL OPC quality (64) is returned.

PercentGood

float NULL

Time in seconds that the value was good for the retrieval cycle (pro-rated for partial cycles).

First

float NULL

If at least one non-NULL point exists for the tag in question within the retrieval cycle, then the value returned is the first point stored with a time stamp within the retrieval cycle. If no points exist within the retrieval cycle, then the value returned is the current value at the cycle start time.

If no non-NULL points can be found, then NULL is returned.

FirstDateTime

datetime2(7) NULL

Timestamp associated with first value. This might be earlier than StartDateTime if this is the initial value for the retrieval cycle.

Last

float NULL

If at least one non-NULL point exists for the tag in question within the retrieval cycle, then the value returned is the last point stored with a time stamp within the retrieval cycle. If no points exist within the retrieval cycle, then the value returned is the current value at the cycle start time.

If no non-NULL points can be found, then NULL is returned.

LastDateTime

datetime2(7) NULL

Timestamp associated with last value. This might be earlier than StartDateTime if this is the initial value for the retrieval cycle.

Minimum

float NULL

If at least one non-NULL point exists for the tag in question within the retrieval cycle, then the value returned is the minimum point stored with a time stamp within the retrieval cycle. If no points exist within the retrieval cycle, then the value returned is the current value at the cycle start time.

If no non-NULL points can be found, then NULL is returned.

MinDateTime

datetime2(7) NULL

Timestamp associated with Min value. NULL if Min is NULL.

Maximum

float NULL

If at least one non-NULL point exists for the tag in question within the retrieval cycle, then the value returned is the maximum point stored with a time stamp within the retrieval cycle. If no points exist within the retrieval cycle, then the value returned is the current value at the cycle start time.

If no non-NULL points can be found, then NULL is returned.

MaxDateTime

datetime2(7) NULL

Timestamp associated with Max value. NULL if Max is NULL.

Average

float NULL

Time weighted average value of retrieval cycle. This is calculated by using the individual summary averages. The calculation is "Sum(average * delta t) / Total time of average in all cycles" - delta t is prorated for any partially contained storage cycles For analog tags, the calculation is "Sum(value * delta t) / Total time. (This is like the values returned by an Average query against the History table for a cycle of the same length, where the History row DateTime is the same as the EndDateTime here.)

StdDev

float NULL

Time weighted standard deviation value of the retrieval cycle. The value is calculated using time weighted sums (Integrals) and time weighted sums of squares (IntegralOfSquares) values, prorated for any partially contained storage cycles.

For analog tags, similar StdDev values are produced for each cycle.

Integral

float NULL

Area under value curve of retrieval cycle. The calculation is "Sum(value * delta t) / Total time of integral in all cycles" - delta t is prorated for any partially contained storage cycles For analog tags, the calculation is "Sum(value * delta t) / Total time. (This is like the values returned by an Integral query against the History table for a cycle of the same length, where the History row DateTime is the same as the EndDateTime here.)

For analog tags, similar Integral values are produced for each cycle.

ValueCount

int NULL

Number of values in a particular cycle.

SourceTag

nvarchar(256) null

The source (tier 1) tag for the summary tag.

SourceServer

nvarchar(256) null

The source (tier 1) server for the summary tag.

wwCycleCount

int NULL

The number of cycles into which the entire query time range has been divided.

wwResolution

int NULL

Length of cycles in milliseconds. The default is 3600000 (equal to 1 hour).

wwTimeZone

nvarchar(50) NULL

Time zone to use for interpreting both input and output timestamp parameters. If none is specified, then the default is set to LOCAL.

wwVersion

nvarchar(30) NULL

Data version, ORIGINAL or LATEST. If none is specified, the default is LATEST.

wwTagKey

int NOT NULL

Tag key.

wwRetrievalMode

nvarchar(16) NOT NULL

Determines whether to use CYCLIC, DAILY, or DELTA retrieval. The default is DELTA.

wwExpression

nvarchar(4000) NULL

Used to specify an expression for unit of measure conversion, specified in the following format using tag/unit pairs:

UOM(TAG1,UNIT1;TAG2,UNIT2;...)

For example, the expression UOM(DistanceTag,m;TempTag,F;DurationTag,Minute)returns the values for the tag named DistanceTag measured in meters, the values for TempTag measured in degrees Farenheit, and the values for DurationTag measured in minutes.

The following rules apply:

1. If any of the unit conversions specified are invalid and fail (for example, trying to convert a tag measured in meters to a unit of hours) then no unit conversions are performed.

2. If any tags specified in the expression for unit conversion are not part of the query, those tags will be ignored for the purpose of unit conversion.

wwUnit

nvarchar(512) NULL

Returns the currently used unit of measure.