See www.zabbix.com for the official Zabbix site.
Docs/DB schema/4.0/host inventory
From Zabbix.org
< Docs/DB schema | 4.0
This table contains [please add a brief table description].
Columns
Column | Detail | Default | NULL? | Type | Ref from | Ref to |
---|---|---|---|---|---|---|
hostid | NONE | NOT NULL | id | hosts.hostid C |
||
inventory_mode | 0 | NOT NULL | integer | |||
type | EMPTY | NOT NULL | varchar(64) | |||
type_full | EMPTY | NOT NULL | varchar(64) | |||
name | EMPTY | NOT NULL | varchar(64) | |||
alias | EMPTY | NOT NULL | varchar(64) | |||
os | EMPTY | NOT NULL | varchar(64) | |||
os_full | EMPTY | NOT NULL | varchar(255) | |||
os_short | EMPTY | NOT NULL | varchar(64) | |||
serialno_a | EMPTY | NOT NULL | varchar(64) | |||
serialno_b | EMPTY | NOT NULL | varchar(64) | |||
tag | EMPTY | NOT NULL | varchar(64) | |||
asset_tag | EMPTY | NOT NULL | varchar(64) | |||
macaddress_a | EMPTY | NOT NULL | varchar(64) | |||
macaddress_b | EMPTY | NOT NULL | varchar(64) | |||
hardware | EMPTY | NOT NULL | varchar(255) | |||
hardware_full | EMPTY | NOT NULL | shorttext | |||
software | EMPTY | NOT NULL | varchar(255) | |||
software_full | EMPTY | NOT NULL | shorttext | |||
software_app_a | EMPTY | NOT NULL | varchar(64) | |||
software_app_b | EMPTY | NOT NULL | varchar(64) | |||
software_app_c | EMPTY | NOT NULL | varchar(64) | |||
software_app_d | EMPTY | NOT NULL | varchar(64) | |||
software_app_e | EMPTY | NOT NULL | varchar(64) | |||
contact | EMPTY | NOT NULL | shorttext | |||
location | EMPTY | NOT NULL | shorttext | |||
location_lat | EMPTY | NOT NULL | varchar(16) | |||
location_lon | EMPTY | NOT NULL | varchar(16) | |||
notes | EMPTY | NOT NULL | shorttext | |||
chassis | EMPTY | NOT NULL | varchar(64) | |||
model | EMPTY | NOT NULL | varchar(64) | |||
hw_arch | EMPTY | NOT NULL | varchar(32) | |||
vendor | EMPTY | NOT NULL | varchar(64) | |||
contract_number | EMPTY | NOT NULL | varchar(64) | |||
installer_name | EMPTY | NOT NULL | varchar(64) | |||
deployment_status | EMPTY | NOT NULL | varchar(64) | |||
url_a | EMPTY | NOT NULL | varchar(255) | |||
url_b | EMPTY | NOT NULL | varchar(255) | |||
url_c | EMPTY | NOT NULL | varchar(255) | |||
host_networks | EMPTY | NOT NULL | shorttext | |||
host_netmask | EMPTY | NOT NULL | varchar(39) | |||
host_router | EMPTY | NOT NULL | varchar(39) | |||
oob_ip | EMPTY | NOT NULL | varchar(39) | |||
oob_netmask | EMPTY | NOT NULL | varchar(39) | |||
oob_router | EMPTY | NOT NULL | varchar(39) | |||
date_hw_purchase | EMPTY | NOT NULL | varchar(64) | |||
date_hw_install | EMPTY | NOT NULL | varchar(64) | |||
date_hw_expiry | EMPTY | NOT NULL | varchar(64) | |||
date_hw_decomm | EMPTY | NOT NULL | varchar(64) | |||
site_address_a | EMPTY | NOT NULL | varchar(128) | |||
site_address_b | EMPTY | NOT NULL | varchar(128) | |||
site_address_c | EMPTY | NOT NULL | varchar(128) | |||
site_city | EMPTY | NOT NULL | varchar(128) | |||
site_state | EMPTY | NOT NULL | varchar(64) | |||
site_country | EMPTY | NOT NULL | varchar(64) | |||
site_zip | EMPTY | NOT NULL | varchar(64) | |||
site_rack | EMPTY | NOT NULL | varchar(128) | |||
site_notes | EMPTY | NOT NULL | shorttext | |||
poc_1_name | EMPTY | NOT NULL | varchar(128) | |||
poc_1_email | EMPTY | NOT NULL | varchar(128) | |||
poc_1_phone_a | EMPTY | NOT NULL | varchar(64) | |||
poc_1_phone_b | EMPTY | NOT NULL | varchar(64) | |||
poc_1_cell | EMPTY | NOT NULL | varchar(64) | |||
poc_1_screen | EMPTY | NOT NULL | varchar(64) | |||
poc_1_notes | EMPTY | NOT NULL | shorttext | |||
poc_2_name | EMPTY | NOT NULL | varchar(128) | |||
poc_2_email | EMPTY | NOT NULL | varchar(128) | |||
poc_2_phone_a | EMPTY | NOT NULL | varchar(64) | |||
poc_2_phone_b | EMPTY | NOT NULL | varchar(64) | |||
poc_2_cell | EMPTY | NOT NULL | varchar(64) | |||
poc_2_screen | EMPTY | NOT NULL | varchar(64) | |||
poc_2_notes | EMPTY | NOT NULL | shorttext |
Indexes
Name | UNIQ | Columns |
---|---|---|
PRIMARY KEY | YES | hostid |