Template DB MSSQL by ODBC - Issue with MSSQL: Get performance counters:

[grabine]

Hi all,

I obtained an issue with the template Template DB MSSQL by ODBC on Zabbix 5.0.2 and SQL server Microsoft SQL Server 2016.

I get the error message: Preprocessing failed for: [{"object_name":"MSSQL$MSSQLS2016:Access Methods","counter_name":"AU cleanup batches/sec","instan...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='MSSQLS2016:SQL Statistics' && @.counter_name=='Auto-Param Attempts/sec')].cntr_value.first()": no data matches the specified path

I cannot understand the root cause of this issue and only this item "MSSQL: Get performance counters" doesn't work.

I tried to follow this topic but I don't find the information noticed https://www.zabbix.com/forum/zabbix-...alue-from-json.

Could you please help me?

Thank you!

[leandro.schatts]

Hello, Can you solved it?