E
E
Evgeny N2021-05-14 15:08:09
Zabbix
Evgeny N, 2021-05-14 15:08:09

How to correctly compose a SQL query in Zabbix?

SQL database monitoring via ODBC is configured. So far, the request has been successfully executed and processed for my needs: sp_spaceused;

Another need arose: counting rows in the defined t_ActionsLog table

Through Microsoft SQL Server Management Studio, I created a query and successfully received a response:
609e65e23ddda214420950.png

In Zabbix it looks like this:
609e67ef7b9ba380463881.png

I get an error: Cannot obtain column #1 name.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question