Agent event table

The agent event table is used to efficiently store agent events in the database, both before and after they are sent to the upstream system. The fields are:

  • Local Agent ID. This is the value from the agent registration table and IDs which agent owns the data. This is handled by the API and is transparent to the agent.

  • Event ID. Agent-specific event identifier.

  • Feature ID . This value should be the ID of the feature to which this data is tied. This is a unique ID assigned by Itron.

  • Timestamp. Can either be provided by the API caller or populated by default by the API itself. If left up to the API, the current wall time will be used.

  • Data. This field stores blobs, so it can be used to store any type of data generically. This data would be presumed to be correlated with the event ID that has been logged.

  • isUnsentAlarm. Identifies whether this event is an alarm, and if so, whether it has been communicated to the head end system yet.

  • oneShotAlarm. If set then this alarm is sent immediately in near real-time and is not stored for later interrogation. Note that the previous isUnsentAlarm is sent in near real-time but also sent again on later interrogation.

The API will recognize the Local Agent ID when the agent starts and hold it, using it when accessing the agent event table.

Note: Only writes to this table are permitted through the API.

Reading this table will be done by the system, when sending up data to the upstream system.