Query roadrecon db for specific users

gistfile1.txt

import re
from roadtools.roadlib.metadef.database import User
import roadtools.roadlib.metadef.database as database
session = database.get_session(database.init())

pattern = r".*@example\.com$"

for user in session.query(User):
    if user.mail and re.match(pattern, user.mail):
        print(user.userPrincipalName)