[办公软件] zabbix企业应用之定时获取监控数据做报表

#!/usr/bin/env pythoncoding=utf-8Author: DengleiEmail: dl528888@gmail.comQQ: 244979152
import MySQLdb
import datetime
import xlwt
import sys
from email.mime.multipart import MIMEMultipart
from email.mime.base import MIMEBase
from email.mime.text import MIMEText
from email.utils import COMMASPACE,formatdate
from email import encoders
import os
def send_mail(server, fro, to, subject, text, files=[]):
assert type(server) == dict
assert type(to) == list
assert type(files) == list
msg = MIMEMultipart()
msg['From'] = fro
msg['Subject'] = subject
msg['To'] = COMMASPACE.join(to) #COMMASPACE==', '
msg['Date'] = formatdate(localtime=True)
msg.attach(MIMEText(text))
for f in files:
    part = MIMEBase('application', 'octet-stream') #'octet-stream': binary data
    part.set_payload(open(f, 'rb').read())
    encoders.encode_base64(part)
    part.add_header('Content-Disposition', 'p_w_upload; filename="%s"' % os.path.basename(f))
    msg.attach(part)

for i in range(0,count):
      if i == 0:
  #ws.write(i,j,title[j].decode('utf8'))
        value=x[0]
      else:
        value=x[i]
    if isinstance(value[j],long) or isinstance(value[j],int) or isinstance(value[j],float):
  ws.write(i,j,value[j])
    else:
        ws.write(i,j,value[j].decode('utf8'))
  #wb.save('/tmp/zabbix_log/chance_zabbix_monitor_test.xls')

for ii in cpu_idle_result:
    if i[0] ==ii[0] and i[1] == ii[1] and i[2] == ii[2]:
  i[3]=int(i[3])
  #msg.append([i[0],i[1],i[2],int(i[3]),ii[3]])
  i.append(int(ii[3]))

i.append(int(iiii[3]))

if len(i) == 7:
    i.append(0)

start_time=((datetime.datetime.now() - datetime.timedelta(days = i))).strftime("%Y-%m-%d")
    end_time=((datetime.datetime.now() - datetime.timedelta(days = i-1))).strftime("%Y-%m-%d")

reload(sys)
    sys.setdefaultencoding(default_encoding)
  if os.path.exists("/tmp/zabbix_log/") is False:
    os.mkdir("/tmp/zabbix_log/")
  conn=MySQLdb.connect(host='10.10.14.19',user='zabbix',passwd='zabbix',port=3306,charset="utf8")
  cur=conn.cursor()
  conn.select_db('zabbix')
  wb = xlwt.Workbook()
  main()
  wb.save('/tmp/zabbix_log/chance_zabbix_monitor_hour_avg.xls')
  cur.close()
  conn.close()
  #follow is send mail
  server = {'name':'smtp.163.com', 'user':'ops_monitor', 'passwd':'xxxx', 'port':25}
  fro = 'xxx@163.com'
  to = ['xx@xx.com','244979152@qq.com']
  now_time=((datetime.datetime.now() - datetime.timedelta(days = 1))).strftime("%Y/%m/%d")
  last_time=((datetime.datetime.now() - datetime.timedelta(days = 7))).strftime("%Y/%m/%d")
  subject = 'xx平台监控数据【%s-%s】'%(last_time,now_time)
  text = 'xx你好,附件是畅思平台最近一周每天20至24点平均值监控数据，请查收!\n有问题请联系邓磊.'
  files = ['/tmp/zabbix_log/chance_zabbix_monitor_hour_avg.xls']

00 14   5 /usr/bin/python /data/software/zabbix_hour_avg_monitor.py