10.1.1.218 / 127.0.0.1 / glpi / glpi_ipaddresses

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_ipaddresses

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 :

Browse mode

Browse mode

Customize browse mode.

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (1080 total, Query took 0.0009 seconds.)

SELECT * FROM `glpi_ipaddresses`

[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]

Filter rows:

			id	entities_id	items_id	itemtype	version	name	binary_0	binary_1	binary_2	binary_3	is_deleted	is_dynamic	mainitems_id	mainitemtype
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 197	197	0	150	NetworkName	4	192.168.1.32	0	0	65535	3232235808	0	1	52	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 198	198	0	150	NetworkName	6	fe80::61ab:9a54:c0a7:b4d8	4269801472	0	1638636116	3232216280	0	1	52	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 228	228	0	149	NetworkName	6	fe80::ec41:3870:aaf4:f14f	4269801472	0	3963697264	2868179279	0	1	52	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 229	229	0	183	NetworkName	4	10.1.1.98	0	0	65535	167838050	0	1	67	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 259	259	0	221	NetworkName	4	169.254.215.226	0	0	65535	2852050914	0	1	81	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 540	540	0	490	NetworkName	4	10.1.4.123	0	0	65535	167838843	0	1	153	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 541	541	0	490	NetworkName	6	fe80::fc48:8c58:e490:56df	4269801472	0	4232612952	3834664671	0	1	153	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 548	548	0	497	NetworkName	4	10.1.4.109	0	0	65535	167838829	0	1	154	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 549	549	0	497	NetworkName	6	fe80::9592:b977:4cff:4bcf	4269801472	0	2509420919	1291799503	0	1	154	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 743	743	0	657	NetworkName	4	10.1.1.239	0	0	65535	167838191	0	1	162	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 744	744	0	657	NetworkName	6	fe80::812c:c2b1:b491:9ea0	4269801472	0	2167194289	3029442208	0	1	162	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 745	745	0	659	NetworkName	4	11.1.1.11	0	0	65535	184615179	0	1	162	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 746	746	0	659	NetworkName	6	fe80::d526:f4f6:810f:559f	4269801472	0	3576100086	2165265823	0	1	162	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 747	747	0	660	NetworkName	4	192.168.56.1	0	0	65535	3232249857	0	1	162	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 748	748	0	660	NetworkName	6	fe80::118a:193f:d7cf:6740	4269801472	0	294263103	3620693824	0	1	162	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1058	1058	0	548	NetworkName	4	10.1.12.108	0	0	65535	167840876	0	1	157	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1059	1059	0	548	NetworkName	6	fe80::55ec:c83d:17c9:2d88	4269801472	0	1441581117	399060360	0	1	157	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1135	1135	0	925	NetworkName	6	fe80::4991:c85b:60d1:4b7b	4269801472	0	1234290779	1624329083	0	1	157	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1142	1142	0	928	NetworkName	6	fe80::9140:8770:4c4f:1bd8	4269801472	0	2436925296	1280252888	0	1	157	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1165	1165	0	928	NetworkName	4	10.242.2.3	0	0	65535	183632387	0	1	157	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1293	1293	0	925	NetworkName	4	10.1.6.104	0	0	65535	167839336	0	1	157	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1304	1304	0	1043	NetworkName	6	fe80::1b8:5265:235e:a4ea	4269801472	0	28856933	593405162	0	1	166	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1382	1382	0	1085	NetworkName	4	10.1.1.42	0	0	65535	167837994	0	1	174	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1383	1383	0	1085	NetworkName	6	fe80::159c:e597:80af:26fc	4269801472	0	362603927	2158962428	0	1	174	Computer
Edit	Copy	Delete DELETE FROM `glpi_ipaddresses` WHERE `glpi_ipaddresses`.`id` = 1459	1459	0	205	NetworkName	4	10.1.1.27	0	0	65535	167837979	0	1	75	Computer

Check all With selected:

Filter rows:

Query results operations