http://blogs.technet.com/b/exchange/archive/2008/02/07/3404839.aspx I tired this script, but seems not work for E14 Is there any a script for E14

http://blogs.technet.com/b/exchange/archive/2008/02/07/3404839.aspx I tired this script, but seems not work for E14 Is there any a script for E14

On Mon, 25 Jul 2011 05:49:28 +0000, jewel qi wrote: > > >http://blogs.technet.com/b/exchange/archive/2008/02/07/3404839.aspx I tired this script, but seems not work for E14 Is there any a script for E14 If the log files contain the same set of columns there's probably no reason why it wouldn' work. What happens when you try running it? --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP

it will create many csv files but most of them are empty, I tired 2 Exchange HUB servers, same result

You can use Get-MessageTrackingLog cmdlet and get these information via powershell. What exactly you need? Below cmdlet will give total number of messages send and receive by HUB01 server. Get-MessageTrackingLog -Server HUB01 -resultsize unlimited | select -Unique messageid | Measure-Object Same way you can add more filters and can get the desired results.>>:::.... if you find it useful, mark this as answer ...:::<< Thanks & Regards, Sandheep [...:::""I can't do it" never yet accomplished anything; "I will try" has performed wonders ":::...]

Hi, Get-Exchangeserver | where {$_.isHubTransportServer -eq $true -or $_.isMailboxServer -eq $true} | Get-Messagetrackinglog -sender user@domain.com -MessageSubject "Subject of message” -Start "8/27/2010 7:00 AM" -End "8/27/2010 11:00 AM" | Select-Object Timestamp,Clienthostname,eventid,source,sender,@{Name="Recipients";Expression={$_.recipients}},Recipientcount,serverhostname,SourceContext | Export-Csv c:\temp\Messageinfo.csv How to Search Message Tracking Logs http://technet.microsoft.com/en-us/library/bb124926(EXCHG.80).aspx Managing Message Tracking http://technet.microsoft.com/en-us/library/bb124375(EXCHG.80).aspx Reference: http://blogs.msdn.com/b/pepeedu/archive/2010/09/02/message-tracking-cmd-lets-in-exchange-2007-exchange-2010.aspxPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

what i want it to caculate how many messages are send/receive by Exchange Org, i don't want to caculate a message twice when it transported by 2 HUB

I think Jewel just want a number which sent/receive from his Exchange org. Because the logprase has not built-in format for exchange 2010, So I think we must be more patient for the new version :) Another way, We could try the performance monitor with "msexchangetransport smtpsend\messages sent total" and "msexchangetransport smtpreceive\messages receive total" to monitor. @moderater, Can you confirm is there possible to count the number which sent/receive from Exchange org? Thanks Regards, Freedom Sun

Hi Have you checked if Steve Goodman's script maybe can do the job for you? http://www.stevieg.org/2011/07/exchange-environment-report-1-5-2-released/ Jonas Andersson | Microsoft Community Contributor Award 2011 | MCITP: EMA 2007/2010 | Blog: http://www.testlabs.se/blog | Follow me on twitter: jonand82

Hi, >Have you checked if Steve Goodman's script maybe can do the job for you? I don't believe Steve's script you posted is match with the requirment. It only count the messages in the mailbox. >i don't want to caculate a message twice when it transported by 2 HUB If there are more than one HUB servers in your organization, it is really difficult to tell if the message is a duplication in another HUB server. When you send a message to anohter mailbox, message will be recorded on each HUB server as long as the message pass through this server. I also read the script tools you posted at beginning, the statistics of report depends on each HUB server as well. The report it generated must have a lot of duplication records between HUB servers in org. >Can you confirm is there possible to count the number which sent/receive from Exchange org? The totally number in organization or the number for each HUB server in org ? If you want to get the number for each HUB server in organization, you can do like that: Get-Exchangeserver | where {$_.isHubTransportServer -eq $true -or $_.isMailboxServer -eq $true} | Foreach {$_.name; Get-Messagetrackinglog -server $_.name -ResultSize unlimited | select-object -unique messageid | Measure-object} And the result should be like: HubServer1 Count : 100 HubServer2 Count : 150Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

