Contact Us  |  Site Map  |  Customer Login  Home|Product|Support|Services|Training|Partners|Download|Documentation|Forum|Community|About Us|
	Product / Documentation / Internals /
Internals  Database structure  Processing of timeouts	Database structure Database structure The section describes structure of tables of ZABBIX database. ACTIONS The table contains list of actions to be applied if a trigger changes its state. Column name Type Description actionid int Unique action ID triggerid int Trigger ID scope int Scope of the actions: 0 - this trigger only 1 - hosts of the trigger 2 - all hosts severity int Apply action if and only if trigger severity is equal or more than this value. Works for scope equal to 1 or 2. recipient int Who gets this action: 0 - User 1 - User group userid int If recipient==0, then User ID If recipient==1, then User Group ID good int   subject varchar Subject of the message message varchar The message itself nextcheck int Time when the message should be sent next time. Number of second since 01/01/1970. scope int Scope of this actions: 0 - this trigger 1 - all triggers of this host(s) 2 - all triggers of all hosts severity int Perform action if severity of the trigger more or equal to this value. Ignored if ‘scope’=0. ALARMS This table contains history of changes of trigger states. When a trigger changes its state, new record is added to the table. Column name Type Description triggerid int Trigger ID clock int Time when trigger changed its status. Number of second since 01/01/1970. value int Value of the alarm: 0 - trigger became FALSE 1 - trigger became TRUE 2 - trigger became UNKNOWN ALERTS This table contains history of alerts sent to users. Column name Type Description alertid int Unique alert ID actionid int Action ID that generated this alert mediatypeid int ID of media type clock int Time when this alert was generated. Number of second since 01/01/1970. type varchar Type of alert: EMAIL – email based alert sendto varchar Recipient(s). In case of EMAIL, this specifies email address. subject varchar In case of email, specifies subject of the email. message blob Message status int 0 - not sent 1 - successfully sent retries int Number of retries. zabbix_server will not send message if the value is more than 2. Increased after unsuccessful try. AUDIT The table contains global configuration parameters. Column name Type Description auditid int Unique record ID userid int User ID who made an action clock int Timestamp action int 0 - added 1 - updated 2 - deleted 3 - login 4 - logout resource int Affected resource: 0 - User 1 - ZABBIX 2 - Config 3 - Media type 4 - Host 5 - Action 6 - Graph details varchar Free text CONFIG The table contains global configuration parameters. Column name Type Description alarm_history int ZABBIX will delete records in table alarms older than this value (in days) alert_history int ZABBIX will delete record in table alerts older than this value (in days) FUNCTIONS The table contains list of simple functions used in trigger expressions. Column name Type Description functionid int Unique function ID itemid int Item ID triggerid int Trigger ID lastvalue double Last (most recent) value function varchar Function name: LAST MIN MAX PREV DIFF STR AVG COUNT SUM DELTA CHANGE ABSCHANGE parameter int Parameter to the function. Ignored if function does not need any parameters GRAPHS The table contains list of user-defined graphs (charts). Column name Type Description graphid int Unique graph ID name varchar Name of the graph width int Graph width height int Graph height yaxistype int 0 - Min/Max Y autocalculated 1 - fixed Min/Max Y yaxismin int Fixed Min Y yaxismax int Fixed Max Y GRAPHS_ITEMS The table contains list of monitored items belonging to graph. Column name Type Description gitemid int Unique ID graphid int Graph ID itemid int Item ID sort_order int Sort order (0-100). 0 - draw first, 100 - draw last. drawtype int Draw type: 0 - Line 1 - Filled 2 - Bold line 3 - Dot color int Color GROUPS The table contains list of host groups. Column name Type Description groupid int Unique ID name varchar Name of the group HISTORY This table contains history of integer values of items. Column name Type Description itemid int Item ID clock int Timestamp. Number of second since 01/01/1970. value double Value of the item HISTORY_STR This table contains history of string values of items. Column name Type Description itemid int Item ID clock int Timestamp. Number of second since 01/01/1970. value varchar Value of the item HOSTS The table contains list of monitored Hosts. Column name Type Description hostid int Unique host ID host varchar Host name or IP address status int Host status: 0 - monitored 1 - not monitored 3 - template 4 - deleted (housekeeping process will delete this host) available int Host availability: 0 - available 1 - not available disable_until int In case if status is unreachable, do not check host and its items until this time. Number of second since 01/01/1970. HOSTS_GROUPS The table is used to define linkage between hosts and host groups. Column name Type Description hostid int Host ID groupid int Group ID HOSTS_TEMPLATES The table is used to define hard-linkage between hosts and templates. Column name Type Description hosttemplateid int Unique ID hostid int Hostid ID templateid int Host templateid ID items int 0 - do not sync items 1 - sync items triggers int 0 - do not sync triggers 1 - sync triggers actions int 0 - do not sync actions 1 - sync actions graphs int 0 - do not sync graphs 1 - sync graphs screens int 0 - do not sync screens 1 - sync screens IMAGES The table is used to store various images. Column name Type Description imageid int Image ID imagetype int Image type: 1 - icon 2 - background image name int Unique (for a give type) image name image blob Raw image data, usually in PNG or JPG format ITEMS This table contains definitions of monitored items. Column name Type Description itemid int Unique item ID type int Type of the item: 0 - ZABBIX agent 1 - SNMPv1 2 - Trapper 3 - Simple check 4 - SNMPv2 5 - Internal 6 - SNMPv3 7 - Active check value_type int Type of received values: 0 - float 1 - string snmp_community varchar Name of community for SNMP request. Example: public snmp_oid varchar Object ID for SNMP request hostid int Host ID description varchar Description of the item key_ varchar Key to be sent to monitored host delay int Update interval. Defines how often retrieve this item (in sec) history int Do not store more than history days of history data. Used by housekeeping process. lastdelete int Time of last deletion from table history nextcheck int Time when next value should be retrieved. Number of second since 01/01/1970. lastvalue double Last value retrieved from host. For items having delta==1, this field contains modified value. lastclock int Time when last value was retrieved. Number of second since 01/01/1970. prevorgvalue double Previous retrieved value (used for items having delta==1) prevvalue double Previous retrieved value. For items having delta==1, this field contains modified value. trapper_hosts varchar Comma-delimited list of IP addresses of hosts allowed sending data of the item. For item type Trapper only. status int Status of the item: 0 - active 1 - disabled 3 - not supported by agent 4 - deleted (housekeeping process will delete this item) units varchar Units of returned values. Can be empty. For example: bps, B multiplier int Multiplier for units. If agent returns KB, then multiplier must be 1, i.e. 1024^1. delta int 0 - normal processing, keep received value without any modifications 1 - calculate (received - previous value)/(now-time of last check) and store it in the history. For numeric values only. 2 - difference between most recent and previous values formula varchar Formula for calculation of received values. Currently it used as a multiplier only. snmpv3_securityname varchar SNMPv3 only. Security name. snmpv3_securitylevel varchar SNMPv3 only. Security level. snmpv3_authpassphrase varchar SNMPv3 only. Passphrase. snmpv3_privpassphrase varchar SNMPv3 only. Pivate passphrase. trends int Do not store more than trends days of trend data. Used by housekeeping process. MEDIA This table contains list of available medias for given user. Column name Type Description mediaid int Unique media ID userid int User ID mediatypeid int Media type ID sendto varchar Address to send alert to active int Status of the media: 0 - active 1 - disabled severity int Bit: 0 - Not classified (1) 1 - Information (2) 2 - Warning (4) 3 - Average (8) 4 - High (16) 5 - Disaster (32) MEDIA_TYPE This table contains list of available medias for given user. Column name Type Description mediatypeid int Unique media type ID type int Type: 0 - EMAIL 1 - external script description varchar Description of the media type smtp_server varchar SMTP server. For ‘type’=0 only. smtp_helo varchar HELO value for SMTP server. For ‘type’=0 only. smtp_email varchar Email address of ZABBIX server. For ‘type’=0 only. exec_path varchar Name of an external script. Example: lmt.sh PROFILES This table contains user settings. Column name Type Description profileid int Unique profile ID userid int User ID idx varchar Index for searching value varchar Information for this index RIGHTS The table contains list of user permissions. Column name Type Description rightid int Unique ID userid int User ID name varchar Resource name permission char Permission: R - read only U - read and write A - add H - restrict access (hide) id int Resource ID SCREENS The table contains list of user-defined screens. Column name Type Description screenid int Unique screen ID name varchar Screen name cols int Number of screen columns rows int Number of screen rows SCREENS_ITEMS The table contains configuration of screen cells. Column name Type Description screenitemid int Unique ID of the screen item screenid int Screen ID resource int Type of resource connected to the cell: 0 - graph 1 - simple graph 2 - map 3 - plain text values resourceid int Resource ID width int Width of the displayed resource. Ignored for Map. height int Height of the displayed resource. Ignored for Map. x int Coordinate X. y int Coordinate Y. SERVICES This table contains list of defined IT services. Column name Type Description serviceid int Unique service ID name int Description of the service status int Status of the service algorithm int Algorithm used to calculate status of the service: 0 - none 1 - MAX status of child services 2 - MIN status of child services triggerid int Is the service linked to the trigger: NULL – it is not otherwise, trigger ID sortorder int Defines sort order for IT Service form. goodsla float Acceptable SLA (in %). Example: 99.5 SERVICE_ALARMS This table is used to store history of state changes of IT Services. Column name Type Description servicealarmid int Unique ID serviceid int ID of IT Service clock int Timestamp. Number of second since 01/01/1970. value int [explain ...] SERVICES_LINKS This table is used to define connections between different services to form IT Service tree. Column name Type Description linkid int Unique link ID serviceupid int ID of higher level service servicedownid int ID of lower level service soft int 0 - hard link 1 - soft link SESSIONS The table contains list of user sessions. Column name Type Description sessionid varchar User ID userid int User ID lastaccess int Last time the session was used SYSMAPS The table contains list of defined network maps. Column name Type Description sysmapid int Unique network map ID name varchar Name of the network map width int Width of the map height int Height of the map background int Name of background image. label_type int Icon label type. 0 - host label 1 - IP address 2 - host name 3 - empty SYSMAPS_HOSTS The table contains definition of host displayed on network map. Column name Type Description shostid int Unique ID sysmapid int Network map ID hostid int Host ID icon varchar Icon name. Display this icon when host is in OK state. icon_on varchar Icon name. Display this icon when host has problems. label varchar Label displayed under host icon x int X y int Y url varchar If not empty, defines URL for displayed icon. SYSMAPS_LINKS The table contains list of connectors between hosts displayed on network map. Column name Type Description linkid int Unique link ID sysmapid int Network map ID shostid1 int ID of first host shostid2 int ID of second host triggerid int ID of trigger connected to this link. Can be NULL. drawtype_off int Draw type when trigger is in state FALSE: 0 - Line 2 - Bold line 4 - Dashed Line color_off varchar Color when trigger is in state FALSE: 0 - Line 2 - Bold line 4 - Dashed Line drawtype_on int Draw type when trigger is in state TRUE: 0 - Line 2 - Bold line color_on varchar Color when trigger is in state TRUE: 0 - Line 2 - Bold line TRENDS This table contains hourly averages of history of integer values of items. Column name Type Description itemid int Item ID clock int Timestamp (we are interested in hour only). Number of second since 01/01/1970. value_min double Minimum value_max double Maximum value_avg double Average num int Number of values of this hour TRIGGERS The table contains list of triggers. Column name Type Description triggerid int Unique trigger ID expression varchar Trigger's expression url varchar URL description varchar Description of the trigger status int Status of the trigger: 0 - enabled 1 - disabled value int Value of the trigger: 0 - FALSE 1 - TRUE 2 - UNKNOWN priority int Severity of the trigger: 0 - not classified 1 - just for information lastchange int Time when trigger value was changed dep_level int Dependency level. The number shows how many triggers depend on this trigger. TRIGGER_DEPENDS The table contains list of trigger dependencies. Column name Type Description triggerid_down int Trigger ID triggerid_up int Trigger ID. This trigger depends of triggerid_down. USERS The table contains list of ZABBIX’s users. Column name Type Description userid int Unique user ID name varchar Name of the user surname varchar Surname of the user alias varchar Short name of the user passwd varchar MD5 hash of user password url varchar Initial URL after login. Ignored if empty. USERS_GROUPS The table contains relationship between users and user groups. Column name Type Description usrgrpid int User group ID userid int User ID USRGRP The table contains list of user groups. Column name Type Description usrgrpid int Unique user group ID name varchar Name of the user group
	© 2001-2008 by ZABBIX SIA. All rights reserved. Hosting is kindly provided by Clearcut Networks.