Hi, hope someone can help.

I am looking for a count on how many emails a particular mailbox has received in one year.

Can someone suggest the best way to do this in Exchange 2013?

Im guessing Powershell is the answer. Ive looked at the Get-MessageTrackingLog command, but it just lists all the addresses with several entries for the one received email with no totals.

All Im after is either a figure for the number of received emails or a basic list that contains the sender email address that could be put in a csv file.

Thanks

To do that you'd need a year's worth of message tracking log files (that's a lot) and then you'd need something to parse them all, which could be a script or a tool like LogParser.

Hi,

Try to use the below command to achieve your requirement:

Get-MessageTrackingLog -ResultSize Unlimited -Start "7/23/2014 8:00AM" -End "7/23/2015 5:00PM" -recipients "test@cu1.com"

You will get the list which all the recipient is test ,then we can use excel to count the numbers.

Regards,

David

Hi

To just get total, you can use below command:

Still make sure you have enough logs to get these counts, means if you want to gather count of one year e-mails so you need to have one year of tracking logs on all transport server.

(Get-transportserver | Get-MessageTrackingLog -ResultSize Unlimited -Start "7/23/2014 8:00AM" -End "7/23/2015 5:00PM" -recipients "test@cu1.com" |  Where {$_.EventID -eq "Deliver"}).count

if you want to check limit of your tracking logs on Transport server, try below command:

Get-TransportServer | ft *trackinglogmax*

Above command will show for how many days logs are being saved and how much capacity?

Regards

Amit Goyal

• Edited by Amit Goyal 1984 17 minutes ago

As suggested above, you should be able to collect these reports using LogParser.

If you unable to get this result using manual process, you may also give try using our Lepide exchange reporter tool that helps to collect the reports on the mailbox traffic of the entire network with details such as, all emails sent and received within a particular duration, emails sent outside and inside organization, interaction between users in a particular duration.

Hi,

Try to use the below command to achieve your requirement:

Get-MessageTrackingLog -ResultSize Unlimited -Start "7/23/2014 8:00AM" -End "7/23/2015 5:00PM" -recipients "test@cu1.com"

You will get the list which all the recipient is test ,then we can use excel to count the numbers.

Regards,

David

• Proposed as answer by Edward van BiljonMVP, Moderator 23 hours 59 minutes ago

Hi,

Try to use the below command to achieve your requirement:

Get-MessageTrackingLog -ResultSize Unlimited -Start "7/23/2014 8:00AM" -End "7/23/2015 5:00PM" -recipients "test@cu1.com"

You will get the list which all the recipient is test ,then we can use excel to count the numbers.

Regards,

David

• Proposed as answer by Edward van BiljonMVP, Moderator Friday, July 24, 2015 7:30 AM

Hi,

Try to use the below command to achieve your requirement:

Get-MessageTrackingLog -ResultSize Unlimited -Start "7/23/2014 8:00AM" -End "7/23/2015 5:00PM" -recipients "test@cu1.com"

You will get the list which all the recipient is test ,then we can use excel to count the numbers.

Regards,

David

• Proposed as answer by Edward van BiljonMVP, Moderator Friday, July 24, 2015 7:30 AM

Hi

To just get total, you can use below command:

Still make sure you have enough logs to get these counts, means if you want to gather count of one year e-mails so you need to have one year of tracking logs on all transport server.

(Get-transportserver | Get-MessageTrackingLog -ResultSize Unlimited -Start "7/23/2014 8:00AM" -End "7/23/2015 5:00PM" -recipients "test@cu1.com" |  Where {$_.EventID -eq "Deliver"}).count

if you want to check limit of your tracking logs on Transport server, try below command:

Get-TransportServer | ft *trackinglogmax*

Above command will show for how many days logs are being saved and how much capacity?

Regards

Amit Goyal

• Edited by Amit Goyal 1984 Friday, July 24, 2015 7:10 AM
• Proposed as answer by Edward van BiljonMVP, Moderator 23 hours 59 minutes ago

Hi

To just get total, you can use below command:

Still make sure you have enough logs to get these counts, means if you want to gather count of one year e-mails so you need to have one year of tracking logs on all transport server.

(Get-transportserver | Get-MessageTrackingLog -ResultSize Unlimited -Start "7/23/2014 8:00AM" -End "7/23/2015 5:00PM" -recipients "test@cu1.com" |  Where {$_.EventID -eq "Deliver"}).count

if you want to check limit of your tracking logs on Transport server, try below command:

Get-TransportServer | ft *trackinglogmax*

Above command will show for how many days logs are being saved and how much capacity?

Regards

Amit Goyal

• Edited by Amit Goyal 1984 Friday, July 24, 2015 7:10 AM
• Proposed as answer by Edward van BiljonMVP, Moderator Friday, July 24, 2015 7:30 AM

Hi

To just get total, you can use below command:

Still make sure you have enough logs to get these counts, means if you want to gather count of one year e-mails so you need to have one year of tracking logs on all transport server.

(Get-transportserver | Get-MessageTrackingLog -ResultSize Unlimited -Start "7/23/2014 8:00AM" -End "7/23/2015 5:00PM" -recipients "test@cu1.com" |  Where {$_.EventID -eq "Deliver"}).count

if you want to check limit of your tracking logs on Transport server, try below command:

Get-TransportServer | ft *trackinglogmax*

Above command will show for how many days logs are being saved and how much capacity?

Regards

Amit Goyal

• Edited by Amit Goyal 1984 Friday, July 24, 2015 7:10 AM
• Proposed as answer by Edward van BiljonMVP, Moderator Friday, July 24, 2015 7:30 AM
• Marked as answer by mij2014 19 hours 46 minutes ago

thanks - this did the trick.