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

Docs/DB schema/3.4/conditions

From Zabbix.org
Jump to: navigation, search

This table contains action conditions for all types of actions. Not all actions have conditions!

Columns

Column Detail Default NULL? Type Ref from Ref to
conditionid Id of this condition NONE NOT NULL id
actionid Id of the action this condition belongs to NONE NOT NULL id actions.actionid C
conditiontype Action condition type; The types are action-type-specific.
  • 0 - CONDITION_TYPE_HOST_GROUP
  • 1 - CONDITION_TYPE_HOST
  • 2 - CONDITION_TYPE_TRIGGER
  • 3 - CONDITION_TYPE_TRIGGER_NAME
  • 4 - CONDITION_TYPE_TRIGGER_SEVERITY
  • 6 - CONDITION_TYPE_TIME_PERIOD
  • 7 - CONDITION_TYPE_DHOST_IP
  • 8 - CONDITION_TYPE_DSERVICE_TYPE
  • 9 - CONDITION_TYPE_DSERVICE_PORT
  • 10 - CONDITION_TYPE_DSTATUS
  • 11 - CONDITION_TYPE_DUPTIME
  • 12 - CONDITION_TYPE_DVALUE
  • 13 - CONDITION_TYPE_TEMPLATE
  • 14 - CONDITION_TYPE_EVENT_ACKNOWLEDGED
  • 15 - CONDITION_TYPE_APPLICATION
  • 16 - CONDITION_TYPE_MAINTENANCE
  • 18 - CONDITION_TYPE_DRULE
  • 19 - CONDITION_TYPE_DCHECK
  • 20 - CONDITION_TYPE_PROXY
  • 21 - CONDITION_TYPE_DOBJECT
  • 22 - CONDITION_TYPE_HOST_NAME
  • 23 - CONDITION_TYPE_EVENT_TYPE
  • 24 - CONDITION_TYPE_HOST_METADATA
  • 25 - CONDITION_TYPE_EVENT_TAG
  • 26 - CONDITION_TYPE_EVENT_TAG_VALUE
0 NOT NULL integer
operator Action condition operator
  • 0 - CONDITION_OPERATOR_EQUAL
  • 1 - CONDITION_OPERATOR_NOT_EQUAL
  • 2 - CONDITION_OPERATOR_LIKE
  • 3 - CONDITION_OPERATOR_NOT_LIKE
  • 4 - CONDITION_OPERATOR_IN
  • 5 - CONDITION_OPERATOR_MORE_EQUAL
  • 6 - CONDITION_OPERATOR_LESS_EQUAL
  • 7 - CONDITION_OPERATOR_NOT_IN
  • 8 - CONDITION_OPERATOR_REGEXP
0 NOT NULL integer
value EMPTY NOT NULL varchar(255)
value2 EMPTY NOT NULL varchar(255)

Indexes

Name UNIQ Columns
PRIMARY KEY YES conditionid
conditions_1 No actionid