Custom Event Writers

Custom Event Writers is a global server configuration property that configures which events will be stored in custom destinations, such as database or CSV files, in addition to the normal event history.

Format of the Custom Event Writers table:

Writer Type

Type of custom writer. Currently, two types are supported: database and CSV file.

Name

Name of the writer. Use of the name depends on writer type, e.g. it is the database name for the database writer or file name (without extension) for the CSV file writer.

Context Mask

Mask of contexts to watch for the event to be written into custom storage.

Event Name

Name of the event to store.

Database Event Writer

Normally, Iotellect Server stores historical events in database in its own custom format. The events table (it's called ag_events) is fully managed by the server and should not be accessed by third party applications.

Database event writes provides a method for storing selected events into a dedicated table. This table has several differences from the normal events storage:

  • Events are added to this table once they occur. Iotellect Server does not attempt to delete expired events from this table. No other modifications of existing events are performed.
  • Server creates a dedicated table column for every field described in event format.

Any third-party applications may execute selection of modification queries over this table to get access to Iotellect Server events. It's possible to access this table even during Iotellect Server operation.

Custom events table structure:

Field

Type

Comments

ag_id

Long (bigint)

Event ID

ag_datetime

Timestamp (datetime)

Event timestamp

ag_context

String (varchar)

Event context

ag_event

String (varchar)

Event name

ag_level

Integer (int)

Event level (numeric value)

ev_*

Different type

Custom event-specific fields

CSV Event Writer

This event writer appends selected events to a Character-Separated Values (CSV) file. This is a simple text file that may be parsed by any application.

CSV file fields:

  • Event ID
  • Event timestamp (formatted according to yyyy-MM-dd HH:mm:ss.SSS pattern)
  • Event context
  • Event name
  • Event level (numeric value)
  • Custom event-specific fields

Was this page helpful?