Problem

--Reports about senders to specific external/internal domains/address

Resolution

*the Administrator UI does not provide the ability to export the results into a text file or similar, this can be achieved with directly extracting this information via SQL script from the EMF database

1. use EMFMail
2. select a.eventTime, a.messagesender, b.recipientname,
   a.messagesubject, a.messagesize from eventlogmessageinfo
   a join eventlogrecipientdetails b on a.eventId=b.eventId
   where a.eventTime between '4/6/2011 1:22:46 AM' and '11/11/2011 1:22:46 AM'
   and b.recipientName like '%domain.com'

*System administrators may need to provide report about all senders email addresses who sent emails to a particular external/internal domain and/or address. Since .

*Note the % sign in '%domain.com' which stands for "every character" in front of the domain name. In case the DB instance name is different than the default "EMFMail", then please substitute with the DB instance name of your server.

*In case you would like to search for a particular email address and not the whole domain, you can replace the last row "and b.recipientName like '%domain.com' " with "and b.recipientName='email@domain.com' ".