Solved Powershell script to report on total send/received e-mails in Exchange

---

Hi, I currently have the below setup but whenever I run it I get the email to my inbox but does not give me the numbers for the total amount of emails sent/received. Can anyone help?

$mailbox=""

$startDate=Get-Date
$endDate=Get-Date

$startDateFormatted=$startDate.AddDays(-7).ToShortDateString()
$endDateFormatted=$endDate.AddDays(-1).ToShortDateString()

$emailFrom = "no-reply@domain.com"
$emailTo = ""
$subject = "Weekly e-mail report"
$smtpServer = ""

$sendCount = Get-TransportServer | Get-MessageTrackingLog -Start "$startDateFormatted 00:00:00" -End "$endDateFormatted 23:59:59" - Sender $mailbox -resultsize unlimited | select-object -unique MessageId

$receiveCount = Get-TransportServer | Get-MessageTrackingLog -Start "$startDateFormatted 00:00:00" -End "$endDateFormatted 23:59:59" -Recipients $mailbox -resultsize unlimited | select-object -unique MessageId

$sendCountString = $sendCount.count
$receiveCountString = $receiveCount.count

$body = "Mailbox stats for: $mailbox $nl
Report date range: $startDateFormatted 00:00:00 - $endDateFormatted 23:59:59 $nl
Total e-mails sent: $sendCountString $nl
Total e-mails received: $receiveCountString"

$smtp = new-object Net.Mail.SmtpClient($smtpServer)
$smtp.Send($emailFrom, $emailTo, $subject, $body)

PS, we have Office365 also but I do not see the option to schedule report that way.

Thanks

Waqkas,

Powershell can be a little tricky at times, but fear not, there is always an answer.

Here are two examples of scripts that do what you are trying to accomplish:

https://www.pickysysadmin.ca/2017/08/16/powershell-script-to-report-on-total-sendreceived-e-mails-in-exchange-v2-0/

https://gallery.technet.microsoft.com/office/f2af711e-defd-476d-896e-8053aa964bc5

Each takes a different approach, but gets to the same place.

I would suggest that you take a look at the code used for both, and see which elements work best for you. (I think that the first of the two links will probably be the one to base your adjustments off of, as it works with Exchange 2016)

Hope that helps.

Cheers,

Adam

Hi Adam, I will give it a try.

What I am looking for though is to pull a report on a weekly basis for a few selected users.

We currently have Ofice365 setup with Exchange 2010.

Thanks

No problem,

Try this one, as it is specific to EX 2010, and should be more helpful. read ALL the way through the commentary chain, as there are some "tweeks" that will be helpful to refine the outcome, and they are listed further down.

Good Luck:

https://community.spiceworks.com/topic/168519-exchange-2010-reports-on-users-daily-weekly-activity

Thank you Adam, I managed to modify the script from the your second suggestions and managed to get it working.

Thanks.

Waqkas,

Great !!! glad it worked. If you have any additional questions, let me know.

@Adam-Gordon Thanks for linking my script!