Hi,

I had install Zabbix 6.06 and wanted to use Template MSSQL by ODBC for monitrong SQL-Servers.

Odbc is configured on zabbix server and it is able to connect to it. I got also a few data, for example MSSQL: job status and MSSQL: last backup works fine, but not all of them.  I've got problems with many other items: MSSQL Logins and MSSQL cache for example, see attachment. The message is:

Preprocessing failed for: [{"object_name":"$MSSQLSolidWorksProd","counter_name":"Uptime","instance_name":"","cntr_value":"1...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='$MSSQLSolidWorksProd:General Statistics' && @.counter_name=='Logins/sec')].cntr_value.first()": no data matches the specified path

the other messages are similary.

For MSSQL: Get performance counters is history on, see attachment.