Mar-15-2023, 08:43 AM
I have script which reads device info from database - IP, LOCATION and STATUS
First it checks if device has status "ACTIVE" if yes than it pings device (incase of any technical problems)
I would like to ask how to send all unresponsive devices in one email? Now i get separate email for each device.
My current code:
First it checks if device has status "ACTIVE" if yes than it pings device (incase of any technical problems)
if ping is successful it stores IP of device to listif ping is unsuccessful than it sends me emailI would like to ask how to send all unresponsive devices in one email? Now i get separate email for each device.
My current code:
# email
def email(ip, location):
fromaddr = "@gmail.com"
toaddr = "@gmail.com"
msg = MIMEMultipart()
msg['From'] = fromaddr
msg['To'] = toaddr
msg['Subject'] = "Unresponsive device"
body = """<html><head></head>""" + "IP: " + ip + "<br>" + "Location: " + location+ "</html>"
msg.attach(MIMEText(body, 'html'))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(fromaddr, "XXXXX")
text = msg.as_string()
server.sendmail(fromaddr, toaddr, text)
server.quit()
# ping
def ping(host):
result = os.popen(' '.join(("ping", ping.param, host))).read()
return 'ttl=' in result.lower()
ping.param = "-n 1" if platform.system().lower() == "windows" else "-c 1"
# get devices
mycursor.execute("SELECT ip, location, status FROM devices")
devices = mycursor.fetchall()
ips = []
for device in devices:
active = device[2]
if active == "ACTIVE":
a = ping(device[0])
if a == True:
ip = device[0]
ips.append(ip)
else:
email(device[0], device[1])