GuestUsers.py

from email.message import EmailMessage
from xkcdpass import xkcd_password as xp
import smtplib, datetime, shlex, subprocess, sys, os
import pandas as pd
import pendulum

#Python and GAM script to rotate passwords and email to sites and district contacts
#the information of the passwords. For use to have 5 Guest accounts available weekly for
#sites to have guests join Zoom meetings and whatnot.

#Campuses is where you put in what campus you are updating a guest login for, and then whom you are emailing
#to. The third field is used by the program to story the body of the email that gets mailed out.
campuses = [('ahs','me@school.org',''),
             ('chs','me@school.org',''),
             ('llhs','me@school.org',''),
             ('mhs','me@school.org','')]
#docontacts is where you would put in District level people who need to be aware of what then
#passwords are for each site.
docontacts = 'admincontact@school.org,admincontact@school.org'
pendulum.week_starts_at(pendulum.MONDAY)
pendulum.week_ends_at(pendulum.FRIDAY)
today = pendulum.now().add(days=3)
start = today.start_of('week')
end = today.end_of('week')
theweekof = "for the week of " + start.strftime('%B %d') + " to " + end.strftime('%B %d')
df = pd.DataFrame(campuses, columns = ['campusname','contacts','emailbody'])
wordfile = xp.locate_wordfile()
mywords = xp.generate_wordlist(wordfile=wordfile, min_length=2, max_length=8)
for x in df.index:
    msg = EmailMessage()
    df['emailbody'][x] = "Passwords for Guest accounts this week are:\n\n"
    for i in range(5):
        password = xp.generate_xkcdpassword(mywords, delimiter="", acrostic=df['campusname'][x])
        df['emailbody'][x] = df['emailbody'][x] + "Guest user -> " + df['campusname'][x] + "-guest" + str(i+1) + "@school.org"  + "     Password -> " + password + "\n\n"
        gamstring = "E:\\GAMADV-XTD3\\gam.exe update user " + df['campusname'][x] + "-guest" + str(i+1) + "@school.org password " + password
        p = subprocess.Popen(["powershell.exe",gamstring],stdout=sys.stdout)
        p.communicate()
    s = smtplib.SMTP('10.99.0.202')
    msg['Subject'] = "Guest Account Passwords for " + df['campusname'][x].upper() + " " + theweekof
    msg['From'] = 'donotreply@school.org'
    msg['To'] = str(df['contacts'][x] + "," + docontacts)
    msg.set_content(df['emailbody'][x])
    s.send_message(msg)