mysql> select hostid,name from hosts where name = 'integration-app'; +--------+-----------------+ | hostid | name | +--------+-----------------+ | 10081 | integration-app | +--------+-----------------+ 1 row in set (0.00 sec) mysql> select * from interface where hostid = 10081; +-------------+--------+------+------+-------+---------------+-----------------+-------+ | interfaceid | hostid | main | type | useip | ip | dns | port | +-------------+--------+------+------+-------+---------------+-----------------+-------+ | 10033 | 10081 | 1 | 1 | 1 | 192.168.60.81 | integration-app | 10050 | | 10034 | 10081 | 1 | 4 | 1 | 192.168.60.81 | integration-app | 5678 | | 10039 | 10081 | 0 | 4 | 1 | 192.168.60.81 | integration-app | 5679 | +-------------+--------+------+------+-------+---------------+-----------------+-------+ 3 rows in set (0.00 sec) mysql> select COUNT(itemid) from items where interfaceid=10033; +---------------+ | COUNT(itemid) | +---------------+ | 86 | +---------------+ 1 row in set (0.00 sec) mysql> mysql> select COUNT(itemid) from items where interfaceid=10034; +---------------+ | COUNT(itemid) | +---------------+ | 84 | +---------------+ 1 row in set (0.01 sec) mysql> select COUNT(itemid) from items where interfaceid=10039; +---------------+ | COUNT(itemid) | +---------------+ | 0 | +---------------+ 1 row in set (0.00 sec)