1.通过netmiko模块登录交换机,协议ssh,执行收集信息命令,保存至txt文件
2.过滤txt文件中的内容,保存到excel,使用xlwt模块实现。
3.sendmai发送excel邮件。或者发送给钉钉机器人也可以
4.使用crond定时发送巡检报表。
代码如下
#!/usr/bin/python3
#H3c交换机
import time
from netmiko import ConnectHandler
now = time.strftime("%Y%m%d",time.localtime(time.time()))
log_time = time.strftime("%Y-%m-%d %H:%M:%S",time.localtime())
ip_list = [
["sw-001","192.168.1.1"],
["sw-002","192.168.1.2"],
]
SW = {
"device_type":"hp_comware",
"username":"admin",
"ip":"",
"password":"$password"
}
for ip_item in ip_list:
SW["ip"] = ip_item[1]
connect = ConnectHandler(**SW)
print(log_time + "Successfully connected to "