Mysql Database Monitoring by Zabbix

[Akansha123]

I am trying to configure ODBC monitoring in Zabbix and I am using ubuntu 14.04 .

I am able to connect and monitor Mysql Database using Zabbix but the issue is when I am trying to monitor the output of Query " select hostid from hosts limit 5; " in Zabbix . It Giving only first row data "10090" but in actual the output of this query is as below .

FYI.

mysql> select hostid from hosts limit 5;
+--------+
| hostid |
+--------+
| 10090 |
| 10092 |
| 10110 |
| 10111 |
| 10112 |


Can anyone help me so that it will display the actual output of Query ?

Thanks
Mudit

[Semiadmin]

It's a limitation of Zabbix ODBC checks

From https://www.zabbix.com/documentation...es/odbc_checks

15.7 Important notes

If a query returns more than one line, only the first line is read

[Akansha123]

Mysql Database Monitoring by Zabbix

Semiadmin

Thanks for info !!!