2

Im working on a python script that does some analysis. This script uses the following zabbix api to get the last value of an item:

getlastvalue = {
   "jsonrpc":"2.0",
   "method":"item.get",
   "params":{
      "output":"extend",
      "hostids":"10084",
      "search":{
         "key_":"vfs.fs.size[/var/log,used]"
      },
      "sortfield":"name"
   },
   "auth":mytoken,
   "id":1
}

My script analyzes the response and produces this feedback:

LatestValue:499728384 LatestValueEpoch:1553573850 HowLongAgo:33secs ItemID:51150

Now, I wish to know what the value of the item was 24 hours ago...meaning 24 hours from the LatestValueEpoch time. This is where Im having an issue. I think I may not be using the right json. But here's what I've been using:

historyget = {
   "jsonrpc":"2.0",
   "method":"history.get",
   "params":{
      "output":[
         "itemid",
         "extend"
      ],
      "time_from":"",
      "time_to":"",
      "itemids":[
         "51150"
      ]
   },
   "auth":mytoken,
   "id":1
}

I replace the value of time_from and time_to in my script to reflect yesterday's time (24 hours ago exactly from the current time). But the response I get isnt what I want. What am i doing wrong here?

Duc Nguyen
  • 59
  • 6
Dev Ops
  • 127
  • 1
  • 10

1 Answers1

3

You have to use the history.get API call.

Using a combination of time_from, time_till and limit you should get an array of values or a single value accordingly.

Important: You have to specify the history parameter (History object types to return) in the history.get call: I usually make an item.get to catch the stuff I need, then an history.get.

A small python sample I wrote as a helper:

#!/usr/bin/env python
# -*- coding: utf-8 -*-

"""
Get history values for specific items in a time range:

# ./getItemHistoryByName.py -H some-host  -I "ICMP response time" -f "26/6/2018 16:00" -t "27/6/2018 23:59"
ItemID: 77013 - Item: ICMP response time - Key: icmppingsec
1530021641 26/06/2018 16:00:41 Value: 0.1042
1530021701 26/06/2018 16:01:41 Value: 0.0993
1530021762 26/06/2018 16:02:42 Value: 0.1024
1530021822 26/06/2018 16:03:42 Value: 0.0966
[cut]
"""

from zabbix.api import ZabbixAPI
import sys, argparse
import time
import datetime


zabbixServer    = 'http://yourserver/zabbix/'
zabbixUser      = 'someuser'
zabbixPass      = 'somepass'


def main(argv):
    parser = argparse.ArgumentParser()
    parser.add_argument('-H', required=True, metavar='Hostname')
    parser.add_argument('-I', required=True, metavar='Item Name')
    parser.add_argument('-f', required=True, metavar='From Timestamp')
    parser.add_argument('-t', required=True, metavar='Till Timestamp')

    args = parser.parse_args()


    zapi = ZabbixAPI(url=zabbixServer, user=zabbixUser, password=zabbixPass)

    fromTimestamp = time.mktime(datetime.datetime.strptime(args.f, "%d/%m/%Y %H:%M").timetuple())
    tillTimestamp = time.mktime(datetime.datetime.strptime(args.t, "%d/%m/%Y %H:%M").timetuple())


    f  = {  'name' : args.I  }
    items = zapi.item.get(filter=f, host=args.H, output='extend' )

    for item in items:
        print "ItemID: {} - Item: {} - Key: {}".format(item['itemid'], item['name'], item['key_'])

        values = zapi.history.get(itemids=item['itemid'], time_from=fromTimestamp, time_till=tillTimestamp, history=item['value_type'])

        for historyValue in values:
            currentDate = datetime.datetime.fromtimestamp(int(historyValue['clock'])).strftime('%d/%m/%Y %H:%M:%S')

            print "{} {} Value: {}".format(historyValue['clock'], currentDate, historyValue['value'])

if __name__ == "__main__":
   main(sys.argv[1:])
Simone Zabberoni
  • 2,024
  • 1
  • 10
  • 15