> Attach the 'MSSQL by ODBC' template to the host running MSSQL
> Modified the macros as documented
> Zabbix isn't able to get all the dependent items data

> Confirmed that ODBC connection from Zabbix host machine to server running MSSQL works
> Installed official Microsoft Drivers
> Items such as MSSQL: version and Uptime are monitored as expected. But the majority of all other dependent items have the same problem:

Preprocessing failed for: [{"object_name":"MSSQL$MSSQL1:Access Methods","counter_name":"AU cleanup batches/sec","instance_n...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Locks' && @.counter_name=='Average Wait Time Base' && @.instance_name=='_Total')].cntr_value.first()": no data matches the specified path

Something about the json/path isn't correct and it has been an issue for awhile now with different Zabbix versions. Tried it with version 5.2 and 5.4. It has been previously reported in the community.