issue with mssql integration

XMLWordPrintable

    • Type: Problem report
    • Resolution: Incomplete
    • Priority: Trivial
    • None
    • Affects Version/s: 6.0.25
    • Component/s: 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.

            Assignee:
            Edgar Akhmetshin
            Reporter:
            Daniel Frantzen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: