Running Exchange 2007 gueries on Sent Items by specific user
Using Powershell - how can I run a query based on "user" (or mailbox), "Sent Items", "Date Range" and have the ability to supplement specific recipients?Thanks,
September 17th, 2009 7:39pm

You can do this with Export-Mailbox.Check below article, specially scenario 1 of Legal Discovery... Exchange Server 2007 Cross Mailbox Search using Export-mailbox http://msexchangeteam.com/archive/2006/12/18/431934.aspxAmit Tank | MVP Exchange Server | MCITP: EMA | MCSA: M | http://ExchangeShare.WordPress.com
Free Windows Admin Tool Kit Click here and download it now
September 17th, 2009 7:44pm

THanks Amit - I do not need the emails I just want to specifically scan one users mailbox for all sent Items to another mailbox in a specified date range. No keyword search. And output the info to a txt or xls file. Is this possible with Export-Mailbox?
September 17th, 2009 7:50pm

I guess, this is not possible with any tool to query any mailbox folder and export the info such as subject, date, sender, recipients etc.. to a txt/xls file... As an alternative you can use Export-Mailbox cmdlet to export all sent items to PST file for aspecificdate range and review the PST file... How to Export Mailbox Data http://technet.microsoft.com/en-us/library/bb266964.aspxAmit Tank | MVP Exchange Server | MCITP: EMA | MCSA: M | http://ExchangeShare.WordPress.com
Free Windows Admin Tool Kit Click here and download it now
September 17th, 2009 8:31pm

Per my knowledge, theres no method to query one specific folder for different user in the exchange 2007 natively. And, thats why Amit suggest you to use Export-Mailbox, which is a sort of workaround to accomplish what you want. You can also grant appropriate permissions to a user on the mailbox you need to query, and then search for the items you want by logon to the mailbox directly
September 18th, 2009 4:49am

I do not need the emails I just want to specifically scan one users mailbox for all sent Items to another mailbox in a specified date range. No keyword search. And output the info to a txt or xls file. Is this possible with Export-Mailbox?And in your initial posting you said: Using Powershell - how can I run a query based on "user" (or mailbox), "Sent Items", "Date Range" and have the ability to supplement specific recipients? Are you thinking of something like this:# Define the variables [string]$recipient = 'felicia@domain.net'[string]$sender = 'jas@domain.net'[string]$evnetID = 'RECEIVE'[string]$startDate = '18.09.2009 12:00:00'[string]$endDate = '18.09.2009 14:10:00'[string]$csvFile = 'c:\temp\test.csv' # Track messages and export the info to a .CSV file# The grave accent conitues the lineGet-Messagetrackinglog -Recipients:$recipient -Sender $sender `-EventID $evnetID -Start $startDate -End $endDate | `Export-Csv -Encoding 'Unicode' $csvFile This will provide you with info on the communication between a sender and a receiver with a subject line.Actually you get a lot more info, but his may easily be customized.You don't get the message body, though.Delete the first line in the .csv file before opening it / importing it as a comma delimited file in Excel.jas
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2009 3:35pm

THat is exactly what I was looking for THANKS!
September 18th, 2009 4:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics