Database monitor truncates results

[timmy8ken]

Hello Zabbix Forums,

I have been configuring some database monitors using an ODBC connection to Microsoft SQL servers, mostly this has been working well as I have been using COUNT SQL queries to tell me if there is an entry in a table. Mostly these have been very small numbers, like 1.

I am now trying to configure a query that will return a count that is much larger and use this for graphing history as well as triggering an alert. I have noticed that Zabbix is truncating my results so it is only showing the first three characters.

I have configured my item like the attached image.

I have tested the query from isql on the zabbix server, and the results are correct:

SQL> select count (*) FROM [distribution].[dbo].[MSrepl_commands]
+------------+
|            |
+------------+
| 48657      |
+------------+
SQLRowCount returns 1
1 rows fetched

However the results showing in latest data, and the graph, are showing 486:

SQL Replication Distribution Database MSrepl_commands	2017-01-24 17:00:58	486

The same problem has occurred if I try and retrieve a time stamp from a query, although that truncates at 16 characters. However, if I retrieve a text string then it returns the full string and it is not truncated.

Thanks in advance,

Tim