Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-24002

issue with mssql integration

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Incomplete
    • Icon: Trivial Trivial
    • None
    • 6.0.25
    • None
    • None

      I get this error when i try to use the mssql integration with a mssql server.

      Preprocessing failed for: [{"object_name":"MSSQL$SQLEXPRESS:Access Methods","counter_name":"AU cleanup batches/sec","instan...
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​

      the zabbix can connect without issue with isql command 

       

       

      Looks like the issue happens if the instance name is something else then MSSQL$MSSQLSERVER
      As i have another server where it works with the instance name.

            edgar.akhmetshin Edgar Akhmetshin
            dfrantzen Daniel Frantzen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: