none
how to find daily outgoing mail volume in exchange

    Question

  • I want to view the traffic volume for Exchange 2007. We want to go for SMTP relay service and the supplier has given quote in terms of GB per month  I am not sure how to calculate daily smtp traffic for outside the domain. Please help
    Monday, February 15, 2010 2:21 PM

Answers

  • This is one of the major issues with Exchange. You can use third party tools to get a report for amount and size of outbound emails; quest makes a tool, promodag, etc.

     

    Now if you don’t want to use third party tools you can look through the tracking logs for the size of each message and export the size of each message using a powershell over a period of time. For example below I used the powershell command to get the entire “Send” messages from the first of this month to yesterday and grab the field totalbytes size. Once the data is collected it is exported to Excel so I can grab the sum total of the messages.
     

    Get-MessageTrackingLog -eventid "send" -start "02/01/2010 00:00:00" -end "02/14/2010 00:00:00" | select-object totalbytes | export-csv c:\test1.csv

     

    This is what the output file should look like

    14076

    18140

    24041

    Etc

     

    At the last column I added the command  =SUM(A3:A94) (you will replace A3:A94 with the cell range from your output file). The SUM column will provide me with the total outbound size in KB. There are free calculator sites that will convert the KB to MB or GB (http://egret.net/kb__mb.htm)

    .Please visit my blogs at  http://cbfive.com/blog


    Chris cbfive.com
    • Proposed as answer by Christopher Crandall Wednesday, February 17, 2010 4:47 AM
    • Marked as answer by Alan.Gim Friday, February 26, 2010 3:35 AM
    Monday, February 15, 2010 3:36 PM

All replies

  • You can extract that information from your message tracking logs.  How far back do you have log data?

    Monday, February 15, 2010 2:36 PM
  • This is one of the major issues with Exchange. You can use third party tools to get a report for amount and size of outbound emails; quest makes a tool, promodag, etc.

     

    Now if you don’t want to use third party tools you can look through the tracking logs for the size of each message and export the size of each message using a powershell over a period of time. For example below I used the powershell command to get the entire “Send” messages from the first of this month to yesterday and grab the field totalbytes size. Once the data is collected it is exported to Excel so I can grab the sum total of the messages.
     

    Get-MessageTrackingLog -eventid "send" -start "02/01/2010 00:00:00" -end "02/14/2010 00:00:00" | select-object totalbytes | export-csv c:\test1.csv

     

    This is what the output file should look like

    14076

    18140

    24041

    Etc

     

    At the last column I added the command  =SUM(A3:A94) (you will replace A3:A94 with the cell range from your output file). The SUM column will provide me with the total outbound size in KB. There are free calculator sites that will convert the KB to MB or GB (http://egret.net/kb__mb.htm)

    .Please visit my blogs at  http://cbfive.com/blog


    Chris cbfive.com
    • Proposed as answer by Christopher Crandall Wednesday, February 17, 2010 4:47 AM
    • Marked as answer by Alan.Gim Friday, February 26, 2010 3:35 AM
    Monday, February 15, 2010 3:36 PM
  • The posts may also help in this thread


    James Luo
    TechNet Subscriber Support (http://technet.microsoft.com/en-us/subscriptions/ms788697.aspx)
    If you have any feedback on our support, please contact tngfb@microsoft.com
    Wednesday, February 24, 2010 2:07 AM