10.1.1.218 / 127.0.0.1 / glpi / glpi_users

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Navigation tree

Customize the navigation tree.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers

Servers display options.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »

Database: glpi »

Table: glpi_users

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Do a "query by example" (wildcard: "%")

Column	Type	Collation
id	INT
name	varchar(255)	utf8_unicode_ci
password	varchar(255)	utf8_unicode_ci
phone	varchar(255)	utf8_unicode_ci
phone2	varchar(255)	utf8_unicode_ci
mobile	varchar(255)	utf8_unicode_ci
realname	varchar(255)	utf8_unicode_ci
firstname	varchar(255)	utf8_unicode_ci
locations_id	INT
language	char(10)	utf8_unicode_ci
use_mode	INT
list_limit	INT
is_active	INT
comment	text	utf8_unicode_ci
auths_id	INT
authtype	INT
last_login	datetime
date_mod	datetime
date_sync	datetime
is_deleted	INT
profiles_id	INT
entities_id	INT
usertitles_id	INT
usercategories_id	INT
date_format	INT
number_format	INT
names_format	INT
csv_delimiter	char(1)	utf8_unicode_ci
is_ids_visible	INT
use_flat_dropdowntree	INT
show_jobs_at_login	INT
priority_1	char(20)	utf8_unicode_ci
priority_2	char(20)	utf8_unicode_ci
priority_3	char(20)	utf8_unicode_ci
priority_4	char(20)	utf8_unicode_ci
priority_5	char(20)	utf8_unicode_ci
priority_6	char(20)	utf8_unicode_ci
followup_private	INT
task_private	INT
default_requesttypes_id	INT
password_forget_token	char(40)	utf8_unicode_ci
password_forget_token_date	datetime
user_dn	text	utf8_unicode_ci
registration_number	varchar(255)	utf8_unicode_ci
show_count_on_tabs	INT
refresh_ticket_list	INT
set_default_tech	INT
personal_token	varchar(255)	utf8_unicode_ci
personal_token_date	datetime
api_token	varchar(255)	utf8_unicode_ci
api_token_date	datetime
cookie_token	varchar(255)	utf8_unicode_ci
cookie_token_date	datetime
display_count_on_home	INT
notification_to_myself	INT
duedateok_color	varchar(255)	utf8_unicode_ci
duedatewarning_color	varchar(255)	utf8_unicode_ci
duedatecritical_color	varchar(255)	utf8_unicode_ci
duedatewarning_less	INT
duedatecritical_less	INT
duedatewarning_unit	varchar(255)	utf8_unicode_ci
duedatecritical_unit	varchar(255)	utf8_unicode_ci
display_options	text	utf8_unicode_ci
is_deleted_ldap	INT
pdffont	varchar(255)	utf8_unicode_ci
picture	varchar(255)	utf8_unicode_ci
begin_date	datetime
end_date	datetime
keep_devices_when_purging_item	INT
privatebookmarkorder	longtext	utf8_unicode_ci
backcreated	INT
task_state	INT
layout	char(20)	utf8_unicode_ci
palette	char(20)	utf8_unicode_ci
set_default_requester	INT
lock_autolock_mode	INT
lock_directunlock_notification	INT
date_creation	datetime
highcontrast_css	INT
plannings	text	utf8_unicode_ci
sync_field	varchar(255)	utf8_unicode_ci
groups_id	INT
users_id_supervisor	INT

Select columns (at least one): DISTINCT

Or Add search conditions (body of the "where" clause):

Number of rows per page

Display order:

Ascending

Descending

id
name
password
phone
phone2
mobile
realname
firstname
locations_id
language
use_mode
list_limit
is_active
comment
auths_id
authtype
last_login
date_mod
date_sync
is_deleted
profiles_id
entities_id
usertitles_id
usercategories_id
date_format
number_format
names_format
csv_delimiter
is_ids_visible
use_flat_dropdowntree
show_jobs_at_login
priority_1
priority_2
priority_3
priority_4
priority_5
priority_6
followup_private
task_private
default_requesttypes_id
password_forget_token
password_forget_token_date
user_dn
registration_number
show_count_on_tabs
refresh_ticket_list
set_default_tech
personal_token
personal_token_date
api_token
api_token_date
cookie_token
cookie_token_date
display_count_on_home
notification_to_myself
duedateok_color
duedatewarning_color
duedatecritical_color
duedatewarning_less
duedatecritical_less
duedatewarning_unit
duedatecritical_unit
display_options
is_deleted_ldap
pdffont
picture
begin_date
end_date
keep_devices_when_purging_item
privatebookmarkorder
backcreated
task_state
layout
palette
set_default_requester
lock_autolock_mode
lock_directunlock_notification
date_creation
highcontrast_css
plannings
sync_field
groups_id
users_id_supervisor