Transfer MT info
How could i save the results from message tracking into notepad or excel or a similar tool? Thanks
November 12th, 2008 3:53pm

Hi, Message tracking log file is tab delimited text files, open it in excel and filter as per your requirement or use some utility like LogParser to filter result with your search. References: Exchange: Exporting and Querying Message Tracking Logs Using Log Parser http://msexchangetips.blogspot.com/2006/09/exchange-exporting-and-querying.html You can generate command from here Logparser for Exchange Message Tracking http://anonymoos.com/logparser.php Or if you are aware about scripting then you can check below resource More Exchange Message Tracking http://theessentialexchange.com/blogs/michael/archive/2007/11/13/more-exchange-message-tracking.aspx Message Tracking Logs Report Script and Database http://www.outlookexchange.com/articles/glenscales/mtrackrs.asp BTW, you can export the detailed search result for a message to .xml file from message tracking center.
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2008 4:17pm

BTW, you can export the detailed search result for a message to .xml file from message tracking center. I do have a list of mails that i would like in xml. How do i go about this? as i dont have any option in the message tracking centre to export any results? Oh and im using Exchange 2007..... Edit: Sorry let me explain as i read the links you provided and think, were referring to 2 separate things. In exchange 2007 if you open up ToolBox and select Message Tracking, this then allows you to check emails sent/received etc after providing your information. That is, if you wanted to limit your search to one user you type in the one users email address and proceed further. Following this you see the results, unfortunately these can not be copied or exported and its these results im after. Many thanks
November 12th, 2008 4:45pm

For Exchange 2007, you can simply use EMS to filter message tracking log. Check out this article for step-by-step guide and at last you can use | out-html | out-ie to get result in html file. http://exchangepedia.com/blog/2006/10/exchange-server-2007-message-tracking.html
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2008 5:03pm

Thanks that almost does it. When i save it to a text file if a column is too long it get truncated with ..., how can i have this removed and listed with all the info available? Heres my code: Code SnippetGet-MessageTrackingLog -sender "foo@somedomain.com" -eventID DELIVER -Start "10/01/2006 9:00AM" -End "10/03/2006 5:00PM" | Select timestamp,recipients,messagesubject > c:\test.txt Thanks
November 12th, 2008 5:14pm

To get result in table format you need to add required column header manually (examples: timestamp, recipients, messagesubject...). You can use | Format-List > c:\test.txt to get all available information but it will be formatted list wise.
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2008 5:30pm

I'm new to Powershell and was looking to do the same thing too but couldn't find the answer doing Google search. I played around a little and realized all cmdlets return their results as objects. A couple hours playing around and viola! A nice text delimited file ready for viewing under Excel. Get-MessageTrackingLog -Start "04/21/2009 1:20PM" -End "04/21/2009 1:35PM" -Sender "mysender@nowhere.com" ` -resultsize unlimited -server $HubServer -eventid deliver | ForEach-Object `{ $out = [String]$_.Timestamp + "`t" + $_.Sender + "`t" + $_.MessageSubject + "`t" + $_.Recipients Add-Content .\Report.txt $out}
April 22nd, 2009 2:22pm

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

Other recent topics Other recent topics