获取指定KEY值的历史数据

#!/usr/bin/python
# encoding: utf-8
#filename: history_get.py
#author: gaohaixiang
#writetime:20190713

import zabbix_base_api  # zabbix-API-自定义库
import time

z_api_con = zabbix_base_api.zabbix_base_api(url='http://192.168.73.9/api_jsonrpc.php')

def getHostid(method,ip,authid):
    data = {
        "output": ["hostid", "host"],
        "filter": {
            "ip": ip
        },
        "selectInterfaces": ["ip"],
        "selectParentTemplates": ["name"]
    }
    responses = z_api_con.json_data(method, data, authid)
    return responses

def ItemGet(method,hostid,authid):
    data = {
        "output": "extend",
        "hostids": hostid,
        "search": {"application": "10269"},
        "sortfield": "name"
    }
    responses = z_api_con.json_data(method, data, authid)
    return responses

#历史数据获取，若获取某段时间的数据，请参考zabbix官方API
def HistoryGet(method,itemid,authid):
    data = {
        "output": "extend",
        "history": 3,       #0--3，数据的类型，0代表浮点数，3代表整数
        "itemids": itemid,
        "sortfield": "clock",
        "sortorder": "DESC",
        "limit": 1          #最近的一个值，可以调整，比如把1改为10，就是获取最近10个值，

    }
    responses = z_api_con.json_data(method, data, authid)
    return responses

def main_all(authid):
    file = open("iplist.txt", "r") #打开ip那个文件
    lists = file.readlines()
    for list in lists:
        ip = list.strip("\n")   #换行
        hostid_result = getHostid("host.get", ip, authid)["result"]
        ff = open("history-get.txt", "a+")
        if hostid_result:
            for host in hostid_result:
                hostid = host["hostid"]
                itemget = ItemGet("item.get",hostid,authid)["result"]
                for item in itemget:
                    itemid = item["itemid"]
                    itemkey = item["key_"]

                    keys = ["system.cpu.util[,idle,avg5]","system.cpu.util[,iowait,avg5]","system.cpu.util[,system,avg5]","system.cpu.util[,user,avg5]","cpu_use_ag","system.cpu.num","system.cpu.load[all,avg5]","system.cpu.load[percpu,avg5]","system.cpu.load[all,avg15]","system.cpu.load[percpu,avg15]"]

                    if itemkey in keys:
                        histtoryget = HistoryGet("history.get",itemid,authid)["result"]
                        if histtoryget:
                            for shuju in histtoryget:
                                #将时间戳转换为指定格式的时间,得到的clock是str格式，用int转换成数字
                                timestamp = int(shuju["clock"])
                                timelocal = time.localtime(timestamp)
                                date = time.strftime("%Y-%m-%d %H:%M:%S", timelocal)
                                print (ip+"\t"+itemkey+"\t"+shuju["value"]+"\t"+date+"\n")
                                ff.writelines(ip+"\t"+itemkey+"\t"+shuju["value"]+"\t"+date+"\n")
                        else:
                            print (ip+"\t"+itemkey+"\n")
                            ff.writelines(ip+"\t"+itemkey+"\n")

        ff.close()
    file.close()

if __name__ == "__main__":
    starttime = time.time()
    print ("Process is running...")
    authid = z_api_con.authid('gaohaixiang', 'gaohaixiang')
    main_all(authid)
    z_api_con.login_out(authid)
    endtime = time.time()
    print (endtime-starttime)