Senseforce 2.0 Manual
  • Welcome to Senseforce 2.0
  • SF MQTT API
  • SF Edge
    • Edge Package Overview
    • Edge Installation
      • Using the SF Edge Service installer in command shell
      • Headless SF Edge Servie execution
    • Edge Configuration
      • Which Plugins to load (appsettings.xml)
      • Edge Data Routing (EventDefinition.xml)
      • OTA configuration (otasettings.xml)
      • Edge Logging
      • Input plugins
        • SQL Plugin
        • SQLite Plugin
        • OPC UA Plugin
          • OPC UA server browser
        • SIEMENS S7/SINUMERIK Plugin
          • Creating connection definition file
        • S7 Plugin
        • REST Plugin
        • TCP Listener Plugin
        • XML File Parsing Plugin
        • Heidenhain Plugin
      • Output Plugins
        • MQTT Plugin
        • SQLite Plugin
    • Edge Compute plugins
      • Creating compute plugins
      • Using compute plugins
  • SF Edge Asset Management
    • Edge version repository
  • SF Platform
    • Navigation
      • Overview Screen
    • Dataset Builder
      • Filters, Aggregations and Groupings
      • Functions of the Formula Editor
      • Additional Settings
      • Special Events
      • FAQ and Troubleshooting
    • Script Editor
      • Details of the Script Editor
      • Installed Packages
      • Working with Timestamps
        • Working with Timestamps in Python
        • Working with Timestamps in R
      • FAQ and Troubleshooting
    • Widgets
      • Text
      • Headline
      • Image
      • Progress Bar & Gauge Chart
      • Table
      • Map
      • Line, Bar, Scatter and Area Chart
      • Pie Chart
      • Gantt Chart
      • Histogram
      • Overview
      • Log
      • Default colors and color conditions
      • FAQ and Troubleshooting
    • Dashboards
      • Dashboard Filters
      • Favorites
      • Data Drilldown & Widget Interaction
      • Editing multiple dashboard widgets
      • Time Zones
      • Synchronized Zooming
      • Sharable Dashboard URL
      • Multi-chart layout options
      • Default sort for table widgets
      • Releases
      • Reporting
      • FAQ and Troubleshooting
      • Applying zoom to global timestamp filter
      • Optimise the layout for different devices
    • Machine Master Data
      • Dimensions
      • Instances
      • Things
      • Use Case
      • FAQ and Troubleshooting
    • Automation
      • Trigger
      • Scheduling overview
      • Actions
      • Test your Automation
      • Zapier integration (necessary internal steps)
      • Zapier integration
      • Subscriptions
      • FAQ and Troubleshooting
    • Event Schema Management
      • Importing a Event Schema
      • FAQ and Troubleshooting
    • Virtual Events
      • Creating a Virtual Event
      • Scheduling Overview
      • Permissions and Data Access
      • FAQ and Troubleshooting
    • Details modal for elements
    • Copy / Duplicate elements
    • Whitelabeling
    • Edge Device Management
    • Element History
    • Public API
      • Get your access token
      • Endpoints
      • Debugging scripts
      • FAQ and Troubleshooting
    • User & Group Management
      • FAQ and Troubleshooting
    • Active Directory & SSO Setup
Powered by GitBook
On this page
  • Metadata
  • Senseforce client state
  • Senseforce messages

Was this helpful?

  1. SF Platform
  2. Dataset Builder

Special Events

Metadata

The metadata consists of the columns

  • Id, is the id of the MQTT message in which the event was transmitted

  • Inserted, the time it was inserted into the database

  • Size, data size of the event

  • Thing, id or name of the machine which generated the data

  • Timestamp, timestamp describing the event

  • Type, name/type of the event

These columns are contained in every event schema and are used to connect the different event schemas. The metadata events contain the collective of all metadata regardless of the event schema they actually belong to.

Senseforce client state

The SF client state events contain information about the state of the edge component.

  • Reason, this attribute isn't used at the moment.

  • State, shows the status changes (connected/disconnected) of the according to SF edge.

  • Status code, shows some information as State but in binary format (1/0).

Senseforce messages

The SF message events contain information about the data included in the messages which were sent by the edge component.

  • Inserted events, is the number of events that where included in the message with the given Id and inserted into the database. Each event is stored in a single row in the database.

  • Rejected events, is the number of events that where included in the message with the given Id and rejected because of a violation against the event schema definition.

  • Compressed size, is the size of the compressed message given in bytes.

  • Uncompressed size, is the size of the uncompressed message given in bytes.

  • Compression ratio, is the ratio between uncompressed and compressed size given by compression_ratio=compressed_size/uncompressed_sizecompression\_ratio = compressed\_size/uncompressed\_size compression_ratio=compressed_size/uncompressed_size

  • Space savings, is the data amount saved due to the compression. space_savings=1−uncompressed_size/compressed_sizespace\_savings = 1-uncompressed\_size/compressed\_sizespace_savings=1−uncompressed_size/compressed_size

PreviousAdditional SettingsNextFAQ and Troubleshooting

Last updated 3 years ago

Was this helpful?