Locating a missing e-mail

Is there a way of searching the whole of an Exchange 2007 mailbox store for a particular e-mail?

Here's the scenario - a user received an e-mail from an external contact. She then moved that e-mail to a folder within another mailbox that she, and several others, have access to. That e-mail has now gone missing and we need to try and locate it.

I have checked the message tracking system and can see the e-mail coming in, so I have the MessageID.

I've checked the deleted items, mailboxes etc of all the other people who have access to the mailbox, and also checked their 'recover deleted items' - but no luck in finding the e-mail.

As the e-mail came in 3 weeks ago, it should still be in the message store somewhere, even if it has been deleted by someone.

Is there any way of interrogating the message store to find out :-
a) If it still exits in the store
b) if it does, where it is located
c) If it does not, an audit trail of what happened to it

Thanks

Michael
Michael986Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will SzymkowskiSenior Solution ArchitectCommented:
What you could try is something like this below...

Get-mailboxdatabase | Export-mailbox -SenderKeywords "Sender Email" -TargetMailbox "testuser" -TargetFolder "MyFolder"

This will search all of the mailboxes within all databases and look for anything that has a sender of "sender@mydomain.com" and put a copy of each mail item it finds with that sender into Testuser Mailbox under the "MyData" folder.

You can also use different switches like

-Subjectkeywords
- ContentKeywords

in replace of -SenderKeywords

Thanks


Will.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Michael986Author Commented:
Thanks  your reply.


I've tried the command as follows :-

[PS] C:\Windows\system32>Get-mailboxdatabase | Export-mailbox -SubjectKeywords "
Sales Report" -TargetMailbox "michael" -TargetFolder "temp"

But am getting the following error message

Export-Mailbox : The specified user "<Server Name>\First Storage Group\Mailbo
x Database" could not be found.

Any ideas?
0
Will SzymkowskiSenior Solution ArchitectCommented:
Looks like the first command get-mailboxdatabase wants to have the database name. Use the format Server\storage group\database name

Also make sure that the targetmailbox is actually the correct name as well.
0
Michael986Author Commented:
I tried using the database name but came up with the same error message

I found an article regarding a similar issue with the get-mailboxdatabase cmdlet - http://social.technet.microsoft.com/Forums/exchange/en-US/861e7336-9e0a-4fed-ac12-961b9a4bfefe/prb-with-exportmailbox-cmdlet

I tried the suggestion in there of changing the command to

Get-Mailbox -Database -"Mailbox Database"

and this worked - sort of. I sent an e-mail with the subject "Sales Report" to a test mailbox then ran the command - this created a subfolder in my 'temp folder' and copied the e-mail there - all good. However, it only worked for some mailboxes, not all.

The 'StatusMessage' on completion of the command shows either :-

Error occurred in the step: Moving messages.
 Failed to copy messages to the destination
mailbox store with error:
MAPI or an unspecified service provider.
ID no: 00000000-0000-00000000

or

 This mailbox has been exported to the target
  user mailbox.

My first guess at this is that might be a permissions thing - maybe the target mailbox has to have some permission over the mailbox being exported? Is there a quick way around this, rather than having to go into each mailbox to set permissions?
0
Michael986Author Commented:
There were a few issues with this method, but it certainly put me on the right tracks to be able to find what I needed
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.