Ad Widget

Collapse

MSSQL2019 on Zabbix version 5.2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Arul
    Junior Member
    • May 2020
    • 23

    #1

    MSSQL2019 on Zabbix version 5.2

    Hi all,

    Configuring MSSQL2019 on Zabbix version 5.2. Can connect by "isql" by driver: "libmsodbcsql-17.7.so.2.1".

    On frontend configured with template "MSSQL by ODBC", getting the following error on item:

    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=='SQLEXPRESS:SQL Statistics' && @.counter_name=='Unsafe Auto-Params/sec')].cntr_value.first()": no data matches the specified path


    Any idea, how to overcome it?
  • Arul
    Junior Member
    • May 2020
    • 23

    #2
    configured all macros. Getting value for ping, uptime, and version

    Comment

    • Arul
      Junior Member
      • May 2020
      • 23

      #3
      Resolved. Followed https://support.zabbix.com/projects/...sues/ZBX-18554

      Comment

      Working...