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

Docs/DB schema/3.4/hosts inline

From Zabbix.org
Jump to: navigation, search

This table contains hosts, host prototypes, templates and proxies.

Columns

Column Detail Default NULL? Type Ref from Ref to
hostid Entity ID. Managed by Zabbix via the ids table. NONE NOT NULL id applications.hostid C
autoreg_host.proxy_hostid C
drules.proxy_hostid
group_prototype.hostid C
host_discovery.hostid C
host_discovery.parent_hostid
host_inventory.hostid C
hostmacro.hostid C
hosts.proxy_hostid
hosts.templateid C
hosts_groups.hostid C
hosts_templates.hostid C
hosts_templates.templateid C
httptest.hostid C
interface.hostid C
items.hostid C
maintenances_hosts.hostid C
opcommand_hst.hostid
optemplate.templateid
screens.templateid C
task.proxy_hostid C
task_remote_command.hostid
widget_field.value_hostid C
proxy_hostid "Host ID" of a proxy if a host is monitored by one.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • NULL - host monitored by Zabbix server
  • ID - host monitored by this proxy; can be IN (HOST_STATUS_PROXY_ACTIVE, HOST_STATUS_PROXY_PASSIVE).
NONE NULL id hosts.hostid
host Entity name. Unique host/template/proxy identifier. EMPTY NOT NULL varchar(128)
status Entity type and/or status.
  • 0 - HOST_STATUS_MONITORED
  • 1 - HOST_STATUS_NOT_MONITORED
  • 3 - HOST_STATUS_TEMPLATE
  • 5 - HOST_STATUS_PROXY_ACTIVE
  • 6 - HOST_STATUS_PROXY_PASSIVE
0 NOT NULL integer
disable_until Unix timestamp before which Zabbix agent items should not be checked.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
error Last error message from Zabbix agent.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

EMPTY NOT NULL varchar(2048)
available Availability of Zabbix agent.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • 0 - HOST_AVAILABLE_UNKNOWN
  • 1 - HOST_AVAILABLE_TRUE (available)
  • 2 - HOST_AVAILABLE_FALSE (unavailable)
0 NOT NULL integer
errors_from Unix timestamp of the first Zabbix agent error.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
lastaccess Unix timestamp of the most recent successful communication with a Zabbix proxy (active or passive).

Used when status IN (HOST_STATUS_PROXY_ACTIVE, HOST_STATUS_PROXY_PASSIVE).

0 NOT NULL integer
ipmi_authtype IPMI authentication type.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • -1 - IPMI_AUTHTYPE_DEFAULT
  • 0 - IPMI_AUTHTYPE_NONE
  • 1 - IPMI_AUTHTYPE_MD2
  • 2 - IPMI_AUTHTYPE_MD5
  • 4 - IPMI_AUTHTYPE_STRAIGHT
  • 5 - IPMI_AUTHTYPE_OEM
  • 6 - IPMI_AUTHTYPE_RMCP_PLUS
-1 NOT NULL integer
ipmi_privilege IPMI privilege level.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • 1 - IPMI_PRIVILEGE_CALLBACK
  • 2 - IPMI_PRIVILEGE_USER
  • 3 - IPMI_PRIVILEGE_OPERATOR
  • 4 - IPMI_PRIVILEGE_ADMIN
  • 5 - IPMI_PRIVILEGE_OEM
2 NOT NULL integer
ipmi_username IPMI username.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

EMPTY NOT NULL varchar(16)
ipmi_password IPMI password.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

EMPTY NOT NULL varchar(20)
ipmi_disable_until Unix timestamp before which IPMI items should not be checked.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
ipmi_available IPMI availability.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • 0 - HOST_AVAILABLE_UNKNOWN
  • 1 - HOST_AVAILABLE_TRUE (available)
  • 2 - HOST_AVAILABLE_FALSE (unavailable)
0 NOT NULL integer
snmp_disable_until Unix timestamp before which SNMP items should not be checked.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
snmp_available SNMP availability.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • 0 - HOST_AVAILABLE_UNKNOWN
  • 1 - HOST_AVAILABLE_TRUE (available)
  • 2 - HOST_AVAILABLE_FALSE (unavailable)
0 NOT NULL integer
maintenanceid Maintenance ID, affecting this host.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED) AND maintenance_status = HOST_MAINTENANCE_STATUS_ON.

