MSSQL query with active agent

[Raphy59]

Hello,

I have a Debian server hosting Zabbix, and I have a remote Windows PC that I want to supervise (that's ok its running), the agent is configured as active (StartAgents = 0) because there are routers / firewall that I will not have access.

On the remote Windows PC, I have a DB MSSQL 2014, I want to make a request in this database and send the result on the Zabbix server for display it graphically.

So I try to use what's on this page https://www.zabbix.com/documentation...ry/sql_queries

But I still have this error: Can not connect to ODBC DSN: [SQL_ERROR]: [IM002] [0] [[unixODBC] [Driver Manager] Data source name not found, and no default driver specified]

Already, I do not understand why he speaks to me of "unixODBC", it should not directly use the ODBC connector that is on the Windows PC ?? Because what I want is for the agent to make the SQL request and return it to the server, and not that the server uses its ODBC to connect to the remote database.

Or maybe I'm wrong?

this is my config.

Thank you for your help

[Atsushi]

Items using Zabbix's ODBC will run on the Zabbix server. Therefore, it is necessary to install and configure the ODBC driver on the server running Zabbix server. db.odbc.discovery[] can not be used via Zabbix agent.

If you want to monitor MS SQL Server via Zabbix agent, you will need to consider how to get the value using UserParameter etc.

[Raphy59]

Thank you! It works fine now, I realized my SQL query directly using the UserParameter

Thank you!!