How could i save the results from message tracking into notepad or excel or a similar tool?

Thanks

There is an amazing pack of free network admin tools. click here to download it

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.

Need to support users over the internet? click here try our remote control online beta

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

Need to support users over the internet? click here try our remote control online beta

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


Need to support users over the internet? click here try our remote control online beta

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

Need to support users over the internet? click here try our remote control online beta

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.

Need to support users over the internet? click here try our remote control online beta

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}

There is an amazing pack of free network admin tools. click here to download it