Page History

...

• MQTT_RAW

  • This table contains information derived from each MQTT message as detailed below

    • INSERTED_AT
    • INSERTED_AT_DATE
    • MSG
    • MSG_ID
    • MSG_TOPIC

Image RemovedImage Added

Node Database

The Node database contains five tables: SPARKPLUG_DEVICE_MESSAGES, SPARKPLUG_DEVICE_REGISTRY, SPARKPLUG_EDGE_NODE_REGISTRY and SPARKPLUG_TEMPLATE_DEFINITION_REGISTRY

...

• SPARKPLUG_DEVICE_REGISTRY
  • Shows all of the devices, whether or not they’re alive, and their BIRTH messages
    • GROUP_ID
    • EDGE_NODE_ID
    • DEVICE_ID
    • IS_ALIVE
    • LAST_UPDATE
    • BIRTH_MESSAGE

Image Modified

• SPARKPLUG_EDGE_NODE_REGISTRY
  • Shows all of the edge nodes, whether or not they’re alive, BIRTH messages and BD seq number
    • GROUP_ID
    • EDGE_NODE_ID
    • DEVICE_ID
    • IS_ALIVE
    • LAST_UPDATE
    • BIRTH_MESSAGE
    • BQ_SEQ

Image Modified

• SPARKPLUG_TEMPLATE DEFINITION_REGISTRY
  • Shows the templates (UDT defs), their version, and their definitions
    • TEMPLATE_PATH
    • TEMPLATE_VERSION
    • TEMPLATE_DEFINITION
    • LAST_UPDATE

Image RemovedImage Added

• SPARKPLUG_TEMPLATE_INSTANCE_REGISTRY
  • Shows all of the template instances (UDT instances), group/edge/device IDs, TEMPLATE_PATH (used to be DEVICE_NAME), TEMPLATE_REFERENCE (UDT def name), and the template definition
    • GROUP_ID
    • EDGE_NODE_ID
    • DEVICE_ID
    • LAST_UPDATE
    • TEMPLATE_PATH
    • TEMPLATE_VERSION
    • TEMPLATE_DEFINITION
    • LAST_UPDATE
    • TEMPLATE_REFERENCE

...

• Example: CL_BRIDGE_NODE_DB.NB_GROUP_EDGE.MOTOR_VW

Image Added

Asof View

This view is basically the same as the Intermediate view - each model instance tag is separated out into its own column. However, each row in this view has the null values from the Intermediate views removed (unless the tag change really had a null value) and the last known good value for the model instance tag will be replicated in its column. Said another way, each row will have the last known good values for all model instance tags.

• Example: CL_BRIDGE_NODE_DB.NB_GROUPG1_EDGEE1.MOTOR_ASOF_VW

Image Added