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

Docs/DB schema/2.2/host inventory

From Zabbix.org
Jump to: navigation, search

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