1、基本信息
我公司之前采用的是人工巡检，但奈何有大量网络设备，往往巡检需要花掉一上午（还是手速快的话）,浪费时间浪费生命。
这段时间正好在学 Python ，于是乎想(其)要(实)解(就)放(是)双(懒)手。
好了，脚本很长又比较挫，有耐心就看看吧。
需要巡检的设备如下：
设备清单 | 设备型号 |
防火墙 | 华为 E8000E |
H3C M9006 | |
飞塔 FG3950B | |
交换机 | 华为 S9306 |
H3C S12508 | |
Cisco N7K | |
路由器 | 华为 NE40E |
负载 | Radware RD5412 |
Radware RD20 |
2、采集数据并写入文件
# 相关设备巡检命令就不介绍了。。
01DMZ-E8000E.py # 华为 E8000E 交互脚本
#!/usr/bin/env python
import pexpect
import sys
import datetime
d1=datetime.datetime.now()
d3=d1+datetime.timedelta(days=-1)
tdy=d3.strftime('%b %d')
today=datetime.date.today().strftime('%Y%m%d')
tt=tdy.split()
if int(tt[-1]) < 10:
tdy=tdy.replace('0',' ')
ip=str(sys.argv[1])
passwd=str(sys.argv[2])
password=str(sys.argv[3])
child=pexpect.spawn('ssh 用户名@%s'%ip)
fout=file('/usr/sh/shell/linux/xunjian/'+today+'/01DMZ-E8000E.txt','w')
child.logfile = fout
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
child.expect('(?i)E8000E-1>')
child.sendline("su")
child.expect("(?i)assword:")
child.sendline("%s"%password)
child.expect("(?i)E8000E-1>")
child.sendline("dis device | ex Normal")
child.expect("(?i)E8000E-1>")
child.sendline("dis version")
index = child.expect(["(?i)---- More ----","(?i)E8000E-1>"])
if ( index == 0 ):
child.send("a")
child.expect("(?i)E8000E-1>")
child.sendline("dis temperature")
child.expect("(?i)E8000E-1>")
child.sendline("dir")
index = child.expect(["(?i)---- More ----","(?i)E8000E-1>"])
if ( index == 0 ):
child.send("a")
child.expect("(?i)E8000E-1>")
child.sendline("dis memory-usage")
child.expect("(?i)E8000E-1>")
child.sendline("dis hrp state")
child.expect("(?i)E8000E-1>")
child.sendline("dis firewall session table")
index = child.expect(["(?i)---- More ----","(?i)E8000E-1>"])
if ( index == 0 ):
child.send("a")
child.expect("(?i)E8000E-1>")
child.sendline("dis ip routing-table protocol static")
child.expect("(?i)E8000E-1>")
child.sendline("dis int brief | in up")
child.expect("(?i)E8000E-1>")
child.sendline("dis acl 3004")
index = child.expect(["(?i)---- More ----","(?i)E8000E-1>"])
if ( index == 0 ):
child.send("a")
child.expect("(?i)E8000E-1>")
child.sendline("dis acl 3005")
index = child.expect(["(?i)---- More ----","(?i)E8000E-1>"])
if ( index == 0 ):
child.send("a")
child.expect("(?i)E8000E-1>")
child.sendline("dis acl 3006")
index = child.expect(["(?i)---- More ----","(?i)E8000E-1>"])
if ( index == 0 ):
child.send("a")
child.expect("(?i)E8000E-1>")
child.sendline("dis acl 3007")
index = child.expect(["(?i)---- More ----","(?i)E8000E-1>"])
if ( index == 0 ):
child.send("a")
child.expect("(?i)E8000E-1>")
child.sendline("dis alarm all")
child.expect("(?i)E8000E-1>")
child.sendline("dis logbuffer | in %s"%tdy)
for i in range(20):
index = child.expect(["(?i)---- More ----","(?i)E8000E-1>"])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("q")
break02_03-M9006.py # H3C M9006 交互脚本
#!/usr/bin/env python
import pexpect
import sys
import datetime
d1=datetime.datetime.now()
d3=d1+datetime.timedelta(days=-1)
tdy=d3.strftime('%b')
today=datetime.date.today().strftime('%Y%m%d')
ip=str(sys.argv[1])
passwd=str(sys.argv[2])
password=str(sys.argv[3])
if ip == '判断ip，手动打码':
txt='03SM-M9006.txt'
else:
txt='02DMZ-M9006.txt'
child=pexpect.spawn('ssh 用户名@%s'%ip)
fout=file('/usr/sh/shell/linux/xunjian/'+today+'/'+txt,'w')
child.logfile = fout
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
child.expect('(?i)M9006>')
child.sendline("su")
child.expect("(?i)assword:")
child.sendline("%s"%password)
child.expect("M9006>")
child.sendline("dis device | ex Normal")
child.expect("M9006>")
child.sendline("dis version | in uptime")
child.expect("M9006>")
child.sendline("dis environment")
for i in range(10):
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dir | in total")
break
child.expect("M9006>")
child.sendline("dis memory")
for i in range(10):
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis irf link")
break
child.expect("M9006>")
child.sendline("dis redundancy group")
child.expect("---- More ----")
child.send('a')
child.expect("M9006>")
child.sendline("dis session statistics summary")
child.expect("M9006>")
child.sendline("dis ip routing-table protocol static")
child.expect("M9006>")
child.sendline("dis int brief | in UP")
for i in range(10):
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
else:
break
if ip == '判断ip':
child.sendline("dis acl 3001")
for i in range(10):
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis acl 3002")
child.expect("M9006>")
child.sendline("dis alarm")
break
else:
child.sendline("dis object-policy ip")
for i in range(20):
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis alarm")
break
child.expect("M9006>")
child.sendline("dis logbuffer reverse | in %s"%tdy)
index = child.expect(["(?i)---- More ----","M9006>"]) 这边其实只要一个 for 循环就可以了，不高兴改了
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send("a")
index = child.expect(["(?i)---- More ----","M9006>"])
if ( index == 0 ):
child.send("a")
else:
child.sendline('')
child.expect("M9006>")
child.sendline("q")04IN-FG3950B.py # 飞塔 FG3950B 交互脚本
#!/usr/bin/env python
import pexpect
import sys
import datetime
today=datetime.date.today().strftime('%Y%m%d')
ip=str(sys.argv[1])
passwd=str(sys.argv[2])
child=pexpect.spawn('ssh 用户@%s'%ip)
fout=file('/usr/sh/shell/linux/xunjian/'+today+'/04IN-FG3950B.txt','w')
child.logfile = fout
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
child.expect('W-IN-FG3950-1 #')
child.sendline("get sys performance status")
for i in range(5):
index = child.expect(["(?i)--More--","W-IN-FG3950-1 #"])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("diagnose sys session stat")
break
child.expect('W-IN-FG3950-1 #')
child.sendline("get route info routing-table static")
child.expect('--More--')
child.send(' ')
child.expect('W-IN-FG3950-1 #')
child.sendline("exit")05_06DMZ-S9306.py # 华为 S9306 交互脚本
#!/usr/bin/env python
import pexpect
import sys
import datetime
d1=datetime.datetime.now()
d3=d1+datetime.timedelta(days=-1)
tdy=d3.strftime('%b %d')
today=datetime.date.today().strftime('%Y%m%d')
tt=tdy.split()
if int(tt[-1]) < 10:
tdy=tdy.replace('0',' ')
ip=str(sys.argv[1])
passwd=str(sys.argv[2])
password=str(sys.argv[3])
child=pexpect.spawn('ssh 用户名@%s'%ip)
if ip == '判断ip，不止一个该类型设备':
txt='05DMZ-S9306-1.txt'
else:
txt='06DMZ-S9306-2.txt'
fout=file('/usr/sh/shell/linux/xunjian/'+today+'/'+txt,'w')
child.logfile = fout
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
child.expect('<JSYD-WX-12580-DMZ-9306')
child.sendline("su")
child.expect("(?i)assword:")
child.sendline("%s"%password)
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis device")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis version | in Quidway")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dir")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis cpu-usage")
index = child.expect(["(?i)---- More ----","<JSYD-WX-12580-DMZ-9306(?i)"])
if ( index == 0 ):
child.send("a")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis memory-usage")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis int brief | in up")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis vrrp brief")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis mac-address total-number")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis arp statistics all")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis ip routing-table protocol static")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis temperature all")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis alarm all")
child.expect("<JSYD-WX-12580-DMZ-9306")
child.sendline("dis logbuffer | in %s"%tdy)
for i in range(50):
index = child.expect(["(?i)---- More ----","<JSYD-WX-12580-DMZ-9306(?i)"])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("q")
break07_08-S12508.py # H3C S12508 交互脚本
#!/usr/bin/env python
import pexpect
import sys
import datetime
d1=datetime.datetime.now()
d3=d1+datetime.timedelta(days=-1)
tdy=d3.strftime('%b %d')
today=datetime.date.today().strftime('%Y%m%d')
tt=tdy.split()
if int(tt[-1]) < 10:
tdy=tdy.replace('0',' ')
ip=str(sys.argv[1])
passwd=str(sys.argv[2])
password=str(sys.argv[3])
child=pexpect.spawn('ssh 用户名@%s'%ip)
IP=['ip1','ip2']
if ip == IP[0]:
txt='07DMZ-S12508.txt'
name='<W-DMZ-G1G2-12508>'
else:
txt='08IN-S12508.txt'
name='<W-IN-G7G8-12508>'
fout=file('/usr/sh/shell/linux/xunjian/'+today+'/'+txt,'w')
child.logfile = fout
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
child.expect("%s"%name)
child.sendline("su")
child.expect("(?i)assword:")
child.sendline("%s"%password)
child.expect("%s"%name)
child.sendline("dis device | ex Normal")
child.expect("%s"%name)
child.sendline("dis version | in H3C S12508")
child.expect("%s"%name)
child.sendline("dir")
child.expect("%s"%name)
child.sendline("dis memory")
child.expect("%s"%name)
child.sendline("dis irf link")
for i in range(10):
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis int brief | in UP")
break
for i in range(20):
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis mac-address count")
break
child.expect("%s"%name)
child.sendline("dis arp all count")
if ip == "手动打码":
child.expect("%s"%name)
child.sendline("dis ip routing-table -instance Dmz protocol static")
for i in range(20):
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis ip routing-table -instance Inside protocol static")
for i in range(20):
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline(" ")
break
break
child.expect("%s"%name)
child.sendline("dis environment")
for i in range(50):
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis alarm")
break
child.expect("%s"%name)
child.sendline("dis logbuffer | in %s"%tdy)
for i in range(50):
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("q")
sys.exit()09_10SM-N7K.py # Cisco N7K 交互脚本
#!/usr/bin/env python
import pexpect
import sys
import datetime
today=datetime.date.today().strftime('%Y%m%d')
ip=str(sys.argv[1])
passwd=str(sys.argv[2])
child=pexpect.spawn('telnet %s'%ip)
if ip == '是个ip':
txt='09SM-N7K-1.txt'
name='W-SM-N7K-1#'
else:
txt='10SM-N7K-2.txt'
name='W-SM-N7K-2#'
fout=file('/usr/sh/shell/linux/xunjian/'+today+'/'+txt,'w')
child.logfile = fout
child.expect('login:')
child.sendline("发送用户名")
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
child.expect("%s"%name)
child.sendline("sh hardware | in ok")
child.expect("%s"%name)
child.sendline("sh version | in uptime")
child.expect("%s"%name)
child.sendline("dir")
child.expect("%s"%name)
child.sendline("sh int brief | in up")
for i in range(10):
index = child.expect(["(?i)More--","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("sh hsrp brief")
break
child.expect("%s"%name)
child.sendline("sh mac address-table count")
child.expect("%s"%name)
child.sendline("sh ip arp | in number")
child.expect("%s"%name)
child.sendline("sh ip route static summary")
child.expect("%s"%name)
child.sendline("sh environment temperature")
for i in range(10):
index = child.expect(["(?i)More--","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("sh vpc")
break
for i in range(10):
index = child.expect(["(?i)More--","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("sh logging last 30")
break
for i in range(10):
index = child.expect(["(?i)More--","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("exit")
sys.exit()11_12DMZ-NE40E.py # 华为 NE40E 交互脚本
#!/usr/bin/env python
import pexpect
import sys
import datetime
d1=datetime.datetime.now()
d3=d1+datetime.timedelta(days=-1)
tdy=d3.strftime('%b %d')
today=datetime.date.today().strftime('%Y%m%d')
tt=tdy.split()
if int(tt[-1]) < 10:
tdy=tdy.replace('0',' ')
ip=str(sys.argv[1])
passwd=str(sys.argv[2])
child=pexpect.spawn('ssh 用户名@%s'%ip)
IP=['ip1','ip2']
if ip == IP[0]:
txt='11DMZ-NE40E-1.txt'
name='<W-SM-E11-NE40E-01>'
elif ip == IP[1]:
txt='12DMZ-NE40E-2.txt'
name='<W-SM-E12-NE40E-02>'
else:
print "IP Input Error!"
sys.exit()
fout=file('/usr/sh/shell/linux/xunjian/'+today+'/'+txt,'w')
child.logfile = fout
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
child.expect("(?i)N]:")
child.sendline("n")
child.expect("%s"%name)
child.sendline("dis device | ex Normal")
child.expect("%s"%name)
child.sendline("dis version | in NE40E-X8 uptime")
child.expect("%s"%name)
child.sendline("dir")
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis memory-usage")
else:
child.sendline("dis memory-usage")
child.expect("%s"%name)
child.sendline("dis int brief | in up")
child.expect("%s"%name)
child.sendline("dis ip routing-table protocol static")
child.expect("%s"%name)
child.sendline("dis temperature")
for i in range(40):
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("dis alarm all")
break
child.expect("%s"%name)
child.sendline("dis logbuffer | in %s"%tdy)
for i in range(30):
index = child.expect(["(?i)---- More ----","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("q")
break13_16-RD5412_20.py # Radware RD5412 交互脚本，只要掌握一个，其他都是套路
#!/usr/bin/env python
import pexpect
import sys
import datetime
d1=datetime.datetime.now()
d3=d1+datetime.timedelta(days=-1)
tdy=d3.strftime('%b %d')
today=datetime.date.today().strftime('%Y%m%d')
tt=tdy.split()
if int(tt[-1]) < 10:
tdy=tdy.replace('0',' ')
ip=str(sys.argv[1])
passwd=str(sys.argv[2])
child=pexpect.spawn('ssh 还是用户名@%s'%ip)
IP=['ip1','ip2','ip3','ip4']
if ip == IP[0]:
txt='13DMZ-RD5412-1.txt'
elif ip == IP[1]:
txt='14DMZ-RD5412-2.txt'
elif ip == IP[2]:
txt='15SM-RD20-1.txt'
elif ip == IP[3]:
txt='16SM-RD20-2.txt'
else:
print "IP Input Error!"
sys.exit()
name='Standalone ADC(?i)'
fout=file('/usr/sh/shell/linux/xunjian/'+today+'/'+txt,'w')
child.logfile = fout
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
if ip == IP[3]:
child.expect("(?i)y]:")
child.sendline("y")
child.expect("%s"%name)
child.sendline("/i/sys/general")
child.expect("%s"%name)
child.sendline("/i/sys/ps")
child.expect("%s"%name)
child.sendline("/i/sys/fan")
child.expect("%s"%name)
child.sendline("/i/link")
index = child.expect(["Press q to quit, any other key to continue","%s"%name])
if ( index == 0 ):
child.send(" ")
index = child.expect(["Press q to quit, any other key to continue","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("/i/sys/capacity slb")
else:
child.sendline("/i/sys/capacity slb")
index = child.expect(["Press q to quit, any other key to continue","%s"%name])
if ( index == 0 ):
child.send(" ")
index = child.expect(["Press q to quit, any other key to continue","%s"%name])
if ( index == 0 ):
child.send(" ")
index = child.expect(["Press q to quit, any other key to continue","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("/stats/mp/cpu")
else:
child.sendline("/stats/mp/cpu")
else:
child.sendline("/stats/mp/cpu")
child.expect("%s"%name)
child.sendline("/stats/mp/mem")
child.expect("%s"%name)
child.sendline("/i/sys/temp")
child.expect("%s"%name)
child.sendline("/i/l3/vrrp")
child.expect("%s"%name)
child.sendline("/i/sys/log")
for i in range(50):
index = child.expect(["Press q to quit, any other key to continue","%s"%name])
if ( index == 0 ):
child.send(" ")
else:
child.sendline("exit")
break
#index = child.expect(["(?i)n]:","%s"%name])
#if ( index == 0 ):
if ip == IP[3]:
child.expect("(?i)n]:")
child.sendline("y")
#else:
# pass
child.expect("(?i)n]:")
child.sendline("n")3、编写邮件脚本
mail.py
#!/usr/bin/python
# -*- coding: utf-8 -*-
from email.header import Header
import smtplib
import email.MIMEMultipart# import MIMEMultipart
import email.MIMEText# import MIMEText
import email.MIMEBase# import MIMEBase
import os.path
import sys
import mimetypes
import email.MIMEImage# import MIMEImage
import datetime
tday=datetime.date.today().strftime('%Y/%m/%d')
#命令 mail.py <1:发送方（回复地址）10000@qq.com> <2:发送地址，多个以;隔开> <3:发送文件>
From = "%s<*@139.com>" % Header("XXX","utf-8")
ReplyTo=sys.argv[1]
To = sys.argv[2]
file_name = sys.argv[3]#附件名
file_name1 = sys.argv[4]
server = smtplib.SMTP("smtp.139.com",25)
server.login("user@139.com","password") #仅smtp服务器需要验证时
# 构造MIMEMultipart对象做为根容器
main_msg = email.MIMEMultipart.MIMEMultipart()
# 构造MIMEText对象做为邮件显示内容并附加到根容器
text_msg = email.MIMEText.MIMEText("message内容正文",_charset="utf-8")
main_msg.attach(text_msg)
# 构造MIMEBase对象做为文件附件内容并附加到根容器
ctype,encoding = mimetypes.guess_type(file_name)
if ctype is None or encoding is not None:
ctype='application/octet-stream'
maintype,subtype = ctype.split('/',1)
file_msg=email.MIMEImage.MIMEImage(open(file_name,'rb').read(),subtype)
file_msg1=email.MIMEImage.MIMEImage(open(file_name1,'rb').read(),subtype)
## 设置附件头
basename = os.path.basename(file_name)
file_msg.add_header('Content-Disposition','attachment', filename = basename)#修改邮件头
main_msg.attach(file_msg)
basename1 = os.path.basename(file_name1)
file_msg1.add_header('Content-Disposition','attachment', filename = basename1)#修改邮件头
main_msg.attach(file_msg1)
# 设置根容器属性
main_msg['From'] = From
main_msg['Reply-to'] = ReplyTo
#main_msg['To'] = To
main_msg['Subject'] = u"[每日巡检] %s邮件标题" %tday
main_msg['Date'] = email.Utils.formatdate()
#main_msg['Bcc'] = To
# 得到格式化后的完整文本
fullText = main_msg.as_string( )
# 用smtp发送邮件
try:
server.sendmail(From, To.split(';'), fullText)
finally:
server.quit()mail_excel_error.py # 报错通知邮件：excel不存在
#!/usr/bin/env python
# -*- coding:utf-8 -*-
#import sys
#reload(sys)
import smtplib,string,datetime,xlrd
tday=datetime.date.today().strftime('%Y/%m/%d')
HOST="smtp.139.com"
SUBJECT="[每日巡检] %s哈哈哈"%tday
TO="*.com"
FROM="*@139.com"
text="excel no cunzai"
BODY=string.join((
"FROM: %s" % FROM,
"To: %s" % TO,
"Subject: %s" % SUBJECT,
"",
text
), "
")
server=smtplib.SMTP()
server.connect(HOST,"25")
server.starttls()
server.login(FROM,"密码")
server.sendmail(FROM,[TO],BODY)
server.quit()mail_zip_error.py # 邮件告警：巡检历史记录压缩文档不存在
#!/usr/bin/env python
# -*- coding:utf-8 -*-
#import sys
#reload(sys)
import smtplib,string,datetime,xlrd
tday=datetime.date.today().strftime('%Y/%m/%d')
HOST="smtp.139.com"
SUBJECT="[每日巡检] %s嘻嘻嘻" %tday
TO="asdas.com"
FROM="***@139.com"
text="zip no cunzai"
BODY=string.join((
"FROM: %s" % FROM,
"To: %s" % TO,
"Subject: %s" % SUBJECT,
"",
text
), "
")
server=smtplib.SMTP()
server.connect(HOST,"25")
server.starttls()
server.login(FROM,"PASSWORD")
server.sendmail(FROM,[TO],BODY)
server.quit()4、数据处理
wangluo_xunjian.py # 根据巡检内容制表
#!/usr/bin/env python # -*- coding:utf-8 -*- #import sys #reload(sys) import xlsxwriter,os,datetime def cmd(sname,fname): # 该函数判断巡检命令行所在输出文件位置 i=1 f=open(fname) line_hang_list=[] for line in f: if line.find(sname) == 0: line_hang_list.append(i) i+=1 f.close return line_hang_list def cmd1(sname,fname): # 同上 i=1 f=open(fname) line_hang_list=[] for line in f: if sname in line: line_hang_list.append(i) i+=1 f.close return line_hang_list tday=datetime.date.today().strftime('%Y.%m.%d') today=datetime.date.today().strftime('%Y%m%d') workbook=xlsxwriter.Workbook(u"/usr/sh/shell/linux/xunjian/%s/网络设备巡检-%s.xlsx"%(today,tday),{'strings_to_numbers':True}) file_01='/usr/sh/shell/linux/xunjian/'+str(today)+'/01DMZ-E8000E.txt' file_02_1='/usr/sh/shell/linux/xunjian/'+str(today)+'/03SM-M9006.txt' file_02_2='/usr/sh/shell/linux/xunjian/'+str(today)+'/02DMZ-M9006.txt' file_03='/usr/sh/shell/linux/xunjian/'+str(today)+'/04IN-FG3950B.txt' # 新建 sheet worksheet0=workbook.add_worksheet(u"防火墙") worksheet1=workbook.add_worksheet(u"交换机") worksheet2=workbook.add_worksheet(u"路由器") worksheet3=workbook.add_worksheet(u"负载") # 设置单元格格式(居中，颜色，边框，合并，列宽，列隐藏等) colour='#660099' format_title=workbook.add_format() format_title.set_border(1) format_title.set_bottom(2) format_title.set_bold(1) format_title.set_font_color('white') format_title.set_bg_color(colour) format_title.set_align('center') format_title.set_valign('vcenter') format_nr=workbook.add_format() format_nr.set_border(1) format_nr.set_bottom(2) format_nr.set_align('center') format_nr.set_valign('vcenter') format_nrr=workbook.add_format() format_nrr.set_border(1) format_nrr.set_valign('vcenter') format_nrr.set_text_wrap() format_bottom=workbook.add_format() format_bottom.set_border(1) format_bottom.set_bottom(2) format_bottom.set_valign('vcenter') format_bottom.set_text_wrap() format_rt=workbook.add_format() format_rt.set_border(1) format_rt.set_right(2) format_rt.set_valign('left') format_rt.set_text_wrap() format_right=workbook.add_format() format_right.set_border(1) format_right.set_right(2) format_right.set_bottom(2) format_right.set_valign('vcenter') format_right.set_text_wrap() format_red=workbook.add_format() format_red.set_font_color('red') format_red.set_border(1) format_red.set_right(2) format_red.set_valign('vcenter') format_rd=workbook.add_format() format_rd.set_font_color('red') format_rd.set_border(1) format_rd.set_right(2) format_rd.set_bottom(2) format_rd.set_valign('vcenter') # 填写相关固定单元格内容 firewall_title=[u'设备名称',u'设备类型',u'IP地址',u'检查项',u'命令',u'说明',u'检查结果'] firewall_jc=[u'设备状态',u'运行时长',u'运行温度',u'Flash状态',u'CPU使用率',u'内存使用率',u'冗余组状态',u'session数目',u'路由条数',u'端口状态',u'策略条数',u'告警',u'日志',u'板卡状态',u'运行时长',u'运行温度',u'Flash状态',u'CPU使用率',u'内存使用率',u'堆叠状态',u'冗余组状态',u'session数目',u'路由条数',u'端口状态',u'策略条数',u'告警',u'日志',u'板卡状态',u'运行时长',u'运行温度',u'Flash状态',u'CPU使用率',u'内存使用率',u'堆叠状态',u'冗余组状态',u'session数目',u'路由条数',u'端口状态',u'策略条数',u'告警',u'日志',u'运行时长',u'CPU使用率 (BOMC看)',u'内存使用率',u'网络流量',u'session数目',u'新建session速率',u'接口状态',u'冗余组状态',u'路由条数',u'日志',u'策略条数',u'告警'] firewall_cmd=['dis device | ex Normal','dis version','dis temperature','dir',u'在BOMC看','dis memory-usage','dis hrp state','dis firewall session table','dis ip routing-table protocol static','dis int brief (dis logbuffer | in DOWN)','dis acl 3004 (3004-3007)','dis alarm all','dis logbuffer | in [data]','dis device | ex Normal','dis version | in uptime','dis environment','dir | in total',u'在BOMC看','dis memory','dis irf link','dis redundancy group','dis session statistics summary','dis ip routing-table protocol static','dis int brief (dis logbuffer | in DOWN)','dis object-policy ip','dis alarm','dis logbuffer | in [month]','dis device | ex Normal','dis version | in uptime','dis environment','dir | in total',u'在BOMC看','dis memory','dis irf link','dis redundancy group','dis session statistics summary','dis ip routing-table protocol static','dis int brief (dis logbuffer | in DOWN)','dis acl all','dis alarm','dis logbuffer | in [month]','get sys performance status','','','','diagnose sys session stat','',u'网页登录查看',u'网页登录查看','get route info routing table static',u'网页登录查看',u'网页登录查看',u'网页登录查看'] firewall_sm=[u'填写Status是Abnormal的项',u'填写已运行天数,小时数',u'填写温度范围',u'填写total和free的flash大小',u'填写CPU使用率峰值和平均值',u'填写内存使用率',u'填写本机和邻居的角色，看有无发生主备切换',u'填写链接总数',u'填写路由数目',u'填写状态为UP的端口数目',u'填写策略数目',u'填写告警内容，无告警则填写“无告警”',u'填写异常日志，无异常则填写“正常”',u'填写State为Absent，且Type不为NONE的项',u'填写已运行天数，小时数',u'填写温度范围',u'填写total和free的flash大小',u'填写CPU使用率峰值和平均值',u'填写内存使用率范围',u'填写Status不是UP的项',u'填写Status，看有无发生主备切换',u'填写链接总数',u'填写路由数目',u'填写状态为UP的端口数目',u'填写策略数目(所有rule的总数)',u'填写告警内容，无告警则填写“无告警”',u'填写异常日志，无异常则填写“正常”',u'填写State为Absent，且Type不为NONE的项',u'填写已运行天数，小时数',u'填写温度范围',u'填写total和free的flash大小',u'填写CPU使用率峰值和平均值',u'填写内存使用率范围',u'填写Status不是UP的项',u'填写Status，看有无发生主备切换',u'填写链接总数',u'填写路由数目',u'填写状态为UP的端口数目',u'填写策略数目(acl 3001+3002的总条目数)',u'填写告警内容，无告警则填写“无告警”',u'填写异常日志，无异常则填写“正常”',u'填写已运行天数，小时数',u'填写CPU使用率峰值和平均值',u'填写内存使用率',u'填写30分钟内平均带宽占用（kbps）',u'填写session_count值',u'填写setup_rate值',u'填写启用状态的接口数目',u'填写冗余状态',u'填写路由数目',u'填写异常日志，无异常则填写“正常”',u'填写策略数目',u'填写告警内容，无告警则填写“无告警”'] switch_title=[u'设备名称',u'设备类型',u'IP地址',u'检查项',u'命令',u'说明',u'检查结果'] switch_jc=[u'设备状态',u'运行时长',u'Flash状态',u'CPU使用率',u'内存使用率',u'接口状态',u'VRRP状态',u'MAC地址条目数',u'ARP条目数',u'路由条目数',u'运行温度',u'告警',u'日志'] switch_jc1=[u'设备状态',u'运行时长',u'Flash状态',u'CPU使用率',u'内存使用率',u'堆叠状态',u'接口状态',u'MAC地址条目数',u'ARP条目数',u'路由条目数',u'运行温度',u'告警',u'日志'] switch_jc2=[u'设备状态',u'运行时长',u'Flash状态',u'CPU使用率',u'内存使用率',u'堆叠状态',u'接口状态',u'MAC地址条目数',u'ARP条目数',u'运行温度',u'告警',u'日志'] switch_cmd=['dis device','dis version | in Quidway','dir','dis cpu-usage','dis memory-usage','dis int brief (dis logbuffer | in IF_STATE)','dis vrrp brief','dis mac-address total-number','dis arp statistics all','dis ip routing-table protocol static','dis temperature all','dis alarm all','dis logbuffer | in [date]'] switch_cmmd=['dis device | ex Normal','dis version | in H3C S12508','dir',u'在BOMC看','dis memory','dis irf link','dis int brief (dis logbuffer reverse | in UPDOWN)','dis mac-address count','dis arp all count','dis ip routing-table -instance Dmz/Inside protocol static','dis environment','dis alarm','dis logbuffer reverse | in [date]'] switch_cmd1=['dis device | ex Normal','dis version | in H3C S12508','dir',u'在BOMC看','dis memory','dis int brief (dis logbuffer reverse | in UPDOWN)','dis vrrp','dis mac-address count','dis arp all count','dis ip routing-table protocol static','dis environment','dis alarm','dis logbuffer reverse | in [date]'] switch_cmd2=['dis device | ex Normal','dis version | in H3C S12508','dir',u'在BOMC看','dis memory','dis irf link','dis int brief (dis logbuffer reverse | in UPDOWN)','dis mac-address count','dis arp all count','dis environment','dis alarm','dis logbuffer reverse | in [date]'] switch_sm=[u'查看电源、风扇以及板卡状态，填写异常项',u'填写已运行天数，小时数',u'填写total和free的flash大小',u'填写CPU使用率',u'填写内存使用率',u'填写状态为UP的端口数目',u'查看VRRP主备状态',u'填写总的mac-address条目数',u'填写动态和静态ARP条目数',u'填写路由数目',u'填写温度范围',u'填写告警内容，无告警则填写“无告警”',u'填写异常日志，无异常则填写“正常”'] switch_ssm=[u'填写状态异常的项',u'填写已运行天数，小时数',u'填写total和free的flash大小',u'填写CPU使用率峰值和平均值',u'填写内存使用率',u'填写Status不是UP的项',u'填写状态为UP的端口数目',u'填写总的mac-address条目数',u'填写总的ARP条目数',u'填写路由数目(Dmz和Inside路由总和)',u'填写温度范围',u'填写设备告警，无则填写“无告警”',u'填写异常日志，无异常则填写“正常”'] switch_sm1=[u'填写状态异常的项',u'填写已运行天数，小时数',u'填写total和free的flash大小',u'填写CPU使用率峰值和平均值',u'填写内存使用率',u'填写状态为UP的端口数目',u'查看VRRP主备状态',u'填写总的mac-address条目数',u'填写总的ARP条目数',u'填写路由数目',u'填写温度范围',u'填写设备告警，无则填写“无告警”',u'填写异常日志，无异常则填写“正>常”'] switch_sm2=[u'填写状态异常的项',u'填写已运行天数，小时数',u'填写total和free的flash大小',u'填写CPU使用率峰值和平均值',u'填写内存使用率',u'填写Status不是UP的项',u'填写状态为UP的端口数目',u'填写总的mac-address条目数',u'填写总的ARP条目数',u'填写温度范围',u'填写设备告警，无则填写“无告警”',u'填写异常日志，无异常则填写“正>常”'] route_title=[u'设备名称',u'设备类型',u'IP地址',u'检查项',u'命令',u'说明',u'检查结果'] route_jc=[u'设备状态',u'运行时长',u'Flash状态',u'CPU使用率',u'内存使用率',u'接口状态',u'路由条数',u'运行温度',u'告警',u'日志'] route_cmd=['dis device | ex Normal','dis version | in NE40E-X8 uptime','dir',u'在BOMC看','dis memory-usage','dis int brief (dis logbuffer | in IF_STATE)','dis ip routing-table protocol static','dis temperature','dis alarm all','dis logbuffer | in [date]'] route_sm=[u'填写Status不是“Normal”的项',u'填写已运行天数，小时数',u'填写total和free的flash大小',u'填写CPU使用率峰值和平均值',u'填写内存使用率',u'填写状态为UP的端口数目',u'填写路由数目',u'填写温度范围',u'填写告警内容，无告警则填写“无告警”',u'填写异常日志，无异常则填写“正常”'] fuzai_title=[u'设备名称',u'设备类型',u'IP地址',u'检查项',u'命令',u'说明',u'检查结果'] fuzai_jc=[u'运行时长',u'电源状态',u'风扇状态',u'端口状态',u'各表项数值',u'CPU使用率',u'内存使用率',u'硬件温度',u'冗余状态',u'日志'] fuzai_cmd=['/i/sys/general','/i/sys/ps','/i/sys/fan','/i/link','/i/sys/capacity slb','/stats/mp/cpu','/stats/mp/mem','/i/sys/temp','/i/l3/vrrp','/i/sys/log'] fuzai_sm=[u'填写已运行天数，小时数',u'填写电源状态',u'填写风扇状态',u'填写Link处于UP状态的端口数',u'填写real servers/server groups/virtual servers/filters当前值',u'填写CPU使用率',u'填写内存使用率',u'填写温度',u'填写VRRP状态，"master"或者"backup"',u'填写异常日志，无异常则填写“正常”'] newsmswitch_title=[u'设备状态',u'运行时长',u'Flash状态',u'CPU使用率',u'内存使用率',u'接口状态',u'HSRP状态',u'MAC地址条目数',u'ARP条目数',u'路由条目数',u'运行温度',u'VPC状态',u'日志'] newsmswitch_cmd=['sh hardware | in ok','sh version | in uptime','dir',u'在BOMC看',u'在BOMC看','sh int brief (sh int brief | in up)','sh hsrp brief','sh mac address-table count','sh ip arp | in number','sh ip route static summary','sh environment temperature','sh vpc','sh logging last 30'] newsmswitch_sm=[u'填写状态为OK的模块数',u'填写已运行天数，小时数',u'填写total和free的flash大小',u'填写CPU使用率峰值和平均值',u'填写内存使用率',u'填写状态为UP的端口数目',u'查看HSRP状态(Active local则正常)',u'填写总的mac-address条目数',u'填写总的ARP条目数',u'填写路由数目',u'填写CurTemp范围',u'查看VPC状态是否正常',u'查看日志，无异常则填写"正常"'] # ip 我就隐藏掉啦,虽然也没什么意思 host={"DMZ-E8000E":[u'防火墙',"ip1"],"DMZ-M9006":[u'防火墙','ip2'],"SM-M9006":[u'防火墙','ip3'],"IN-FG3950B":[u'防火墙',"ip4"],"DMZ-S9306-1":[u'交换机',"ip5"],"DMZ-S9306-2":[u'交换机',"ip6"],"DMZ-S12508":[u'交换机',"ip7"],"IN-S12508":[u'交换机',"ip8"],"SM-S12508-1":[u'交换机',"ip9"],"SM-S12508-2":[u'交换机',"ip10"],"DMZ-NE40E-1":[u'路由器',"ip11"],"DMZ-NE40E-2":[u'路由器',"ip12"],"DMZ-RD5412-1":[u'负载',"ip13"],"DMZ-RD5412-2":[u'负载',"ip14"],"SM-RD20-1":[u'负载',"ip15"],"SM-RD20-2":[u'负载',"ip16"],"SM-N7K-1":[u"交换机","ip17"],"SM-N7K-2":[u"交换机","ip18"]} # 开始填写固定单元格内容 worksheet0.write_row('A1',firewall_title,format_title) worksheet0.merge_range('A2:A14','DMZ-E8000E',format_nr) worksheet0.merge_range('B2:B14',host["DMZ-E8000E"][0],format_nr) worksheet0.merge_range('C2:C14',host["DMZ-E8000E"][1],format_nr) worksheet0.merge_range('A15:A28','DMZ-M9006',format_nr) worksheet0.merge_range('B15:B28',host["DMZ-M9006"][0],format_nr) worksheet0.merge_range('C15:C28',host["DMZ-M9006"][1],format_nr) worksheet0.merge_range('A29:A42','SM-M9006',format_nr) worksheet0.merge_range('B29:B42',host["SM-M9006"][0],format_nr) worksheet0.merge_range('C29:C42',host["SM-M9006"][1],format_nr) worksheet0.merge_range('A43:A54','IN-FG3950B',format_nr) worksheet0.merge_range('B43:B54',host["IN-FG3950B"][0],format_nr) worksheet0.merge_range('C43:C54',host["IN-FG3950B"][1],format_nr) worksheet0.merge_range('E43:E46','get sys performance status',format_nrr) worksheet0.merge_range('E47:E48','diagnose sys session stat',format_nrr) worksheet0.write_column('D2',firewall_jc,format_nrr) worksheet0.write_column('E2',firewall_cmd,format_nrr) worksheet0.write_column('F2',firewall_sm,format_nrr) worksheet0.write('D14',u'日志',format_bottom) worksheet0.write('E14','dis logbuffer | in [data]',format_bottom) worksheet0.write('F14',u'填写异常日志，无异常则填写“正常”',format_bottom) worksheet0.write('D28',u'日志',format_bottom) worksheet0.write('E28','dis logbuffer reverse | in [month]',format_bottom) worksheet0.write('F28',u'填写异常日志，无异常则填写“正常”',format_bottom) worksheet0.write('D42',u'日志',format_bottom) worksheet0.write('E42','dis logbuffer reverse | in [month]',format_bottom) worksheet0.write('F42',u'填写异常日志，无异常则填写“正常”',format_bottom) worksheet0.write('D54',u'告警',format_bottom) worksheet0.write('E54',u'网页登录查看',format_bottom) worksheet0.write('F54',u'填写告警内容，无告警则填写“无告警”',format_bottom) worksheet0.set_row(0,30) worksheet0.set_column('B:B',15,None,{'hidden':1}) worksheet0.set_column('E:F',40,None,{'hidden':1}) worksheet0.set_column('A:A',15) worksheet0.set_column('C:D',15) worksheet0.set_column('G:G',40) worksheet1.write_row('A1',switch_title,format_title) worksheet1.merge_range('A2:A14','DMZ-S9306-1',format_nr) worksheet1.merge_range('B2:B14',host["DMZ-S9306-1"][0],format_nr) worksheet1.merge_range('C2:C14',host["DMZ-S9306-1"][1],format_nr) worksheet1.merge_range('A15:A27','DMZ-S9306-2',format_nr) worksheet1.merge_range('B15:B27',host["DMZ-S9306-2"][0],format_nr) worksheet1.merge_range('C15:C27',host["DMZ-S9306-2"][1],format_nr) worksheet1.merge_range('A28:A40','DMZ-S12508',format_nr) worksheet1.merge_range('B28:B40',host["DMZ-S12508"][0],format_nr) worksheet1.merge_range('C28:C40',host["DMZ-S12508"][1],format_nr) worksheet1.merge_range('A41:A52','IN-S12508',format_nr) worksheet1.merge_range('B41:B52',host["IN-S12508"][0],format_nr) worksheet1.merge_range('C41:C52',host["IN-S12508"][1],format_nr) worksheet1.merge_range('A53:A65','SM-N7K-1',format_nr) worksheet1.merge_range('B53:B65',host["SM-N7K-1"][0],format_nr) worksheet1.merge_range('C53:C65',host["SM-N7K-1"][1],format_nr) worksheet1.merge_range('A66:A78','SM-N7K-2',format_nr) worksheet1.merge_range('B66:B78',host["SM-N7K-2"][0],format_nr) worksheet1.merge_range('C66:C78',host["SM-N7K-2"][1],format_nr) worksheet1.write_column('D2',switch_jc,format_nrr) worksheet1.write_column('D15',switch_jc,format_nrr) worksheet1.write_column('D28',switch_jc1,format_nrr) worksheet1.write_column('D41',switch_jc2,format_nrr) worksheet1.write_column('D53',newsmswitch_title,format_nrr) worksheet1.write_column('D66',newsmswitch_title,format_nrr) worksheet1.write_column('E2',switch_cmd,format_nrr) worksheet1.write_column('E15',switch_cmd,format_nrr) worksheet1.write_column('E28',switch_cmmd,format_nrr) worksheet1.write_column('E41',switch_cmd2,format_nrr) worksheet1.write_column('E53',newsmswitch_cmd,format_nrr) worksheet1.write_column('E66',newsmswitch_cmd,format_nrr) worksheet1.write_column('F2',switch_sm,format_nrr) worksheet1.write_column('F15',switch_sm,format_nrr) worksheet1.write_column('F28',switch_ssm,format_nrr) worksheet1.write_column('F41',switch_sm2,format_nrr) worksheet1.write_column('F53',newsmswitch_sm,format_nrr) worksheet1.write_column('F66',newsmswitch_sm,format_nrr) worksheet1.set_row(0,30) worksheet1.set_column('B:B',15,None,{'hidden':1}) worksheet1.set_column('E:F',40,None,{'hidden':1}) worksheet1.set_column('A:A',15) worksheet1.set_column('C:D',15) worksheet1.set_column('G:G',40) worksheet2.write_row('A1',route_title,format_title) worksheet2.merge_range('A2:A11','DMZ-NE40E-1',format_nr) worksheet2.merge_range('B2:B11',host["DMZ-NE40E-1"][0],format_nr) worksheet2.merge_range('C2:C11',host["DMZ-NE40E-1"][1],format_nr) worksheet2.merge_range('A12:A21','DMZ-NE40E-2',format_nr) worksheet2.merge_range('B12:B21',host["DMZ-NE40E-2"][0],format_nr) worksheet2.merge_range('C12:C21',host["DMZ-NE40E-2"][1],format_nr) worksheet2.write_column('D2',route_jc,format_nrr) worksheet2.write_column('D12',route_jc,format_nrr) worksheet2.write_column('E2',route_cmd,format_nrr) worksheet2.write_column('E12',route_cmd,format_nrr) worksheet2.write_column('F2',route_sm,format_nrr) worksheet2.write_column('F12',route_sm,format_nrr) worksheet2.set_row(0,30) worksheet2.set_column('B:B',15,None,{'hidden':1}) worksheet2.set_column('E:F',40,None,{'hidden':1}) worksheet2.set_column('A:A',15) worksheet2.set_column('C:D',15) worksheet2.set_column('G:G',40) worksheet3.write_row('A1',fuzai_title,format_title) worksheet3.merge_range('A2:A11','DMZ-RD5412-1',format_nr) worksheet3.merge_range('B2:B11',host["DMZ-RD5412-1"][0],format_nr) worksheet3.merge_range('C2:C11',host["DMZ-RD5412-1"][1],format_nr) worksheet3.merge_range('A12:A21','DMZ-RD5412-2',format_nr) worksheet3.merge_range('B12:B21',host["DMZ-RD5412-2"][0],format_nr) worksheet3.merge_range('C12:C21',host["DMZ-RD5412-2"][1],format_nr) worksheet3.merge_range('A22:A31','SM-RD20-1',format_nr) worksheet3.merge_range('B22:B31',host["SM-RD20-1"][0],format_nr) worksheet3.merge_range('C22:C31',host["SM-RD20-1"][1],format_nr) worksheet3.merge_range('A32:A41','SM-RD20-2',format_nr) worksheet3.merge_range('B32:B41',host["SM-RD20-2"][0],format_nr) worksheet3.merge_range('C32:C41',host["SM-RD20-2"][1],format_nr) worksheet3.write_column('D2',fuzai_jc,format_nrr) worksheet3.write_column('D12',fuzai_jc,format_nrr) worksheet3.write_column('D22',fuzai_jc,format_nrr) worksheet3.write_column('D32',fuzai_jc,format_nrr) worksheet3.write_column('E2',fuzai_cmd,format_nrr) worksheet3.write_column('E12',fuzai_cmd,format_nrr) worksheet3.write_column('E22',fuzai_cmd,format_nrr) worksheet3.write_column('E32',fuzai_cmd,format_nrr) worksheet3.write_column('F2',fuzai_sm,format_nrr) worksheet3.write_column('F12',fuzai_sm,format_nrr) worksheet3.write_column('F22',fuzai_sm,format_nrr) worksheet3.write_column('F32',fuzai_sm,format_nrr) worksheet3.set_row(0,30) worksheet3.set_column('B:B',15,None,{'hidden':1}) worksheet3.set_column('E:F',40,None,{'hidden':1}) worksheet3.set_column('A:A',15) worksheet3.set_column('C:D',15) worksheet3.set_column('G:G',40) jcx=[u'日志','dis logbuffer | in [date]',u'填写异常日志，无异常则填写“正常”'] jcx1=[u'日志','dis logbuffer reverse | in [date]',u'填写异常日志，无异常则填写“正常”'] jcx2=[u'日志','sh logging last 30',u'查看日志，无异常则填写“正常”'] fuzai_jcx=[u'日志','/i/sys/log',u'填写异常日志，无异常则填写“正常”'] worksheet1.write_row('D14',jcx,format_bottom) worksheet1.write_row('D27',jcx,format_bottom) worksheet1.write_row('D40',jcx,format_bottom) worksheet1.write_row('D52',jcx1,format_bottom) worksheet1.write_row('D65',jcx2,format_bottom) worksheet1.write_row('D78',jcx2,format_bottom) worksheet2.write_row('D11',jcx,format_bottom) worksheet2.write_row('D21',jcx,format_bottom) worksheet3.write_row('D11',fuzai_jcx,format_bottom) worksheet3.write_row('D21',fuzai_jcx,format_bottom) worksheet3.write_row('D31',fuzai_jcx,format_bottom) worksheet3.write_row('D41',fuzai_jcx,format_bottom) # 这边开始根据之前与设备交互所得到的数据文件内容来填格子了。 #------------------------------------------------ #----------firewall_ip1---------------- #------------------------------------------------ try: hang=1 temp=[] hang_list=cmd("HRP_M<JSYD-WX-12580-DMZ-E8000E-1>",file_01) rules=[] g=0 with open(file_01) as f: for each_line in f: num=each_line.split() if hang > int(hang_list[1]) and hang < int(hang_list[2]): if int(hang_list[2])-int(hang_list[1]) == 6: worksheet0.write('G2',u'正常',format_rt) else: worksheet0.write('G2','ERROR',format_red) if hang > int(hang_list[2]) and hang < int(hang_list[3]): if num!=[]: if num[0] == 'HUAWEI': worksheet0.write('G3',u'%s天，%s小时'%(num[4],num[6]),format_rt) if hang > int(hang_list[3]) and hang < int(hang_list[4]): if num!=[]: if len(num) == 11: temp.append(num[-1]) if hang > int(hang_list[4]) and hang < int(hang_list[5]): if num!=[]: if ',' in num[0]: total=num[0].replace(',','')+' KB '+num[3].replace(',','')+' KB)' worksheet0.write('G5',total,format_rt) if hang > int(hang_list[5]) and hang < int(hang_list[6]): if num!=[]: if num[0] == 'Memory': worksheet0.write('G7',num[-1],format_rt) if hang > int(hang_list[6]) and hang < int(hang_list[7]): if num!=[]: if num[0] == 'Role:': if num[1] == 'active,' and num[-1] == 'standby': worksheet0.write('G8',u'正常',format_rt) else: worksheet0.write('G8',u'有',format_red) if hang > int(hang_list[7]) and hang < int(hang_list[8]): if num!=[]: if num[0] == 'Current': worksheet0.write('G9',str(num[-1]),format_rt) if hang > int(hang_list[8]) and hang < int(hang_list[9]): if num!=[]: if num[0] == 'Destinations' and len(num) == 10: worksheet0.write('G10',str(num[2]),format_rt) if hang > int(hang_list[9]) and hang < int(hang_list[10]): if num!=[]: if len(num) == 7: if num[1] == 'up': g+=1 if hang > int(hang_list[10]) and hang < int(hang_list[14]): if num!=[]: if num[0] == 'Advanced': rules.append(num[3]) if hang > int(hang_list[14]) and hang < int(hang_list[15]): if int(hang_list[-2])-int(hang_list[-3]) == 8: worksheet0.write('G13',u'无告警',format_rt) else: worksheet0.write('G13',u'有告警',format_red) if hang > int(hang_list[15]) and hang < int(hang_list[16]): pass hang = hang + 1 temp.sort() worksheet0.write('G4',u'%s℃-%s℃'%(temp[0],temp[-1]),format_rt) worksheet0.write('G6',None,format_rt) worksheet0.write('G11',g,format_rt) worksheet0.write('G12','%s+%s+%s+%s=%d'%(rules[0],rules[1],rules[2],rules[3],int(rules[0])+int(rules[1])+int(rules[2])+int(rules[3])),format_rt) worksheet0.write('G14',u'正常',format_right) except IOError as reason: print "01DMZ-E8000E.py "+str(reason) #------------------------------------------------ #----------firewall_iP2---------------- #------------------------------------------------ try: hang=1 state=dict() hang_list=cmd("<W-12580-M9006>",file_02_2) temp=[] rules=0 mem=[] g=0 all=0 n=0 level=0 q=0 status=0 type=0 with open(file_02_2) as f: for each_line in f: num=each_line.split() if hang > int(hang_list[0]) and hang < int(hang_list[1]): if num!=[]: if num[0].isdigit() and len(num) == 7: if num[3] == 'Absent': if num[2] != 'NONE': type=1 if hang > int(hang_list[1]) and hang < int(hang_list[2]): if num!=[]: if len(num) == 13: worksheet0.write('G16',u'%d天，%s小时'%(int(num[5])*7+int(num[7]),num[9]),format_rt) if hang > int(hang_list[2]) and hang < int(hang_list[3]): if num!=[]: if len(num) == 9: temp.append(num[4]) if hang > int(hang_list[3]) and hang < int(hang_list[4]): if num!=[]: if len(num) == 6: total='%s KB %s KB)'%(num[0],num[3]) worksheet0.write('G18',total,format_rt) if hang > int(hang_list[4]) and hang < int(hang_list[5]): if num!=[]: if len(num) == 8: if num[-1] != 'KB:': result='%.1f%%'%(100-float(num[-1].split('%')[0])) mem.append(result) if hang > int(hang_list[5]) and hang < int(hang_list[6]): if num!=[]: if 'GigabitEthernet' in num[1]: if num[2] != 'UP': status+=1 if 'GigabitEthernet' in num[0]: if num[1] != 'UP': status+=1 if hang > int(hang_list[6]) and hang < int(hang_list[7]): if num!=[]: if num[0].isdigit() and len(num) == 5: if num[3] != 'Primary' and num[3] != 'Secondary': q=1 if hang > int(hang_list[7]) and hang < int(hang_list[8]): if num!=[]: if num[0].isdigit() and len(num) == 9: g+=1 if hang > int(hang_list[8]) and hang < int(hang_list[9]): if num!=[]: if num[0] == 'Summary': state[n]=num[3] n+=1 if hang > int(hang_list[9]) and hang < int(hang_list[10]): if num!=[]: if len(num) >= 4 and num[1] == 'UP': all+=1 if hang > int(hang_list[10]) and hang < int(hang_list[12]): if num!=[]: if num[0] == 'rule': rules+=1 if hang > int(hang_list[12]) and hang < int(hang_list[13]): if num!=[]: if num[0].isdigit() and len(num) >5: if num[3] != 'INFO': level=1 if hang > int(hang_list[13]) and hang < int(hang_list[14]): pass hang+=1 temp.sort() mem.sort() if type == 0: worksheet0.write('G15',u'正常',format_rt) else: worksheet0.write('G15','ERROR',format_red) worksheet0.write('G17',u'%s℃-%s℃'%(temp[0],temp[-1]),format_rt) worksheet0.write('G19',None,format_rt) worksheet0.write('G20','%s-%s'%(mem[0],mem[-1]),format_rt) if status == 0: worksheet0.write('G21',u'正常',format_rt) else: worksheet0.write('G21',status,format_rt) if q == 0: worksheet0.write('G22',u'正常',format_rt) else: worksheet0.write('G22',u'有',format_red) worksheet0.write('G23',g,format_rt) worksheet0.write('G24',state[0],format_rt) worksheet0.write('G25',all,format_rt) worksheet0.write('G26','%d'%rules,format_rt) if level == 1: worksheet0.write('G27','ERROR',format_red) else: worksheet0.write('G27',u'无告警',format_rt) worksheet0.write('G28',u'正常',format_right) except IOError as reason: print "02DMZ-M9006.py "+str(reason) #------------------------------------------------ #----------firewall_ip3---------------- #------------------------------------------------ try: hang=1 state=dict() hang_list=cmd("<W-SM-M9006>",file_02_1) temp=[] rules=[] mem=[] g=0 all=0 n=0 level=0 q=0 status=0 type=0 with open(file_02_1) as f: for each_line in f: num=each_line.split() if hang > int(hang_list[0]) and hang < int(hang_list[1]): if num!=[]: if num[0].isdigit() and len(num) == 7: if num[3] == 'Absent': if num[2] != 'NONE': type=1 if hang > int(hang_list[1]) and hang < int(hang_list[2]): if num!=[]: if len(num) == 13: worksheet0.write('G30',u'%d天，%s小时'%(int(num[5])*7+int(num[7]),num[9]),format_rt) if hang > int(hang_list[2]) and hang < int(hang_list[3]): if num!=[]: if len(num) == 9: temp.append(num[4]) if hang > int(hang_list[3]) and hang < int(hang_list[4]): if num!=[]: if len(num) == 6: total='%s KB %s KB)'%(num[0],num[3]) worksheet0.write('G32',total,format_rt) if hang > int(hang_list[4]) and hang < int(hang_list[5]): if num!=[]: if len(num) == 8: if num[-1] != 'KB:': result='%.1f%%'%(100-float(num[-1].split('%')[0])) mem.append(result) if hang > int(hang_list[5]) and hang < int(hang_list[6]): if num!=[]: if 'GigabitEthernet' in num[1]: if num[2] != 'UP': status=1 if 'GigabitEthernet' in num[0]: if num[1] != 'UP': status=1 if hang > int(hang_list[6]) and hang < int(hang_list[7]): if num!=[]: if num[0].isdigit() and len(num) == 5: if num[3] != 'Primary' and num[3] != 'Secondary': q=1 if hang > int(hang_list[7]) and hang < int(hang_list[8]): if num!=[]: if num[0].isdigit() and len(num) == 9: g+=1 if hang > int(hang_list[8]) and hang < int(hang_list[9]): if num!=[]: if num[0] == 'Summary': state[n]=num[3] n+=1 if hang > 下载本文