python 实现zabbix自动发送报表

上山打老虎

　　实现将zabbix中的screens中的图片以邮件的方式发送到管理员邮箱大家都知道zabbix的screens一般是定义管理员比较关注的监控指标好方便浏览,那么我们就根据管理员自定义的screens name获取相关图信息的.
简介首先我们来看下图片的url (右击screens中随便一张图片,选复制图片地址)

http://zabbix.xxx.com/chart2.php?graphid=524&screenid=16&width=400&height=156&updateProfile=1&profileIdx=web.screens&profileIdx2=16&period=86400&stime=20150629172712&sid=f6dd0d127bba0123&curtime=1404120808037

可以看到上面的url后面有很多的参数,当然我们需要的没有那么多,简化后的url如下

http://zabbix.xxx.com/chart2.php?graphid=524&screenid=16&width=400&height=156&period=86400

简化后我们只需要5个参数

graphid   # 图片的ID,对应的值为某一个graph的唯一标识
screenid  # screenID,对应的值为某一个screen的唯一标识
width     # 图片的宽度,对应的值为图片的宽度(可根据需要自己定义)
height    # 图片的高度,对应的值为图片的高度(可根据需要自己定义)
period    # 图片展示数据的时钟周期 单位为 秒 (86400 =1天)

通过上面的信息我们知道要通过zabbix获取screen中的图片需要的参数下面我们需要做的就是通过screen name到数据库中查询相关参数即可1、根据管理员自定义的screens name在数据库中查询此screen的ID (screens 表)2、根据所查到的screenID查询此screen中所包含的resourceid (resourceid==graphid)(screens_items 表)3、通过1、2两步查到的参数获取图片并保存至zabbix服务器上的web目录并生成html代码4、通过smtplib模块把html代码发送到管理员邮箱
大概的流程是这样的,代码如下,代码中所涉及的参数变量根据自己的环境做出相应的配置即可

cat zabbix_send_report.py

#! /usr/bin/env pythoncoding=utf-8Andy_f
import time,os
import urllib
import urllib2
import cookielib
import MySQLdb
import smtplib
from email.mime.text import MIMEText
screens = ["xxx","xxx"]save_graph_path = "/var/www/zabbix/reports/%s"%time.strftime("%Y-%m-%d")
if not os.path.exists(save_graph_path):
  os.makedirs(save_graph_path)zabbix host
zabbix_host = "zabbix.xxx.com"zabbix login username
username = "admin"zabbix login password
password = "zabbix"graph width
width = 600graph height
height = 100graph Time period, s
period = 86400zabbix DB
dbhost = "xxx.xxx.xxx.xxx"
dbport = 3306
dbuser = "zabbix"
dbpasswd = "xxxxx"
dbname = "zabbix"mail
to_list = ["xxx@xxx.com","aaa@xxx.com"]
smtp_server = "smtp.163.com"
mail_user = "xxxx"
mail_pass = "xxxxx"
domain  = "163.com"
def mysql_query(sql):
try:
    conn = MySQLdb.connect(host=dbhost,user=dbuser,passwd=dbpasswd,port=dbport,connect_timeout=20)
    conn.select_db(dbname)
    cur = conn.cursor()
    count = cur.execute(sql)
    if count == 0:
      result = 0
    else:
      result = cur.fetchall()
    return result
    cur.close()
    conn.close()
  except MySQLdb.Error,e:
    print "mysql error:" ,e

　　def get_graph(zabbix_host,username,password,screen,width,height,period,save_graph_path):
　　screenid_list = []
　　global html
　　html = ''
　　for i in mysql_query("select screenid from screens where name='%s'"%(screen)):

for screenid in i:
          graphid_list = []
          for c in mysql_query("select resourceid from screens_items where screenid='%s'"%(int(screenid))):
            for d in c:
              graphid_list.append(int(d))
          for graphid in graphid_list:
            login_opt = urllib.urlencode({
            "name": username,
            "password": password,
            "autologin": 1,
            "enter": "Sign in"})
            get_graph_opt = urllib.urlencode({
            "graphid": graphid,
            "screenid": screenid,
            "width": width,
            "height": height,
            "period": period})
            cj = cookielib.CookieJar()
            opener = urllib2.build_opener(urllib2.HTTPCookieProcessor(cj))
            login_url = r"http://%s/index.php"%zabbix_host
            save_graph_url = r"http://%s/chart2.php"%zabbix_host
            opener.open(login_url,login_opt).read()
            data = opener.open(save_graph_url,get_graph_opt).read()
            filename = "%s/%s.%s.png"%(save_graph_path,screenid,graphid)
            html += '<img width="600" height="250" src="http://%s/%s/%s/%s.%s.png">'%(zabbix_host,save_graph_path.split("/")[len(save_graph_path.split("/"))-2],save_graph_path.split("/")[len(save_graph_path.split("/"))-1],screenid,graphid)
            f = open(filename,"wb")
            f.write(data)
            f.close()

　　def send_mail(username,password,smtp_server,to_list,sub,content):
　　print to_list
　　me = "运维"+"<"+username+"@"+domain +">"
　　msg = MIMEText(content,_subtype="html",_charset="utf8")
　　msg["Subject"] = sub
　　msg["From"] = me
　　msg["To"] = ";".join(to_list)
　　try:

server = smtplib.SMTP()
    server.connect(smtp_server)
    server.login(username,password)
    server.sendmail(me,to_list,msg.as_string())
    server.close()
    print "send mail Ok!"
  except Exception, e:
    print e

　　if __name__ == '__main__':
　　for screen in screens:

get_graph(zabbix_host,username,password,screen,width,height,period,save_graph_path)
  send_mail(mail_user,mail_pass,smtp_server,to_list,"test email",html)</pre><br />设置crontab 每天早上上班前执行一次<pre class="brush:bash;toolbar:false">crontab -e

45 08  * python /root/zabbix_send_report.py
上效果图