InfluxDB storage format and schemas

An organization is a workspace for a group of users. All dashboards, tasks, buckets, members, and so on, belong to an organization. The default organization in the built-in InfluxDB is
Rockwell
, which cannot be changed. If you have an external InfluxDB, you can use its existing organization.
The InfluxDB data model organizes time series data into buckets and measurements. A bucket is a named location where time series data is stored and it can contain multiple measurements. The bucket name is the name of your HMI server. To view your bucket list, use the command
influx bucket list
. You can also view the bucket list and historical logs with the InfluxDB UI. Measurements contain multiple tags and fields.
For more information, see InfluxDB OSS documentation, Line protocol and InfluxDB schema design or refer to your own InfluxDB version's documentation.
Measurement
InfluxDB Data Element
Key or Column
Description
TagData
Tag
TagName
The name of the tag in the FactoryTalk system.
S
Status:
  • C
    : Common
  • D
    : Tag disabled
  • E
    : Error
  • S
    : Stale data
  • U
    : Uninitialized data
Field
V_B
Boolean value
V_I
Integer value
The integers are logged in InfluxDB with a value range of INT64. FactoryTalk View tags of the integer type such as ULINT, UDINT, and so on are logged with this type, adhering to the INT64 value range.
V_D
Double value
FactoryTalk View tags of the REAL and LREAL types are logged in InfluxDB with this type.
V_S
String value
M
Marker value:
  • B
    : Begin
  • E
    : End
  • S
    : Snapshot
  • Blank: Common data
The following measurements are used for data processing purposes. Do not modify them.
  • LastRecordInfo
    : Records the time of the last record.
  • SyncTask
    : Records the status of sync tasks.
  • SnapshotTask
    : Records the status of snapshot tasks.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal