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

Docs/DB schema/3.4/sessions

From Zabbix.org
Jump to: navigation, search

This table contains user sessions. While mostly used for the frontend, affects some server operations, too.

Columns

Column Detail Default NULL? Type Ref from Ref to
sessionid Session ID. MD5 string. Second half of this (16 characters) is the sid parameter, used by the frontend. EMPTY NOT NULL varchar(32)
userid User ID. NONE NOT NULL id users.userid C
lastaccess Unix timestamp of the time when this session was last used. 0 NOT NULL integer
status Session status. Sessions can become "passive" when user logs out (directly or via auto-logout), or (for users who are not using local authentication) when frontend is set to non-local authentication. Passive (inactive) sessions are periodically removed by housekeeper.
  • 0 - ZBX_SESSION_ACTIVE
  • 1 - ZBX_SESSION_PASSIVE
0 NOT NULL integer

Indexes

Name UNIQ Columns
PRIMARY KEY YES sessionid
sessions_1 No userid, status, lastaccess