MSSQL ODBC Monitoring - problem with preprocesing json
Hello, I have a problem with MSSQL monitoring (https://www.zabbix.com/integrations/mssql)
Theres a lot of errors similar to below:
Preprocessing failed for: [{"object_name":"MSSQL$MSSQLSERVER","counter_nam e": "Uptime","instance_name":"","cntr_value":"2781 ...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='MSSQL$MSSQLSERVER
atabases' && @.counter_name=='Log Shrinks' && @.instance_name=='DATABASE_NAME')].cntr_value.first()": no data matches the specified path
Zabbix version: Zabbix 6.0.8.
I've added macro:
{$MSSQL.INSTANCE} = MSSQL$MSSQLSERVER
Also I've tried with macro:
{$MSSQL.PREPROC} = MSSQL$MSSQLSERVER
Nothing has helped. The only thing I see in the latest data is the status of the databases and some data about backup. ODBC connection works.
Theres a lot of errors similar to below:
Preprocessing failed for: [{"object_name":"MSSQL$MSSQLSERVER","counter_nam e": "Uptime","instance_name":"","cntr_value":"2781 ...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='MSSQL$MSSQLSERVER
atabases' && @.counter_name=='Log Shrinks' && @.instance_name=='DATABASE_NAME')].cntr_value.first()": no data matches the specified pathZabbix version: Zabbix 6.0.8.
I've added macro:
{$MSSQL.INSTANCE} = MSSQL$MSSQLSERVER
Also I've tried with macro:
{$MSSQL.PREPROC} = MSSQL$MSSQLSERVER
Nothing has helped. The only thing I see in the latest data is the status of the databases and some data about backup. ODBC connection works.