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