思想

1、python抓取交換機的信息
2、提取需要的檢查結果，并寫入excel表格
3、如果某一檢查結果超出閾值或不符合某一關鍵字，自動發送報警郵件
4、每十分鐘執行一次python代碼

代碼

抓取交換機信息

importpexpect
importsys
importdatetime
importos

#today=datetime.date.today().strftime('%Y%m%d')
print(3)
ip='x.x.x.x'
passwd='xxxx'
txt='F5hexin.txt'
name=''
name1="----More----"
child=pexpect.spawn('telnet%s'%ip)
fout=open('/root/F5Core/Core/'+txt,'wb+')
child.logfile=fout
child.expect('login:')
child.sendline("admin")
child.expect('(?i)ssword:')
child.sendline("%s"%passwd)
child.expect("%s"%name)
child.sendline("displaypower")
child.expect("%s"%name)
child.sendline("displayversion")
foriinrange(20):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("displayenvironment")
break
foriinrange(20):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("displayfan")
break
foriinrange(10):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("displaycpu-usage")
break
foriinrange(10):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("displaymemory")
break
foriinrange(10):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("displayinterfacebrief")
break
foriinrange(10):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("dislogbuffer")
break
foriinrange(50):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("displayiprouting-table")
break
foriinrange(50):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("displayirflink")
break
foriinrange(3):
index=child.expect([name1,"%s"%name])
if(index==0):
child.send("")
else:
child.sendline("quit")
sys.exit()

代碼

匹配閾值，報警

#coding:utf-8
importpymssql
importxlwt
importdatetime
fromxlwtimport*
fromemail.mime.textimportMIMEText
fromemail.mime.multipartimportMIMEMultipart
importsmtplib
importdatetime
fromemailimportencoders
fromemail.mime.imageimportMIMEImage
fromemail.mime.baseimportMIMEBase
importre
importxlrd

file=open('/root/F5Core/Core/F5hexin.txt','r+')
listlist=file.readlines()
i=1
forlineinlistlist:#匹配檢查結果，超出閾值，把結果換成error。
if'displaypower'inline:
power11=listlist[i+6][8:15].strip()
ifpower11!='Normal':
power11='Error'
print(power11)
power12=listlist[i+8][8:15].strip()
ifpower12!='Normal':
power12='Error'
print(power11)
power13=listlist[i+10][8:15].strip()
ifpower13!='Normal':
power13='Error'
print(power11)
power14=listlist[i+12][8:15].strip()
ifpower14!='Normal':
power14='Error'
print(power11)
power21=listlist[i+28][8:15].strip()
ifpower21!='Normal':
power21='Error'
print(power11)
power22=listlist[i+30][8:15].strip()
ifpower22!='Normal':
power22='Error'
print(power11)
power23=listlist[i+32][8:15].strip()
ifpower23!='Normal':
power23='Error'
print(power23)
power24=listlist[i+34][8:15].strip()
ifpower24!='Normal':
power24='Error'
print(power24)
if'MPU(M)Chassis1Slot0:'inline:
time11=listlist[i+1][9:].strip()
print(time11)
if'LPUChassis1Slot2:'inline:
time12=listlist[i+1][9:].strip()
print(time12)
if'MPU(S)Chassis2Slot0:'inline:
time13=listlist[i+1][9:].strip()
print(time13)
if'LPUChassis2Slot2:'inline:
time14=listlist[i+1][9:].strip()
print(time14)
if'displayenvironment'inline:
environment11=listlist[i+10][26:29].strip()+''+listlist[i+12][26:29].strip()
environment12=listlist[i+14][26:29].strip()+''+listlist[i+16][26:29].strip()+''+listlist[i+18][26:29].strip()
environment13=listlist[i+46][26:29].strip()+''+listlist[i+51][26:29].strip()
environment14=listlist[i+53][26:29].strip()+''+listlist[i+55][26:29].strip()+''+listlist[i+57][26:29].strip()
ifint(listlist[i+10][26:29].strip())>70:
environment11='Error'
print(environment11)
ifint(listlist[i+12][26:29].strip())>70:
environment11='Error'
print(environment11)
ifint(listlist[i+14][26:29].strip())>70:
environment12='Error'
print(environment12)
ifint(listlist[i+16][26:29].strip())>70:
environment12='Error'
print(environment12)
ifint(listlist[i+18][26:29].strip())>70:
environment12='Error'
print(environment12)
ifint(listlist[i+46][26:29].strip())>70:
environment13='Error'
print(environment13)
ifint(listlist[i+51][26:29].strip())>70:
environment13='Error'
print(environment13)
ifint(listlist[i+53][26:29].strip())>70:
environment14='Error'
print(environment14)
ifint(listlist[i+55][26:29].strip())>70:
environment14='Error'
print(environment14)
ifint(listlist[i+57][26:29].strip())>70:
environment14='Error'
print(environment14)
if'displayfan'inline:
fana11=listlist[i+6][-8:].strip()
iffana11!='Normal':
fana11='Error'
print(fana11)
fana12=listlist[i+26][-8:].strip()
iffana12!='Normal':
fana12='Error'
print(fana12)
fana13=listlist[i+53][-8:].strip()
iffana13!='Normal':
fana13='Error'
print(fana13)
fana14=listlist[i+73][-8:].strip()
iffana14!='Normal':
fana14='Error'
print(fana14)
if'Chassis1Slot0CPU0CPUusage:'inline:
cpu11=listlist[i+5][6:10].strip()
ifint(re.sub('%','',cpu11))>30:
cpu11='Error'
print(cpu11)
if'Chassis1Slot2CPU0CPUusage:'inline:
cpu12=listlist[i+5][6:10].strip()
ifint(re.sub('%','',cpu12))>30:
cpu12='Error'
print(cpu12)
if'Chassis2Slot0CPU0CPUusage:'inline:
cpu13=listlist[i+5][6:10].strip()
ifint(re.sub('%','',cpu13))>30:
cpu13='Error'
print(cpu13)
if'Chassis2Slot2CPU0CPUusage:'inline:
cpu14=listlist[i+8][6:10].strip()
ifint(re.sub('%','',cpu14))>30:
cpu14='Error'
print(cpu14)
if'displaymemory'inline:
memory11=listlist[i+8][-6:].strip()
iffloat(re.sub('%','',memory11))530:
log11='Error'
print(log11)
if'Routes:'inline:
routingtable11=line[-5:].strip()
ifint(routingtable11)

	

	自動執行代碼

	Linux crontab

	

	結果

	1、正常巡檢結果

	

	2、出現異常報警的巡檢結果

	

	審核編輯：湯梓紅