调用API去获取zabbix-item监控项的各个值

使用python去调用zabbix API去获取item监控项各个值

测试环境 centos8 python3.6.8

需要用到的库 requests pandas xlrd==1.2.0

在使用脚本前，请提前下载好对应的库

时间是获取最近两个小时，需要修改的话，请在下面代码修改

时间代码

#修改minutes=120该值即可
x = (datetime.datetime.now() - datetime.timedelta(minutes=120)).strftime("%Y-%m-%d %H:%M:%S")
y = (datetime.datetime.now()).strftime("%Y-%m-%d %H:%M:%S")

获取指定监控项的值

def gethist_net(hostid, auth, timestamp):
    list_itemid = []
    item1 = []
    #主要修改的是在这个列表里面的指定名称，添加和修改，把列表里面的删减或者新增即可
    for j in ['net.if.in','net.if.in','system.cpu.util','icmppingsec']:
        data = {
            "jsonrpc": "2.0",
            "method": "item.get",
            "params": {
                "output": [
                    "extend",
                ],
                "search": {
                    "key_": j
                },
                "hostids": hostid
            },
            "auth": auth,
            "id": 1
        }

修改对应的名称就是获取对应的值

获取对应数值

主要是在这段代码直接修改

    for itemid in list_itemid:
        trendata = {
            "jsonrpc": "2.0",
            "method": "trend.get",
            "params": {
                "output": [
                    "itemid",
                    'value',
                    "clock",
                    "num",
                    "value_max",
                    "value_avg",
                    "value_min",
                ],
                "time_from": timestamp[0],
                "time_till": timestamp[1],
                "itemids": '%s' %(itemid),
                "limit": 1
            },
            "auth": auth,
            "id": 1
        }
        gettrend = requests.post(url=ApiUrl, headers=header, json=trendata)
        trend = json.loads(gettrend.content)['result']
        if len(trend) > 0:
            item1.append(trend)
    list_max = []
    list_min = []
    list_avg = []
    for i in item1:
        #获取最大值
        list_max.append(i[0]['value_max'])
        #获取最小值
        list_min.append(i[0]['value_min'])
        #获取平均值
        list_avg.append(i[0]['value_avg'])

获取指定主机的数据

if __name__ == '__main__':
    token = gettoken()
    timestamp = timestamp(x, y)
    #在name这个列表添加对应的主机名称，增加修改，也是在这里添加
    name = ['G39092-04217-ShH','G39092-10096-ShH','20105_38721-02_GuZ']
    sum_list_min = []
    sum_list_avg = []
    sum_list_max = []
    sum_name = []
    sum_ip = []
    for n in name:
        hostid,name,ip = get_hosts(n, token)
        sum_name.append(name)
        sum_ip.append(ip)
        list_max, list_min, list_avg = gethist_net(hostid, token, timestamp)
        sum_list_min.append(list_min)
        sum_list_avg.append(list_avg)
        sum_list_max.append(list_max)

    writeexcel(sum_name,sum_ip,sum_list_min,sum_list_avg,sum_list_max)
    logout(token)

整个代码

# coding=utf-8
import requests, json, csv, codecs, datetime, time
import pandas as pd

ApiUrl = 'http://xxx.xxx.xxx.xxx/zabbix/api_jsonrpc.php'
header = {"Content-Type": "application/json"}
user = "Admin"
password = "zabbix"
x = (datetime.datetime.now() - datetime.timedelta(minutes=120)).strftime("%Y-%m-%d %H:%M:%S")
y = (datetime.datetime.now()).strftime("%Y-%m-%d %H:%M:%S")


def gettoken():
    data = {"jsonrpc": "2.0",
            "method": "user.login",
            "params": {
                "user": user,
                "password": password
            },
            "id": 1,
            "auth": None
            }
    auth = requests.post(url=ApiUrl, headers=header, json=data)
    return json.loads(auth.content)['result']


def timestamp(x, y):
    p = time.strptime(x, "%Y-%m-%d %H:%M:%S")
    starttime = str(int(time.mktime(p)))
    q = time.strptime(y, "%Y-%m-%d %H:%M:%S")
    endtime = str(int(time.mktime(q)))
    return starttime, endtime


def logout(auth):
    data = {
        "jsonrpc": "2.0",
        "method": "user.logout",
        "params": [],
        "id": 1,
        "auth": auth
    }
    auth = requests.post(url=ApiUrl, headers=header, json=data)
    return json.loads(auth.content)


def get_group_hosts(groupids,auth):
    data ={
            "jsonrpc": "2.0",
             "method": "host.get",
             "params": {
             "output": ["name"],
             "groupids": groupids,
             "filter":{
                 "status": "0"
             },
             "selectInterfaces": [
                        "ip"
                    ],
            },
            "auth": auth,  # theauth id is what auth script returns, remeber it is string
            "id": 1
        }
    gethost=requests.post(url=ApiUrl,headers=header,json=data)
    result = json.loads(gethost.content)["result"]
    host_name = []
    for r in result:
        name = r['name']
        host_name.append(name)
    return host_name

