Ad Widget

Collapse

Unable to get MSSQL latest log backup time

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sepjoo
    Junior Member
    • Jan 2023
    • 1

    #1

    Unable to get MSSQL latest log backup time

    Hello

    I have issue with zabbix MSSQL template
    Zabbix version is 6.0 latest
    MSSQL template is latest 6.0 version also
    I can get most of data but the main thing i need to monitor is last log backup and i can't get data about that.


    Template finds databases nicely and is working okay but item Last log backup isn't working.
    DNS and INSTANCE macros with username and password are working fine.

    It recives right db name also.
    Only error i can see is under preprocessing

    cannot extract value from json by path "$[?(@.dbname=='{#DBNAME}' && @.type=='L')].timesincelastbackup.first()": invalid object format, expected opening character '{' or '[' at: ''


Working...