Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ BI Gateway On-Premises

Properties

  • Last UpdatedMar 14, 2022
  • 6 minute read

The list of properties that are returned from AVEVA Insight varies for Azure function queries.

The following properties are returned from the Azure function query for "Analogsummary" and "CQAnalogsummary".

Property Name

Datatype

Description

FQN

string

The fully qualified name for the tag. A fully qualified name uses the format: datasource.tagname.

OPCQuality

Int32

Defines the OPC quality for the data.

PercentGood

Double

The ratio of the number of rows that have "good" quality to the total number of rows in the retrieval cycle, expressed as a percentage in the range 0 to 100.

First

Double

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

DateTimeOffset

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

Last

Double

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

DateTimeOffset

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

Minimum

Double

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

DateTimeOffset

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

Maximum

Double

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

DateTimeOffset

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

Average

Double

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.

StdDev

Double

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.

Integral

Double

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.

Count

Double

Number of values in a particular cycle.

The following properties are returned from the Azure function query for "ProcessValues", "CQProcessValues", "CQProcessValuesTagTypes", and "CQProcessValuesSameDataSet".

Property Name

Description

FQN

Fully qualified name.

DateTime

Value recorded date time.

OpcQuality

Tag quality.

Text

Text value of the tag.

Value

Value of the tag.

The following properties are returned from the Azure function query for "Tags" and "TagMetadata".

Property Name

Datatype

Description

FQN

string

The fully qualified name for the tag. A fully qualified name uses the format: datasource.tagname.

TagName

string

The unique name of the tag within the AVEVA Historian system.

Source

string

The data source.

Description

string

The description of the tag.

EngUnit

string

The engineering units used for the tag's recorded values.

EngUnitMax

Double

The maximum value of the tag, measured in engineering units.

EngUnitMin

Double

The minimum value of the tag, measured in engineering units.

MessageOff

string

The message associated with the FALSE state of the discrete tag.

MessageOn

string

The message associated with the TRUE state of the discrete tag.

TagType

string

The type of tag. 1 = Analog; 2 = Discrete; 3 = String; 5 = Event, 7 = Summary tag (analog or state)

Properties returned from MES

The list of properties that are returned from MES varies for Azure function queries.

The following properties are returned from the Azure function query for "ContextEvents".

Property Name

Datatype

Description

Namespace

String

The equipment namespace.

Equipment

String

The equipment name.

StartTime

DateTime

The start time (in UTC format) of the context events.

PropertyName

String

The name of the property.

PropertyValue

String

The value of the property.

AutomationSource

String

This parameter is for internal use.

The following properties are returned from the Azure function query for "Equipment".

Property Name

Datatype

Description

Name

String

The description of an equipment. Equipment are unique by Name combined with Namespace. Also by Name combined with Location

Namespace

String

The namespace of an equipment

Description

String

The description of an equipment

Location

String

The location of an equipment

Id

String

The unique Id of an equipment

_etag

String

This an optimistic concurrency tag which prevents overlapping updates to an entity

The following properties are returned from the Azure function query for "EquipmentStates".

Property Name

Datatype

Description

Name

String

An equipment state name. This is unique across all equipment states.

Description

String

An equipment state description.

Color

String

Represents an equipment state color in the RGB format (#DC0A0A).

StateType

Number

Represents an equipment state type (1=Idle, 2=Runtime, 3=Downtime).

DisableDate

DateTime

The disabled date. If this has a value, then the state is considered deleted.

Id

String

The unique Id for an entity.

_etag

String

This an optimistic concurrency tag which prevents overlapping updates to an entity.

The following properties are returned from the Azure function query for "ProductionEvents".

Property Name

Datatype

Description

ProducedTime

DateTime

The UTC time when the production was added. The default is the current time.

Equipment

String

The equipment name.

Namespace

String

The equipment namespace.

DispositionReason

String

The disposition reason or automation value for the production that is being added. The reason must exist in the efficiency model.

DispositionType

Int32

A read-only property, which is ignored if passed. It is set internally based on the DispositionReason.

Quantity

Double

The quantity of items that were produced. Quantity can be positive or negative value. A negative quantity results in reducing existing event quantities with the same disposition reason. Negative quantities also result in an Http 204 (No Content) being returned. However, an error is returned if the negative quantity is greater than the produced quantity for the active production run.

OriginalQuantity

Double

A read-only property, which is ignored if passed. If a production event is ever adjusted due to an Edit or Reclassify, this property holds the original value before it was adjusted. Typically for internal use only.

Comment

String

A comment about the production that is being added.

AutomationSource

String

This parameter is for internal use.

Id

String

The unique Id of an equipment.

LastModified

DateTime

The UTC time when the production was modified.

_etag

String

This an optimistic concurrency tag which prevents overlapping updates to an entity.

The following properties are returned from the Azure function query for "UtilizationEvents".

Property Name

Datatype

Description

StartTime

DateTime

The start time of the utilization event.

Equipment

String

The equipment name.

Namespace

String

The equipment namespace.

Location

String

The equipment location.

StateType

Number

The equipment state type (1=Idle, 2=Runtime, 3=Downtime).

EquipmentState

String

The equipment state name.

UtilizationReason

String

The utilization reason name.

Comment

String

An event comment.

EndTime

DateTime

The end time of the utilization event.

AutomationSource

String

The Tag FQN when the utilization event is from data collection (Internal use).

Id

String

The unique Id for an entity.

_etag

String

This an optimistic concurrency tag which prevents overlapping updates to an entity.

The following properties are returned from the Azure function query for "UtilizationReasonGroups".

Property Name

Datatype

Description

GroupName

String

The utilization reason group name. This is unique across all utilization reasons.

Description

String

The utilization reason group description.

ParentGroupName

String

Name of a parent group. If blank, this is a top-level group.

Id

String

The unique Id for an entity

_etag

String

This an optimistic concurrency tag which prevents overlapping updates to an entity

The following properties are returned from the Azure function query for "UtilizationReasons".

Property Name

Datatype

Description

Name

String

The utilization reason name. This is unique across all utilization reasons.

Description

String

The utilization reason description.

AutomationValue

Number

The utilization reason automation value.

EquipmentStateId

String

The ID of the associated equipment state.

ReasonGroupNames

String

Reason groups to which this reason belongs.

DisableDate

DateTime

The disabled date. If this has a value, then the state is considered deleted.

Id

String

The unique Id for an entity.

_etag

String

This an optimistic concurrency tag which prevents overlapping updates to an entity.

TitleResults for “How to create a CRG?”Also Available in