api查询所有记录 zabbix_利用zabbix—API查询zabbix监控项历史数据、均值、峰值详细讲解...

前言：

查询监控项历史数据，最常见的办法就是在页面查询，但是页面只能展现最近的500个数值，如果要查询历史数据比较久远或要形成数据表格进行分析，这个办法就不适用了，但是利用zabbix—API查询zabbix监控项历史数据就可以满足这一需求，只需要指定查询的起止时间及监控项，就能以数据的形式进行输出，便于业务侧分析此期间的性能指标是否正常

具体脚本讲解如下：

#coding:utf-8

#给定主机IP获取一段时间内cpu的均值和峰值并写入文件(txt，可以跑完后直接把后缀名改为csv以表格形式打开)；需要指定IP文件

import requests

import json

import csv

import time

def get_token():

data = {

"jsonrpc": "2.0",

"method": "user.login",

"params": {

"user": username,

"password": password

},

"id": 0

}

r = requests.get(zaurl, headers=header, data=json.dumps(data))

auth = json.loads(r.text)

return auth["result"]

def item_get(token, host, itemkey):

data = {

"jsonrpc": "2.0",

"method": "item.get",

"params": {

"host": host,

"search": {

"key_": itemkey

},

},

"auth": token,

"id": 1

}

request = requests.post(zaurl, data=json.dumps(data), headers=header)

dict = json.loads(request.content)

# print(dict)

return dict['result'][0]['itemid']

def getdata(token,itemid, start, stop):

data = {

"jsonrpc": "2.0",

"method": "history.get",

"params": {

"output": "extend",

"itemids": itemid,

"history": 0,

"time_from":start,

"time_till":stop

},

"id": 2,

"auth": token,

}

request = requests.post(zaurl, headers=header, data=json.dumps(data))

dict = json.loads(request.content)

print(dict)

return dict['result']

def timecovert(stringtime):

timeArray = time.strptime(stringtime, "%Y-%m-%d %H:%M:%S")

timeStamp = int(time.mktime(timeArray))

return timeStamp

if __name__ == "__main__":

zaurl = "http://IP/api_jsonrpc.php" # 访问zabbix页面的url

header = {"Content-Type": "application/json"}

username = "xxx" #zabbix的账户与密码

password = "xxx"

hostfile="ip.txt"

token = get_token()

starttime = "2020-05-24 11:30:00" #查询历史数据的起止时间

stoptime = "2020-05-24 12:30:00"

start = timecovert(starttime)

stop = timecovert(stoptime)

#生成一个txt文件

datafile = "/home/dwchenrongbin/linfan/data.txt"

fdata = open(datafile,'w')

with open(hostfile, "r") as f:

f1 = f.readlines()

for ips in f1:

host = ips.replace('\n', '').strip()

# 修改参数

#以下例子为cpu

itemkey = ["cpu_use_ag"] #要查询监控项的KEY值

itemid = item_get(token, host, itemkey)

data = getdata(token,itemid,start,stop)

if data:

valuelist = []

for i in data:

valuelist.append(float(i["value"]))

avge = sum(valuelist)/len(valuelist) #查询周期内的平均值

max1 = max(valuelist) #查询周期内的最大值

fdata.write(host + ',' + str(round(avge,2)) + ',' + str(round(max1,2)) + '\n')

print (host, avge, max1,valuelist) #打印出 主机名、平均值、最大值、历史数据

else:

print (host)

fdata.close()

以下是我根据脚本输出整理的Excel表历史数据(IP已被我过滤掉)