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

Docs/DB schema/4.0/host inventory

From Zabbix.org

< Docs/DB schema‎ | 4.0

Jump to: navigation, search

host_inventory
2.0 \| 2.2 \| 2.4 \| 3.0 \| 3.2 \| 3.4 \| 4.0 \| trunk
A
acknowledges actions alerts application_discovery [] application_prototype [] application_template [*] applications auditlog auditlog_details autoreg_host
C
conditions config corr_condition [] corr_condition_group [] corr_condition_tag [] corr_condition_tagpair [] corr_condition_tagvalue [] corr_operation [] correlation [*]
D
dashboard [] dashboard_user [] dashboard_usrgrp [] dbversion [] dchecks dhosts drules dservices
E
escalations event_recovery [] event_suppress [] event_tag [*] events expressions
F
functions
G
globalmacro globalvars graph_discovery graph_theme graphs graphs_items group_discovery [] group_prototype []
H
history history_log history_str history_text history_uint host_discovery [] host_inventory* hostmacro hosts hosts_groups hosts_templates housekeeper hstgrp [] httpstep httpstep_field [] httpstepitem httptest httptest_field [*] httptestitem
I
icon_map icon_mapping ids images interface interface_discovery [] item_application_prototype [] item_condition [] item_discovery item_preproc [] items items_applications
M
maintenance_tag [*] maintenances maintenances_groups maintenances_hosts maintenances_windows mappings media media_type
O
opcommand opcommand_grp opcommand_hst opconditions operations opgroup opinventory [*] opmessage opmessage_grp opmessage_usr optemplate
P
problem [] problem_tag [] profiles proxy_autoreg_host proxy_dhistory proxy_history
R
regexps rights
S
screen_user [] screen_usrgrp [] screens screens_items scripts service_alarms services services_links services_times sessions slides slideshow_user [] slideshow_usrgrp [] slideshows sysmap_element_trigger [] sysmap_element_url sysmap_shape [] sysmap_url sysmap_user [] sysmap_usrgrp [] sysmaps sysmaps_elements sysmaps_link_triggers sysmaps_links
T
tag_filter [] task [] task_acknowledge [] task_check_now [] task_close_problem [] task_remote_command [] task_remote_command_result [] timeperiods trends trends_uint trigger_depends trigger_discovery trigger_tag [] triggers
U
users users_groups usrgrp
V
valuemaps
W
widget [] widget_field []

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

Retrieved from "https://zabbix.org/mw/index.php?title=Docs/DB_schema/4.0/host_inventory&oldid=14663"