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

Official template MSSQLServer Failed: cannot extract value from json by path

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Major Major
    • 5.0.5rc1
    • Templates (T)
    • None
    • Centos 7.8 full updated
      Zabbix server 5.0.4
      Using ODBC Microsoft ODBC 17
    • 0.5

      Steps to reproduce:

      1. Install the ODBC and configure odbc.ini at /etc/odbc.ini
      2. Configure a Host with the required values in MACRO from the official template of MSSQL in order to connect to MSSQL
      3. Configure the value {$MSSQL.INSTANCE} macro as MSSQL$instance
      4. Check each dependant item with the following error:

      Result:
      Preprocessing failed for: [{"object_name":"MSSQL$ISNTANCENAME","counter_na me":"Uptime","instance_name":"","cntr_value":".. .
      1. Failed: cannot extract value from json by path "$[?(@.object_name=='MSSQL$ISNTANCENAME:SQL Statistics' && @.counter_name=='Batch Requests/sec')].cntr_value.first()": no data matches the specified path
      Expected:
      See screenshot

        1. image_17428.png
          image_17428.png
          75 kB
        2. output.txt
          64 kB
        3. template_db_mssql_odbc.yaml
          146 kB
        4. zabbix1.png
          zabbix1.png
          42 kB
        5. zabbix2.png
          zabbix2.png
          71 kB
        6. zabbix3.png
          zabbix3.png
          28 kB

            abiba Andrew Biba
            sysadm.es Victor
            Team INT
            Votes:
            2 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated: