Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Database Query

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?

Comments

  • ost_user has id, name (as entered) and default_email_id.
    You would use the default_email_id to look up their email in ost_user_email (by user_id).

Sign In or Register to comment.