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

AVEVA™ Historian

Cycle count - query 1: using a single tag

  • Last UpdatedFeb 07, 2025
  • 1 minute read

SELECT DateTime, TagName, Value

FROM History

WHERE TagName = 'SysTimeSec'

AND DateTime >= '2001-12-09 11:35'

AND DateTime < '2001-12-09 11:36'

AND wwRetrievalMode = 'Cyclic'

AND wwCycleCount = 300

The results are:

DateTime

TagName

Value

2001-12-09 11:35:00.000

SysTimeSec

0

2001-12-09 11:35:00.200

SysTimeSec

0

2001-12-09 11:35:00.400

SysTimeSec

0

2001-12-09 11:35:00.600

SysTimeSec

0

...

2001-12-09 11:35:59.200

SysTimeSec

59

2001-12-09 11:35:59.400

SysTimeSec

59

2001-12-09 11:35:59.600

SysTimeSec

59

2001-12-09 11:35:59.800

SysTimeSec

59

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