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

AVEVA™ Historian

AnalogWideHistory

  • Last UpdatedMar 18, 2021
  • 1 minute read

This table (INSQL.Runtime.dbo.AnalogWideHistory) has been superceded by the WideHistory (INSQL.Runtime.dbo.WideHistory) table. AnalogWideHistory is the wide version of AnalogHistory. In a query, this table must be referenced using an OPENQUERY statement.

Column

Data type

DateTime

datetime NOT NULL

TagA1

float NULL

TagA2

float NULL

ManyOtherTags

float NULL

wwRowCount

int NULL

wwResolution

int NULL

wwEdgeDetection

nvarchar(16) NULL

wwRetrievalMode

nvarchar(20) NULL (default wwRetrievalMode is CYCLIC)

wwTimeDeadband

int NULL

wwValueDeadband

real NULL

wwTimeZone

nvarchar(50) NULL

wwVersion

nvarchar(30) NULL

wwCycleCount

int NULL

wwTimeStampRule

nvarchar(20) NULL

wwInterpolationType

nvarchar(20) NULL

wwQualityRule

nvarchar(20) NULL

wwParameters

nvarchar(128) NULL

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