Since we have developed an external script to update phone numbers from Active Directory to osTicket, we already have this query made some time ago, so try the following (may needs some adjustment, but should work):select ost_user.id,ost_user.name,ost_user_account.username,ost_form_field.label,ost_form_field.name,ost_form_entry_values.value from ost_user LEFT JOIN ost_user_account on ost_user.id=ost_user_account.user_id LEFT JOIN ost_form_entry on ost_user.id=ost_form_entry.object_id LEFT JOIN ost_form_entry_values on ost_form_entry.id=ost_form_entry_values.entry_id LEFT JOIN ost_form_field on ost_form_entry_values.field_id=ost_form_field.id WHERE (ost_form_field.name='variable_name_of_osTicket_form_field_with_phonenumber_usually_"phone"_when_you_have_not_changed_it' AND ost_user_account.username='username_of_osTicket_user');EDIT/UPDATEJust for the record, here's our script on github - it contains several other (maybe useful) queries:https://github.com/Chefkeks/osTicket-Addons
