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

Docs/DB schema/3.4/users

From Zabbix.org
Jump to: navigation, search

This table contains user accounts.

Columns

Column Detail Default NULL? Type Ref from Ref to
userid User ID. Managed by Zabbix via the ids table. NONE NOT NULL id acknowledges.userid C
alerts.userid C
auditlog.userid C
dashboard.userid
dashboard_user.userid C
event_recovery.userid
media.userid C
opmessage_usr.userid
problem.userid
profiles.userid C
screen_user.userid C
screens.userid
sessions.userid C
slideshow_user.userid C
slideshows.userid
sysmap_user.userid C
sysmaps.userid
users_groups.userid C
alias Username. EMPTY NOT NULL varchar(100)
name Name. EMPTY NOT NULL varchar(100)
surname Surname. EMPTY NOT NULL varchar(100)
passwd MD5 hash of password. EMPTY NOT NULL char(32)
url URL, automatically opened after logging in. EMPTY NOT NULL varchar(255)
autologin
  • 0 - disabled
  • 1 - enabled
0 NOT NULL integer
autologout
  • 0 - disabled
  • integer or time period - autologout after this many seconds or after the specified time period

NOTE: this feature likely does not work as one might expect before Zabbix 4.0.

15m NOT NULL varchar(32)
lang Frontend locale for the user. en_GB NOT NULL varchar(5)
refresh
  • 0 - disabled
  • integer or time period - automatically reload pages or information in them like graphs every refresh seconds or the specified time period
30s NOT NULL varchar(32)
type User type
  • 1 - USER_TYPE_ZABBIX_USER
  • 2 - USER_TYPE_ZABBIX_ADMIN
  • 3 - USER_TYPE_SUPER_ADMIN
1 NOT NULL integer
theme Frontend theme for the user.
  • default - use the global default theme, set in Administration -> General -> GUI -> Default theme
  • theme - use the specified theme, no matter what's the global default
default NOT NULL varchar(128)
attempt_failed How many sequential failed login attempts have there been for this account. 0 NOT NULL integer
attempt_ip IP address of the last failed login attempt. EMPTY NOT NULL varchar(39)
attempt_clock Unix timestamp of the last failed login attempt. 0 NOT NULL integer
rows_per_page How many rows to display per page when pagination kicks in. Still limited by Administration -> General -> GUI -> Limit for search and filter results. 50 NOT NULL integer

Indexes

Name UNIQ Columns
PRIMARY KEY YES userid
users_1 YES alias