If you look at ost_ticket (say ticket number 111111) you can do a query to get the:ticket_id (internal)user_iduser_email_idsomething like: SELECT * FROM ost_ticket WHERE number="111111";Once you have those you can look up the pieces. Say your user_id was 13. You can look at: ost_user and see that id=13 is name Jane Doe.Then you can look up the email in ost_user_email where user_id=13 and see that address is jane.doe@faux.org.Phone is convoluted. You need to look up the field in your ost_form_entry for the user #. then loo up the field id in ost_form_field, and then get the value from ost_form_entry_values. Something like this would work on my installation:SELECT * FROM ost_ticket WHERE number = 111111;ticket_id = XXXXuser_id = 20user_email_id = 20SELECT * FROM ost_form_entry WHERE object_id=20;id = 796form_id = 1SELECT * FROM ost_form_field WHERE type="phone" and form_id='1';id = 3SELECT * FROM ost_form_entry_values WHERE entry_id = 796 and field_id='3';
