Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: glpi »Table: glpi_ipnetworks
Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





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

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (161 total, Query took 0.0006 seconds.)
SELECT * FROM `glpi_ipnetworks`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full texts identities_idis_recursiveipnetworks_idcompletenamelevelancestors_cachesons_cacheaddressableversionnameaddressaddress_0address_1address_2address_3netmasknetmask_0netmask_1netmask_2netmask_3gatewaygateway_0gateway_1gateway_2gateway_3commentdate_moddate_creation
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 1
1 0 0 39 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 5 NULL NULL 0 4 10.1.1.0/255.255.255.0 - 10.1.1.254 10.1.1.0 0 0 65535 167837952 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.1.254 0 0 65535 167838206 NULL 2020-05-27 14:05:02 2020-05-27 14:05:02
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 2
2 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.4.0/255.255.255.0 - 10.1.4.254 10.1.4.0 0 0 65535 167838720 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.4.254 0 0 65535 167838974 NULL 2020-05-27 15:26:34 2020-05-27 15:26:34
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 3
3 0 0 127 192.0.0.0/255.0.0.0 - 192.168.4.254 > 192.168.0.0/... 4 NULL NULL 0 4 192.168.1.0/255.255.255.0 - 192.168.1.254 192.168.1.0 0 0 65535 3232235776 255.255.255.0 4294967295 4294967295 4294967295 4294967040 192.168.1.254 0 0 65535 3232236030 NULL 2020-06-17 13:19:12 2020-06-17 13:19:12
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 4
4 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.12.0/255.255.255.0 - 10.1.12.254 10.1.12.0 0 0 65535 167840768 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.12.254 0 0 65535 167841022 NULL 2020-06-24 20:07:25 2020-06-24 20:07:25
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 5
5 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.5.0/255.255.255.0 - 10.1.5.254 10.1.5.0 0 0 65535 167838976 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.5.254 0 0 65535 167839230 NULL 2020-07-01 19:29:29 2020-07-01 19:29:29
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 6
6 0 0 130 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 4 NULL NULL 0 4 10.1.2.0/255.255.255.0 - 10.1.2.254 10.1.2.0 0 0 65535 167838208 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.2.254 0 0 65535 167838462 NULL 2020-07-06 12:19:02 2020-07-06 12:19:02
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 7
7 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.16.0/255.255.255.0 - 10.1.16.254 10.1.16.0 0 0 65535 167841792 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.16.254 0 0 65535 167842046 NULL 2020-07-10 19:44:55 2020-07-10 19:44:55
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 8
8 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.9.0/255.255.255.0 - 10.1.9.254 10.1.9.0 0 0 65535 167840000 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.9.254 0 0 65535 167840254 NULL 2020-07-13 20:51:46 2020-07-13 20:51:46
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 9
9 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.13.0/255.255.255.0 - 10.1.13.254 10.1.13.0 0 0 65535 167841024 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.13.254 0 0 65535 167841278 NULL 2020-07-13 21:19:10 2020-07-13 21:19:10
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 10
10 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.11.0/255.255.255.0 - 10.1.11.254 10.1.11.0 0 0 65535 167840512 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.11.254 0 0 65535 167840766 NULL 2020-07-15 19:40:38 2020-07-15 19:40:38
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 11
11 0 0 0 172.20.10.0/255.255.255.240 - 172.20.10.1 1 [] NULL 0 4 172.20.10.0/255.255.255.240 - 172.20.10.1 172.20.10.0 0 0 65535 2886994432 255.255.255.240 4294967295 4294967295 4294967295 4294967280 172.20.10.1 0 0 65535 2886994433 NULL 2020-08-21 09:07:59 2020-08-21 09:07:59
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 12
12 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.8.0/255.255.255.0 - 10.1.8.254 10.1.8.0 0 0 65535 167839744 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.8.254 0 0 65535 167839998 NULL 2020-09-10 08:31:39 2020-09-10 08:31:39
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 13
13 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.15.0/255.255.255.0 - 10.1.15.254 10.1.15.0 0 0 65535 167841536 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.15.254 0 0 65535 167841790 NULL 2020-09-10 10:24:32 2020-09-10 10:24:32
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 14
14 0 0 0 169.254.0.0/255.255.0.0 - 10.1.11.254 1 [] NULL 0 4 169.254.0.0/255.255.0.0 - 10.1.11.254 169.254.0.0 0 0 65535 2851995648 255.255.0.0 4294967295 4294967295 4294967295 4294901760 0 0 0 0 NULL 2020-09-11 10:06:54 2020-09-11 10:06:54
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 15
15 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.17.0/255.255.255.0 - 10.1.17.254 10.1.17.0 0 0 65535 167842048 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.17.254 0 0 65535 167842302 NULL 2020-09-11 10:55:22 2020-09-11 10:55:22
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 16
16 0 0 127 192.0.0.0/255.0.0.0 - 192.168.4.254 > 192.168.0.0/... 4 NULL NULL 0 4 192.168.0.0/255.255.255.0 - 192.168.0.1 192.168.0.0 0 0 65535 3232235520 255.255.255.0 4294967295 4294967295 4294967295 4294967040 192.168.0.1 0 0 65535 3232235521 NULL 2020-09-14 08:33:51 2020-09-14 08:33:51
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 17
17 0 0 88 192.0.0.0/255.0.0.0 - 192.168.4.254 > 192.168.0.0/... 3 NULL NULL 0 4 192.168.15.0/255.255.255.0 - 192.168.15.1 192.168.15.0 0 0 65535 3232239360 255.255.255.0 4294967295 4294967295 4294967295 4294967040 192.168.15.1 0 0 65535 3232239361 NULL 2020-09-21 16:05:58 2020-09-21 16:05:58
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 18
18 0 0 88 192.0.0.0/255.0.0.0 - 192.168.4.254 > 192.168.0.0/... 3 NULL NULL 0 4 192.168.100.0/255.255.255.0 - 192.168.100.1 192.168.100.0 0 0 65535 3232261120 255.255.255.0 4294967295 4294967295 4294967295 4294967040 192.168.100.1 0 0 65535 3232261121 NULL 2020-09-21 16:31:01 2020-09-21 16:31:01
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 19
19 0 0 20 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.0.0.0/255.255... 3 NULL NULL 0 4 10.0.0.0/255.255.255.0 - 10.0.0.1 10.0.0.0 0 0 65535 167772160 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.0.0.1 0 0 65535 167772161 NULL 2020-09-21 16:33:01 2020-09-21 16:33:01
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 20
20 0 0 30 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.0.0.0/255.255... 2 {"30":"30"} NULL 0 4 10.0.0.0/255.255.0.0 - 10.0.0.1 10.0.0.0 0 0 65535 167772160 255.255.0.0 4294967295 4294967295 4294967295 4294901760 10.0.0.1 0 0 65535 167772161 NULL 2020-09-22 08:35:18 2020-09-22 08:35:18
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 21
21 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.14.0/255.255.255.0 - 10.1.14.254 10.1.14.0 0 0 65535 167841280 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.14.254 0 0 65535 167841534 NULL 2020-10-13 10:01:10 2020-10-13 10:01:10
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 22
22 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.10.0/255.255.255.0 - 10.1.10.254 10.1.10.0 0 0 65535 167840256 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.10.254 0 0 65535 167840510 NULL 2020-10-14 10:02:05 2020-10-14 10:02:05
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 23
23 0 0 130 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 4 NULL NULL 0 4 10.1.3.0/255.255.255.0 - 10.1.3.254 10.1.3.0 0 0 65535 167838464 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.3.254 0 0 65535 167838718 NULL 2020-10-27 10:25:17 2020-10-27 10:25:17
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 24
24 0 0 0 25.0.0.0/255.0.0.0 - 25.0.0.1 1 [] NULL 0 4 25.0.0.0/255.0.0.0 - 25.0.0.1 25.0.0.0 0 0 65535 419430400 255.0.0.0 4294967295 4294967295 4294967295 4278190080 25.0.0.1 0 0 65535 419430401 NULL 2020-11-09 08:33:14 2020-11-09 08:33:14
Edit EditCopy CopyDelete Delete
DELETE FROM `glpi_ipnetworks` WHERE `glpi_ipnetworks`.`id` = 25
25 0 0 40 10.0.0.0/255.0.0.0 - 10.1.1.254 > 10.1.0.0/255.255... 3 NULL NULL 0 4 10.1.6.0/255.255.255.0 - 10.1.6.254 10.1.6.0 0 0 65535 167839232 255.255.255.0 4294967295 4294967295 4294967295 4294967040 10.1.6.254 0 0 65535 167839486 NULL 2020-11-16 06:31:09 2020-11-16 06:31:09
With selected: With selected:
|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport ExportDisplay chart Display chartCreate view Create view