report Reporting on Emails

[QEHNick]

I'd like to create a report which shows emails received by our local customers (those which are "Basic" users in SM).

Which tables etc do I need to link together to make that happen?

Many thanks everyone.

[QEHNick]

If it helps, the "From" content appears to be the persons surname a comma then a space and their first name.

 

Perhaps some statement to match that against h_sys_accounts?

h_sys_accounts.surname & ", " & h_sys_accounts.firstname

Tried this, no joy.. Will keep fiddling.

[QEHNick]

So when I say emails received by our local users, I mean to say those sent to us FROM those users....

[QEHNick]

I discovered it was easier to simply report on those which did not have the "@" symbol in the "From" field, those internally received emails were showing the "From" field contents as Surname, Forename.

 

Thank you all.