Omniscope Help Center

Hello there, just posting a Python script that I wrote and embedded in Omniscope to send email when I find a certain value in my dataset (i.e. a failure condition)

import pandas as pd
import smtplib

mail_user = 'youruser@yourserver.com'  
mail_password = 'yourpassword'

sent_from = mail_user  
to = ['recipient1@yourserver.com', 'recipient2@yourserver.com]  
subject = 'Important Message'  
body = ''

#Check a special condition
for index, row in input_data.iterrows(): 
  if (row[0] == "FAILURE"): 
    #Construct the message to send
    body = 'Failure found - ' + row[1] 
    #Do not touch these lines below until the break keyword!
    email_text = """\
From: %s
To: %s
Subject: %s

%s
""" % (sent_from, ", ".join(to), subject, body)
    break

#If the condition was met,  send the email
if body:
	#Email Server config, and connect
	server = smtplib.SMTP_SSL('smtp.yourserver.com', 465)
	server.ehlo()
	#Next, log in to the server
	server.login(mail_user, mail_password)
    #Send the mail
	server.sendmail(sent_from, to, email_text)
    #Quit the connection
	server.quit()
	#Output the message sent to Python block output
	output_data = pd.DataFrame(["Sent "+ body], columns=["Result"])
else:
	#do nothing, output no message was sent
	output_data = pd.DataFrame(["Nothing to send"], columns=["Result"])