On Wed, 27 Jul 2011 07:16:50 +0000, Jason LJS wrote: >>Have you checked if Steve Goodman's script maybe can do the job for you? > >I don't believe Steve's script you posted is match with the requirment. It only count the messages in the mailbox. > >>i don't want to caculate a message twice when it transported by 2 HUB > >If there are more than one HUB servers in your organization, it is really difficult to tell if the message is a duplication in another HUB server. Just make sure you only count unique message-id values and you should have a pretty accurate picture (discounting duplicate messages, but I think those have a distinctive event so they can be counted separately). >When you send a message to anohter mailbox, message will be recorded on each HUB server as long as the message pass through this server. The "SUBMIT" event is also recorded in the MSGTRKM*.log file on the mailbox server role. The other events will be recorded (in the MSGTRK*.log on the HT role) for every message because all messages pass through at least one HT server role. >I also read the script tools you posted at beginning, the statistics of report depends on each HUB server as well. That's true. You must submit both MSGTRK and MSGTRKM logs for analysis. If you don't analyize the MSGTRK files you'll only have SUBMIT events in the output. >The report it generated must have a lot of duplication records between HUB servers in org. The script from MS keeps track of what it reports by using the message-id and the different event types from the log files. It doesn't count the same message more than once. --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP

Hi Rich, >Just make sure you only count unique message-id values and you should have a pretty accurate picture One scenario, If a person send an email to multiple users on different sites, each of HUB server will log this event with the same MessageID. For example, message goes to HUB0 and need to route to both HUB1 and HUB2(two receivers are on site2 and site3 seperately). If we use MessageID to count the number, it should be one. Actually, the submit process happen on both HUB1 and HUB2 server. So the totally number of events should be two because the sender send the message to two different users in difference place. That's why I still cannot understand how the tools get the accurate statistics. >The script from MS keeps track of what it reports by using the message-id and the different event types from the log files. It doesn't count the same message more than once. The same scenario as above, the report only show the number of messages for each HUB server instead of the totally number in the org. For example, HUB0 1, HUB1 1, HUB2 1 Can we simply add these three number together? So we will say the totally number of send/receive is 3? Because as Jewel said "i don't want to caculate a message twice when it transported by 2 HUB" The number he want to get should be 2. How could we deal with that? Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

On Thu, 28 Jul 2011 01:39:25 +0000, Jason LJS wrote: >>Just make sure you only count unique message-id values and you should have a pretty accurate picture > >One scenario, If a person send an email to multiple users on different sites, each of HUB server will log this event with the same MessageID. That's correct, but you're only counting the message-id once >For example, message goes to HUB0 and need to route to both HUB1 and HUB2(two receivers are on site2 and site3 seperately). If we use MessageID to count the number, it should be one. That's because only one message was sent. That one message was *delivered* to multiple recipients, but there will be only one DELIVER event for each individual in your organization or one SEND event to an external recipient. >Actually, the submit process happen on both HUB1 and HUB2 server. SUBMIT events happen only when a message is sent from a RPC client. If your HT server is also a MBX server you'll stll only find the SUBMIT event in the MSGTRKM* log file. >So the totally number of events should be two because the sender send the message to two different users in difference place. No, the messge was DELIVERED twice, it was only SENT once. >That's why I still cannot understand how the tools get the accurate statistics. > >>The script from MS keeps track of what it reports by using the message-id and the different event types from the log files. It doesn't count the same message more than once. > >The same scenario as above, the report only show the number of messages for each HUB server instead of the totally number in the org. Are you analyzing all the log files from all the servers at the same time? >For example, HUB0 1, HUB1 1, HUB2 1 > >Can we simply add these three number together? So we will say the totally number of send/receive is 3? Because as Jewel said "i don't want to caculate a message twice when it transported by 2 HUB" The number he want to get should be 2. It should be 1 for messages SENT no matter how may HT servers touch it. The message will be DELIVERed (just to keep it simple) as many times as there were recipients of the message. >How could we deal with that? By understanding what you're counting. --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP