zabbix=# select * from host_discovery; hostid | parent_hostid | parent_itemid | host | lastcheck | ts_delete --------+---------------+---------------+------------+------------+------------ 10176 | | 26988 | | 0 | 0 10177 | | 26989 | | 0 | 0 10332 | | 31279 | | 0 | 0 10418 | 10416 | | {#HV.UUID} | 1600184312 | 0 10334 | | 31281 | | 0 | 0 10376 | | 33617 | | 0 | 0 10416 | | 38312 | | 0 | 0 10417 | | 38313 | | 0 | 0 10419 | 10416 | | {#HV.UUID} | 1600184312 | 0 10420 | 10416 | | {#HV.UUID} | 1600184312 | 0 10421 | 10416 | | {#HV.UUID} | 1600184312 | 0 10459 | 10416 | | {#HV.UUID} | 1600184312 | 0 10437 | 10417 | | {#VM.UUID} | 1599118714 | 1601710714 10439 | 10417 | | {#VM.UUID} | 1599118714 | 1601710714 10440 | 10417 | | {#VM.UUID} | 1599118714 | 1601710714 10442 | 10417 | | {#VM.UUID} | 1599118714 | 1601710714 10444 | 10417 | | {#VM.UUID} | 1599118714 | 1601710714 10445 | 10417 | | {#VM.UUID} | 1599118714 | 1601710714 10447 | 10417 | | {#VM.UUID} | 1599118714 | 1601710714 10451 | 10417 | | {#VM.UUID} | 1599118714 | 1601710714 10488 | 10417 | | {#VM.UUID} | 1600184313 | 0 10489 | 10417 | | {#VM.UUID} | 1600184313 | 0 10438 | 10417 | | {#VM.UUID} | 1600184313 | 0 10441 | 10417 | | {#VM.UUID} | 1600184313 | 0 10443 | 10417 | | {#VM.UUID} | 1600184313 | 0 10446 | 10417 | | {#VM.UUID} | 1600184313 | 0 10448 | 10417 | | {#VM.UUID} | 1600184313 | 0 10449 | 10417 | | {#VM.UUID} | 1600184313 | 0 10450 | 10417 | | {#VM.UUID} | 1600184313 | 0 (29 rows) zabbix=# select host,hostid from hosts where status=0; host | hostid --------------------------------------+-------- {#VM.UUID} | 10177 {#NODE} | 10332 50000dd1-d20d-e38b-631c-a7ed52a83f40 | 10488 siy05tai02-prom | 10379 siy05tai08-prom | 10384 {#NODE} | 10334 siy05tai11-prom | 10387 4c4c4544-0059-5110-8036-b9c04f4d5a32 | 10459 9140d814-a24a-11e8-8505-7ed30ad8357f | 10418 siy05tam02-prom | 10389 501b1901-0e52-1fde-7d13-5d6019cf3e42 | 10489 4c4c4544-0048-4810-8059-b8c04f353033 | 10419 siy05taa01-prom | 10374 siy05tai03-prom | 10335 {#NODE} | 10376 siy05taa02-prom | 10377 e2127f42-bddd-11e6-95f4-0090faf469e8 | 10420 siy05tai01-prom | 10378 siy05tam01-prom | 10388 siy05tam03-prom | 10390 54898d70-bde0-11e6-af8a-0090faf46a68 | 10421 SDA0SYL001 | 10358 siy05tai04-prom | 10380 siy05tai05-prom | 10381 SQNIFR456 | 10404 {#VM.UUID} | 10417 5019df20-9e3f-b9b3-f25d-297296d049c6 | 10437 5019a93f-e12b-58c4-5f52-ee22689de9a9 | 10438 501954e5-7295-49b2-0ff0-b4f96f227ee4 | 10439 5019c89c-1a5d-4dcc-7986-8bc570e6f567 | 10440 501bbd15-86dc-00cb-90d4-70f3d6f206a5 | 10441 5019da48-3442-349c-6130-0aecaf6dc7a2 | 10442 5019ff27-d49b-3239-e0a2-fde55f28ca0f | 10443 5019de77-56ec-d7bb-fd77-99ca317326d9 | 10444 siy05tai09-prom | 10385 501956b1-06e1-3a64-f7ba-60010dddef81 | 10445 5000aa4e-45cd-d54a-6278-57e72229916b | 10446 50190bf6-e59b-5fd2-9448-52be37148436 | 10447 SRY05KCA | 10466 5019e044-6223-1946-80ee-284108227403 | 10448 50006545-842a-4a20-7edd-cd8b4991f97a | 10449 5000e9d4-c10c-fdda-6f6a-f4c64b906cae | 10450 5019cc0b-23c7-bea1-1b77-e2bef4c2539b | 10451 siy05tai06-prom | 10382 siy05tai10-prom | 10386 sry0xgz201 | 10331 {#HV.UUID} | 10176 {#HV.UUID} | 10416 siy05tai07-prom | 10383 SQNIFR321 | 10410 zabbixocp | 10411 sqy0w9n5 | 10412 sry0xgz202 | 10329 SRY05KC6 | 10461 SIY05X03 | 10481 sry0xgz204 | 10400 SQY0NSI1.hpadmin.sf.intra.laposte.fr | 10485 331923MN-DC1C | 10497 SINWNG20 | 10415 SQMS0675 | 10453 sya0wnj3 | 10500 sry0xgz108 | 10354 SRY05KCB | 10474 sry0xgz105 | 10324 331923MN-DC2C | 10503 SRY05KC8 | 10462 SMY05X04-R740 | 10490 sry0xgz107 | 10355 sry0xgz106 | 10494 SRY05KC9 | 10484 sry0xgz104 | 10353 sry0xgz302 | 10483 sry0xgz203 | 10398 sry0xgz303 | 10396 sqy0w9n2 | 10406 SRY05KCD | 10472 SRY05KCC | 10475 SRY05KC7 | 10463 sry0xgz103 | 10336 sry0xgz301 | 10392 (80 rows)