Hi,
I'm trying to monitor a MSSQL instance using the MSSQL BY ODBC template.
The ODBC driver has been installed and configured,i'm able to fetch data , but for some reason,some of the metrics does not show up.
The error message is the same for all "not supported metrics":no data matches the specific path.
I've tested the connection from the zabbix server to SQL server,everyting looks fine.
The only thing which imo can block is the sql query itself who gives back all the datas:
If i run this code in Management studio,i got all the info.if i run line by line the queries from the zabbix server terminal i got an answer.But i don't know how to send all the command as one in the terminal(copy paste does not do the trick).
So may be someone here already had that issue and can help?
thanks!
I'm trying to monitor a MSSQL instance using the MSSQL BY ODBC template.
The ODBC driver has been installed and configured,i'm able to fetch data , but for some reason,some of the metrics does not show up.
The error message is the same for all "not supported metrics":no data matches the specific path.
I've tested the connection from the zabbix server to SQL server,everyting looks fine.
The only thing which imo can block is the sql query itself who gives back all the datas:
If i run this code in Management studio,i got all the info.if i run line by line the queries from the zabbix server terminal i got an answer.But i don't know how to send all the command as one in the terminal(copy paste does not do the trick).
So may be someone here already had that issue and can help?
thanks!