-bash-4.2$ mysql -u zabbix -p zabbix Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 998954 Server version: 5.7.21-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select dcheckid,druleid,type,key_ from dchecks where druleid in (select druleid from drules where name="DMZ"); +----------+---------+------+--------------+ | dcheckid | druleid | type | key_ | +----------+---------+------+--------------+ | 7 | 5 | 12 | | | 8 | 5 | 9 | system.uname | +----------+---------+------+--------------+ 2 rows in set (3.39 sec) mysql> select dserviceid,dhostid,status,dcheckid from dservices where dcheckid in (select dcheckid from dchecks where druleid in (select druleid from drules where name="DMZ")); +------------+---------+--------+----------+ | dserviceid | dhostid | status | dcheckid | +------------+---------+--------+----------+ | 1 | 1 | 0 | 7 | | 31 | 21 | 0 | 7 | | 138 | 100 | 0 | 7 | | 140 | 102 | 0 | 7 | | 543 | 387 | 0 | 7 | | 141 | 103 | 0 | 7 | | 144 | 105 | 0 | 7 | | 544 | 388 | 0 | 7 | | 146 | 106 | 0 | 7 | | 476 | 342 | 0 | 7 | | 148 | 107 | 0 | 7 | | 386 | 287 | 1 | 7 | | 150 | 108 | 0 | 7 | | 151 | 109 | 0 | 7 | | 152 | 110 | 0 | 7 | | 36 | 25 | 1 | 7 | | 156 | 114 | 0 | 7 | | 545 | 389 | 0 | 7 | | 160 | 117 | 0 | 7 | | 162 | 118 | 0 | 7 | | 436 | 327 | 0 | 7 | | 413 | 313 | 0 | 7 | | 165 | 120 | 0 | 7 | | 168 | 122 | 0 | 7 | | 170 | 123 | 0 | 7 | | 172 | 124 | 0 | 7 | | 174 | 125 | 0 | 7 | | 44 | 32 | 0 | 7 | | 177 | 127 | 0 | 7 | | 179 | 128 | 0 | 7 | | 181 | 129 | 0 | 7 | | 507 | 361 | 0 | 7 | | 184 | 132 | 0 | 7 | | 186 | 133 | 0 | 7 | | 188 | 134 | 0 | 7 | | 191 | 136 | 0 | 7 | | 193 | 137 | 0 | 7 | | 195 | 138 | 0 | 7 | | 199 | 140 | 0 | 7 | | 202 | 142 | 0 | 7 | | 204 | 143 | 0 | 7 | | 206 | 145 | 0 | 7 | | 208 | 147 | 0 | 7 | | 210 | 149 | 1 | 7 | | 416 | 316 | 0 | 7 | | 425 | 324 | 0 | 7 | | 499 | 355 | 0 | 7 | | 834 | 507 | 0 | 7 | | 403 | 303 | 1 | 7 | | 218 | 155 | 1 | 7 | | 496 | 352 | 1 | 7 | | 497 | 353 | 1 | 7 | | 238 | 170 | 1 | 7 | | 241 | 172 | 1 | 7 | | 51 | 38 | 0 | 7 | | 243 | 174 | 1 | 7 | | 461 | 332 | 0 | 7 | | 250 | 180 | 0 | 7 | | 252 | 182 | 0 | 7 | | 56 | 41 | 1 | 7 | | 254 | 184 | 1 | 7 | | 59 | 43 | 0 | 7 | | 419 | 319 | 0 | 7 | | 262 | 191 | 1 | 7 | | 399 | 299 | 1 | 7 | | 61 | 44 | 0 | 7 | | 487 | 347 | 0 | 7 | | 472 | 339 | 1 | 7 | | 63 | 45 | 1 | 7 | | 492 | 350 | 1 | 7 | | 501 | 356 | 0 | 7 | | 284 | 211 | 1 | 7 | | 286 | 213 | 1 | 7 | | 531 | 379 | 0 | 7 | | 438 | 328 | 0 | 7 | | 567 | 399 | 0 | 7 | | 580 | 402 | 0 | 7 | | 457 | 331 | 1 | 7 | | 304 | 227 | 1 | 7 | | 306 | 229 | 0 | 7 | | 465 | 334 | 0 | 7 | | 600 | 413 | 0 | 7 | | 505 | 360 | 0 | 7 | | 605 | 415 | 0 | 7 | | 67 | 48 | 1 | 7 | | 380 | 281 | 1 | 7 | | 68 | 49 | 1 | 7 | | 477 | 343 | 0 | 7 | | 830 | 505 | 0 | 7 | | 10 | 8 | 0 | 7 | | 90 | 65 | 0 | 7 | | 390 | 290 | 1 | 7 | | 23 | 16 | 0 | 7 | | 26 | 18 | 0 | 7 | | 482 | 1 | 1 | 8 | | 641 | 21 | 0 | 8 | | 32 | 21 | 0 | 8 | | 653 | 103 | 0 | 8 | | 142 | 103 | 0 | 8 | | 654 | 105 | 0 | 8 | | 145 | 105 | 0 | 8 | | 655 | 106 | 0 | 8 | | 147 | 106 | 0 | 8 | | 656 | 342 | 0 | 8 | | 530 | 342 | 0 | 8 | | 657 | 107 | 0 | 8 | | 149 | 107 | 0 | 8 | | 387 | 287 | 1 | 8 | | 448 | 110 | 1 | 8 | | 37 | 25 | 1 | 8 | | 658 | 114 | 0 | 8 | | 157 | 114 | 0 | 8 | | 659 | 117 | 0 | 8 | | 161 | 117 | 0 | 8 | | 660 | 118 | 0 | 8 | | 163 | 118 | 0 | 8 | | 437 | 327 | 1 | 8 | | 661 | 313 | 0 | 8 | | 449 | 313 | 0 | 8 | | 662 | 120 | 0 | 8 | | 166 | 120 | 0 | 8 | | 663 | 122 | 0 | 8 | | 169 | 122 | 0 | 8 | | 664 | 123 | 0 | 8 | | 171 | 123 | 0 | 8 | | 665 | 124 | 0 | 8 | | 173 | 124 | 0 | 8 | | 666 | 125 | 0 | 8 | | 175 | 125 | 0 | 8 | | 642 | 32 | 0 | 8 | | 45 | 32 | 0 | 8 | | 667 | 127 | 0 | 8 | | 178 | 127 | 0 | 8 | | 668 | 128 | 0 | 8 | | 180 | 128 | 0 | 8 | | 669 | 129 | 0 | 8 | | 450 | 129 | 0 | 8 | | 643 | 361 | 0 | 8 | | 508 | 361 | 0 | 8 | | 670 | 132 | 0 | 8 | | 185 | 132 | 0 | 8 | | 671 | 133 | 0 | 8 | | 187 | 133 | 0 | 8 | | 672 | 134 | 0 | 8 | | 189 | 134 | 0 | 8 | | 673 | 136 | 0 | 8 | | 192 | 136 | 0 | 8 | | 674 | 137 | 0 | 8 | | 194 | 137 | 0 | 8 | | 675 | 138 | 0 | 8 | | 196 | 138 | 0 | 8 | | 676 | 140 | 0 | 8 | | 200 | 140 | 0 | 8 | | 677 | 142 | 0 | 8 | | 203 | 142 | 0 | 8 | | 678 | 143 | 0 | 8 | | 430 | 143 | 0 | 8 | | 679 | 145 | 0 | 8 | | 431 | 145 | 0 | 8 | | 680 | 147 | 0 | 8 | | 432 | 147 | 0 | 8 | | 681 | 149 | 0 | 8 | | 433 | 149 | 1 | 8 | | 682 | 316 | 0 | 8 | | 434 | 316 | 0 | 8 | | 683 | 324 | 0 | 8 | | 426 | 324 | 0 | 8 | | 684 | 355 | 0 | 8 | | 500 | 355 | 0 | 8 | | 833 | 507 | 0 | 8 | | 452 | 303 | 1 | 8 | | 239 | 170 | 1 | 8 | | 52 | 38 | 1 | 8 | | 644 | 332 | 0 | 8 | | 462 | 332 | 0 | 8 | | 645 | 41 | 0 | 8 | | 57 | 41 | 1 | 8 | | 646 | 43 | 0 | 8 | | 60 | 43 | 0 | 8 | | 647 | 44 | 1 | 8 | | 62 | 44 | 0 | 8 | | 648 | 45 | 0 | 8 | | 64 | 45 | 1 | 8 | | 493 | 350 | 1 | 8 | | 287 | 213 | 1 | 8 | | 649 | 328 | 0 | 8 | | 444 | 328 | 0 | 8 | | 650 | 331 | 0 | 8 | | 458 | 331 | 1 | 8 | | 651 | 334 | 0 | 8 | | 466 | 334 | 0 | 8 | | 652 | 413 | 0 | 8 | | 603 | 413 | 0 | 8 | | 506 | 360 | 1 | 8 | | 706 | 415 | 0 | 8 | | 445 | 48 | 1 | 8 | | 69 | 49 | 1 | 8 | | 478 | 343 | 1 | 8 | | 11 | 8 | 1 | 8 | | 91 | 65 | 1 | 8 | | 640 | 18 | 0 | 8 | | 27 | 18 | 0 | 8 | +------------+---------+--------+----------+ 202 rows in set (0.00 sec) mysql>