NONE NULL id maintenances.maintenanceid
maintenance_status Maintenance status.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • 0 - HOST_MAINTENANCE_STATUS_OFF
  • 1 - HOST_MAINTENANCE_STATUS_ON
0 NOT NULL integer
maintenance_type Maintenance type.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • 0 - MAINTENANCE_TYPE_NORMAL
  • 1 - MAINTENANCE_TYPE_NODATA
0 NOT NULL integer
maintenance_from Unix timestamp when the currently active maintenance started.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
ipmi_errors_from Unix timestamp of the first IPMI error.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
snmp_errors_from Unix timestamp of the first SNMP error.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
ipmi_error Last error message from IPMI.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

EMPTY NOT NULL varchar(2048)
snmp_error Last error message from SNMP.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

EMPTY NOT NULL varchar(2048)
jmx_disable_until Unix timestamp before which JMX items should not be checked.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
jmx_available JMX availability.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • 0 - HOST_AVAILABLE_UNKNOWN
  • 1 - HOST_AVAILABLE_TRUE (available)
  • 2 - HOST_AVAILABLE_FALSE (unavailable)
0 NOT NULL integer
jmx_errors_from Unix timestamp of the first JMX error.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

0 NOT NULL integer
jmx_error Last error message from JMX.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

EMPTY NOT NULL varchar(2048)
name Visible name. If set to the same value as host, the field is empty in the Zabbix frontend.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED, HOST_STATUS_TEMPLATE).

EMPTY NOT NULL varchar(128)
flags Entity flags - currently used for discovery status.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED).

  • 0x0 - ZBX_FLAG_DISCOVERY_NORMAL (normal host)
  • 0x2 - ZBX_FLAG_DISCOVERY_PROTOTYPE (host prototype)
  • 0x4 - ZBX_FLAG_DISCOVERY_CREATED (host, created by host LLD)
0 NOT NULL integer
templateid ID of the host prototype that this host was created from for host LLD created hosts.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED) AND flags = ZBX_FLAG_DISCOVERY_CREATED.

NONE NULL id hosts.hostid C
description Entity description. EMPTY NOT NULL shorttext
tls_connect Which connection method to use when connecting to this agent or proxy.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED, HOST_STATUS_PROXY_ACTIVE, HOST_STATUS_PROXY_PASSIVE).

  • 1 - HOST_ENCRYPTION_NONE
  • 2 - HOST_ENCRYPTION_PSK
  • 4 - HOST_ENCRYPTION_CERTIFICATE
1 NOT NULL integer
tls_accept Bitwise value of connection methods accepted from this host or proxy. For example, accepting PSK and certificates (but not unencrypted) would have 6 stored - obtained as 2+4.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED, HOST_STATUS_PROXY_ACTIVE, HOST_STATUS_PROXY_PASSIVE).

  • 1 - HOST_ENCRYPTION_NONE
  • 2 - HOST_ENCRYPTION_PSK
  • 4 - HOST_ENCRYPTION_CERTIFICATE
1 NOT NULL integer
tls_issuer Acceptable TLS issuer when using certificate based encryption.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED, HOST_STATUS_PROXY_ACTIVE, HOST_STATUS_PROXY_PASSIVE).

EMPTY NOT NULL varchar(1024)
tls_subject Acceptable TLS subject when using certificate based encryption.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED, HOST_STATUS_PROXY_ACTIVE, HOST_STATUS_PROXY_PASSIVE).

EMPTY NOT NULL varchar(1024)
tls_psk_identity PSK identity when using PSK based encryption.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED, HOST_STATUS_PROXY_ACTIVE, HOST_STATUS_PROXY_PASSIVE).

EMPTY NOT NULL varchar(128)
tls_psk PSK (the key itself) when using PSK based encryption.

Used when status IN (HOST_STATUS_MONITORED, HOST_STATUS_NOT_MONITORED, HOST_STATUS_PROXY_ACTIVE, HOST_STATUS_PROXY_PASSIVE).

EMPTY NOT NULL varchar(512)

Indexes

Name UNIQ Columns
PRIMARY KEY YES hostid
hosts_1 No host
hosts_2 No status
hosts_3 No proxy_hostid
hosts_4 No name
hosts_5 No maintenanceid