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

Docs/DB schema/3.4/actions

From Zabbix.org
Jump to: navigation, search

This table contains actions - notification and remedy rules.

Columns

Column Detail Default NULL? Type Ref from Ref to
actionid Action ID. Managed by Zabbix via the ids table. NONE NOT NULL id alerts.actionid C
conditions.actionid C
escalations.actionid
operations.actionid C
name Action name. EMPTY NOT NULL varchar(255)
eventsource Type of events that this action will match.
  • 0 - EVENT_SOURCE_TRIGGERS
  • 1 - EVENT_SOURCE_DISCOVERY
  • 2 - EVENT_SOURCE_AUTO_REGISTRATION
  • 3 - EVENT_SOURCE_INTERNAL
0 NOT NULL integer
evaltype Condition evaluation type.
  • 0 - CONDITION_EVAL_TYPE_AND_OR
  • 1 - CONDITION_EVAL_TYPE_AND
  • 2 - CONDITION_EVAL_TYPE_OR
  • 3 - CONDITION_EVAL_TYPE_EXPRESSION
0 NOT NULL integer
status Whether the action is enabled.
  • 0 - ACTION_STATUS_ENABLED
  • 1 - ACTION_STATUS_DISABLED
0 NOT NULL integer
esc_period The period between escalation steps. 1h NOT NULL varchar(255)
def_shortdata Message subject. EMPTY NOT NULL varchar(255)
def_longdata Message body. EMPTY NOT NULL shorttext
r_shortdata Recovery message subject. EMPTY NOT NULL varchar(255)
r_longdata Recovery message body. EMPTY NOT NULL shorttext
formula Condition evaluation formula.

Used when evaltype = CONDITION_EVAL_TYPE_EXPRESSION.

EMPTY NOT NULL varchar(255)
maintenance_mode Whether to pause escalation during maintenance.
  • 0 - ACTION_MAINTENANCE_MODE_NORMAL
  • 1 - ACTION_MAINTENANCE_MODE_PAUSE

Renamed to "pause_suppressed" in 4.0.

1 NOT NULL integer
ack_shortdata Acknowledgement message subject. EMPTY NOT NULL varchar(255)
ack_longdata Acknowledgement message body. EMPTY NOT NULL shorttext

Indexes

Name UNIQ Columns
PRIMARY KEY YES actionid
actions_1 No eventsource, status
actions_2 YES name