def get_hosts(hostname,auth):
    data = {
        "jsonrpc": "2.0",
        "method": "host.get",
        "params": {
            "output": ["name"],
            "filter": {
                "host": hostname
            },
            "selectInterfaces": [
                "ip"
            ],
        },
        "auth": auth,  # theauth id is what auth script returns, remeber it is string
        "id": 1
    }
    gethost = requests.post(url=ApiUrl, headers=header, json=data)
    result = json.loads(gethost.content)['result']
    try:
        hostid = result[0]['hostid']
    except:
        hostid = ''
    try:
        name = result[0]['name']

    except:
        name = ''
    try:
        ip = result[0]['interfaces'][0]['ip']
    except:
        ip = ''
    return hostid,name,ip



def gethist_net(hostid, auth, timestamp):
    list_itemid = []
    item1 = []
    for j in ['net.if.in','net.if.in','system.cpu.util','icmppingsec']:
        data = {
            "jsonrpc": "2.0",
            "method": "item.get",
            "params": {
                "output": [
                    "extend",
                ],
                "search": {
                    "key_": j
                },
                "hostids": hostid
            },
            "auth": auth,
            "id": 1
        }
        getitem = requests.post(url=ApiUrl, headers=header, json=data)
        item = json.loads(getitem.content)['result']
        if len(item) > 0:
            list_itemid.append(item[0]['itemid'])
    for itemid in list_itemid:
        trendata = {
            "jsonrpc": "2.0",
            "method": "trend.get",
            "params": {
                "output": [
                    "itemid",
                    'value',
                    "clock",
                    "num",
                    "value_max",
                    "value_avg",
                    "value_min",
                ],
                "time_from": timestamp[0],
                "time_till": timestamp[1],
                "itemids": '%s' %(itemid),
                "limit": 1
            },
            "auth": auth,
            "id": 1
        }
        gettrend = requests.post(url=ApiUrl, headers=header, json=trendata)
        trend = json.loads(gettrend.content)['result']
        if len(trend) > 0:
            item1.append(trend)
    list_max = []
    list_min = []
    list_avg = []
    for i in item1:
        list_max.append(i[0]['value_max'])
        list_min.append(i[0]['value_min'])
        list_avg.append(i[0]['value_avg'])

    return list_max,list_min,list_avg




def writeexcel(name,ip,list_min,list_avg,list_max):
    df = pd.DataFrame()
    df['主机名'] = [str(n) for n in name]
    df['IP地址'] = [str(i) for i in ip]

    try:
        df['in的最小值'] = [min[0] for min in list_min]
    except:
        df['in的最小值'] = ['无']
    try:
        df['in的最大值'] = [max[0] for max in list_max]
    except:
        df['in的最大值'] = ['无']
    try:
        df['in的均值'] = [avg[0] for avg in list_avg]
    except:
        df['in的均值'] = ['无']
    try:
        df['out的最小值'] = [min[1] for min in list_min]
    except:
        df['out的最小值'] = ['无']
    try:
        df['out的最大值'] = [max[1] for max in list_max]
    except:
        df['out的最大值'] = ['无']
    try:
        df['out的均值'] = [avg[1] for avg in list_avg]
    except:
        df['out的均值'] = ['无']
    try:
        df['cpu使用率的最小值'] = ['{}%'.format(min[2]) for min in list_min]
    except:
        df['cpu使用率的最小值'] = ['无']
    try:
        df['cpu使用率的最大值'] = ['{}%'.format(max[2]) for max in list_max]
    except:
        df['cpu使用率的最大值'] = ['无']
    try:
        df['cpu使用率的均值'] = ['{}%'.format(avg[2]) for avg in list_avg]
    except:
        df['cpu使用率的均值'] = ['无']
    try:
        df['ping连接时间的最小值'] = ['{:.3}毫秒'.format(eval(min[3]) * 60 * 60) for min in list_min]
    except:
        df['ping连接时间的最小值'] = ['无']
    try:
        df['ping连接时间的最大值'] = ['{:.3}毫秒'.format(eval(max[3]) * 60 * 60) for max in list_max]
    except:
        df['ping连接时间的最大值'] = ['无']
    try:
        df['ping连接时间的均值'] = ['{:.3}毫秒'.format(eval(avg[3]) * 60 * 60) for avg in list_avg]
    except:
        df['ping连接时间的均值'] = ['无']
    cols = ['主机名','IP地址','in的最小值','in的最大值','in的均值','out的最小值','out的最大值','out的均值','cpu使用率的最小值','cpu使用率的最大值','cpu使用率的均值','ping连接时间的最小值','ping连接时间的最大值','ping连接时间的均值']
    try:
        df.to_csv("zabbix监控项内容.csv", mode="w", header=True,index=False, encoding="gbk")
        print("写入成功")
    except Exception as e:
        print(e)
        print('写入失败')




if __name__ == '__main__':
    token = gettoken()
    timestamp = timestamp(x, y)
    name = ['host.name','host.name','host.name']
    sum_list_min = []
    sum_list_avg = []
    sum_list_max = []
    sum_name = []
    sum_ip = []
    for n in name:
        hostid,name,ip = get_hosts(n, token)
        sum_name.append(name)
        sum_ip.append(ip)
        list_max, list_min, list_avg = gethist_net(hostid, token, timestamp)
        sum_list_min.append(list_min)
        sum_list_avg.append(list_avg)
        sum_list_max.append(list_max)

    writeexcel(sum_name,sum_ip,sum_list_min,sum_list_avg,sum_list_max)
    logout(token)