See www.zabbix.com for the official Zabbix site.

Docs/DB schema/3.4/events

From Zabbix.org
Jump to: navigation, search

This table contains events - timestamped occurrences of entity state change. Triggers firing and resolving is the most common event source.

Columns

Column Detail Default NULL? Type Ref from Ref to
eventid Event ID. Managed by Zabbix via the ids table. NONE NOT NULL id acknowledges.eventid C
alerts.eventid C
alerts.p_eventid C
escalations.eventid
escalations.r_eventid
event_recovery.c_eventid C
event_recovery.eventid C
event_recovery.r_eventid C
event_tag.eventid C
problem.eventid C
problem.r_eventid C
source Entity type that resulted in this event.
  • 0 - EVENT_SOURCE_TRIGGERS
  • 1 - EVENT_SOURCE_DISCOVERY
  • 2 - EVENT_SOURCE_AUTO_REGISTRATION
  • 3 - EVENT_SOURCE_INTERNAL
0 NOT NULL integer
object Type of the object that caused this event.
  • 0 - EVENT_OBJECT_TRIGGER
  • 1 - EVENT_OBJECT_DHOST
  • 2 - EVENT_OBJECT_DSERVICE
  • 3 - EVENT_OBJECT_AUTOREGHOST
  • 4 - EVENT_OBJECT_ITEM
  • 5 - EVENT_OBJECT_LLDRULE
0 NOT NULL integer
objectid ID of the object that caused this event. 0 NOT NULL id
clock UNIX timestamp of the event. 0 NOT NULL time
value Event value, depending on the source and object. 0 NOT NULL integer
acknowledged Is this event acknowledged?
  • 0 - EVENT_NOT_ACKNOWLEDGED
  • 1 - EVENT_ACKNOWLEDGED
0 NOT NULL integer
ns Nanosecond part of the event timestamp. 0 NOT NULL nanosec

Indexes

Name UNIQ Columns
PRIMARY KEY YES eventid
events_1 No source, object, objectid, clock
events_2 No source, object, clock