email from address field in database

[davidrb84]

I'm looking to review the email addresses that people have used to contact the service desk as part of a piece of work I'm involved in.

Emails in the Mailbox obviously show both a cosmetic name "David Smith" but also the email address "david.smith@something.com".

 

When looking in h_msg_messages the h_msg_from field almost always only contains the Cosmetic name.

Obviously as the mailbox is working, the from address must exist somewhere, does anyone know where this might be found?

Note: I don't use direct database more than I need to, generally the relevant tables are cloned out into a data repository we use for reporting. Direct database is just useful for finding the correct table/fields.

[Victor]

@davidrb84 check the recipients table