We use to use a different eTicket system and I had written a query that would run and email some staff of all open tickets for their area. Although they can log into the system and see it, they would prefer an email at night. I have the query written of osTicket 1.9.4 but I'm not sure where the name of the person who submitted the ticket is really located. I see the ost_user table and ost_user_email will give me their first name and email address but I need the last name. Not sure what table this is in. Any suggestions?