$ cat transformation.py
#!/usr/bin/python
# -*- coding: UTF-8 -*-
import xlwt
import datetime
#import sendmail
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.header import Header
#每天的几点发送邮件及附件加时间戳
now = datetime.datetime.now().strftime('%Y-%m-%d-%H') 
mail_host="smtp.mxhichina.com"  #设置服务器
mail_user="louis@wangke.co"    #用户名
mail_pass="123456"   #口令
style = "font:colour_index red; align: wrap on, vert centre, horiz center;"
styleb = xlwt.XFStyle()  # 创建一个样式对象，初始化样式
al = xlwt.Alignment()
al.horz = 0x02      # 设置水平居中
al.vert = 0x01      # 设置垂直居中
styleb.alignment = al
red_style = xlwt.easyxf(style)
title_style = xlwt.easyxf('font: height 200, name Arial Black, colour_index blue, bold on; align: wrap on, vert centre, horiz center;' )
def getlist():  # 读取txt
    with open('hebing.txt', 'r+',encoding='utf-8') as f:
        s1 = f.readlines()
    f.close()
    s2 = []
    for i in s1:
            if '\n' in i:
                    s2.append(i[:-1])
            else:
                    s2.append(i)
    return s2
def fenge():  # 分割
    list0 = []  # 存贮空格行
    for num, val0 in enumerate(getlist()):
        if val0.split(':')[0] == '主机名':
            list0.append(num)
    list0.append(len(getlist()))
    list1 = []   # 存贮内容
    for num1,val1 in enumerate(list0[1:]):
        temp = getlist()[list0[num1]:list0[num1+1]]
        list1.append(temp)
    return list1
def wxls():   # 写入表格
    title = ['主机名','服务器IP','分区','总空间','使用空间','剩余空间','磁盘使用率','磁盘巡检状态','总内存大小',
    '已用内存','内存剩余大小','内存使用率','内存巡检结果','平均1分钟负载','平均5分钟负载','平均15分钟', 'ceshi']
    workbook = xlwt.Workbook(encoding='utf-8')
    worksheet = workbook.add_sheet('sheet1')
    for i1, val in enumerate(title):
        worksheet.write(0, i1, label=val,style = title_style)
        first_col = worksheet.col(i1)
        first_col.width = 180 * 20
    for i2, val2 in enumerate(title):
        for i3, val3 in enumerate(fenge()):
            for j in val3:
                if j.split(':')[0] == val2:
                    #print i2,i3,j.split(':')[1].decode('utf8')
                    if j.split(':')[1] == '不正常':
                        worksheet.write(i3 + 1, i2, label=j.split(':')[1],style=red_style)
                    else:
                        worksheet.write(i3+1, i2, label=j.split(':')[1] ,style = styleb)
    name = now + 'miontior.xls'
    workbook.save(name)


def send_mail(): 
    sender = 'louis@wangke.co'
    receivers = ['louis@wangke.co']  # 接收邮件，可设置为你的QQ邮箱或者其他邮箱
     
    #创建一个带附件的实例
    message = MIMEMultipart()
    message['From'] = Header("louis@wangke.co", 'utf-8')
    message['To'] =  Header("louis@wangke.co", 'utf-8')
    subject = now+'服务器巡检表格'
    message['Subject'] = Header(subject, 'utf-8')
     
    #邮件正文内容
    message.attach(MIMEText('各位好: \n' + now + ': 生产环境各服务器状态见附件.', 'plain', 'utf-8'))
     
    # 构造附件1，传送当前目录下的 test.txt 文件
    att1 = MIMEText(open(now + 'miontior.xls', 'rb').read(), 'base64', 'utf-8')
    att1["Content-Type"] = 'application/octet-stream'
    # 这里的filename可以任意写，写什么名字，邮件中显示什么名字
    att1["Content-Disposition"] = 'attachment; filename="{}moniter.xls"'.format(now+'-')
    message.attach(att1)
     
    try:
        smtpObj = smtplib.SMTP_SSL(mail_host, 465)
        smtpObj.login(mail_user,mail_pass)
        smtpObj.sendmail(sender, receivers, message.as_string())
        print ("邮件发送成功")
    except smtplib.SMTPException:
        print ("Error: 无法发送邮件")

wxls()
send_mail()

$ cat manage.sh
#!/bin/bash
DATE=$(date +%F-%H:%M:%S)
source py3/bin/activate
echo "$DATE exec $0" >> manage.log 

## 所有主机执行a.sh, 即完成服务器巡检操作
ansible all -m script -a "/data/louis/a.sh"  >> manage.log

## 将所有主机的生成的txt文件同步到ansible管理的主机上
ansible all -m synchronize -a "src=/tmp/sftp/log/ dest=/data/louis mode=pull"  >> manage.log

## 生成主机合并的信息文件
> hebing.txt
## 遍历同步过来的主机巡检信息文件, 追加至文件
for file in `ls ./mo*.txt` ; do
	cat $file >> hebing.txt
done

## 将合并的信息转为xls文件

python3.4 transformation.py >> manage.log

## 将不需要的文件删掉并归档.
rm -f *.txt
mv *.xls server-monitor