Count of emails sent by a particular id to my employee

Question

Count of emails sent by a particular id to my employee

Jonathan Priyaraj 160

I want to get count of all emails sent from a particular email addresses to my employee in last two months. For eg : number of emails ******@gmail.com has sent to ******@contoso.com in last 2 months. Please send me powershell query compatible with exchange 2016 version.

1 answer

Your answer

Answer 1

Dennis Goedegebuure 11 MVP

I would suggest to use the Get-MessageTrackingLog cmdlet of PowerShell. They also have an example in the documentation for that cmdlet:

https://learn.microsoft.com/en-us/powershell/module/exchange/get-messagetrackinglog?view=exchange-ps#example-1

Try something like below

$messages = Get-MessageTrackingLog -Server Mailbox01 -Start "01/21/2024 09:00:00" -End "03/21/2024 17:00:00" -Sender "******@gmail.com"
$messages.Count

Jonathan Priyaraj 160 Reputation points

2024-03-22T09:32:10.4333333+00:00

Hi Dennis. This query is giving a wrong result. I cross verified it. The user has sent only 4 emails to my employee. But it is showing 25 as the result .
Jonathan Priyaraj 160 Reputation points

2024-03-22T10:03:19.77+00:00

Hi Dennis. Thanks for your reply. But this query is not working. I cross verified it. Actual count is 4 emails but it is showing as 25. Do you have any other alternatives?
Anonymous

2024-03-25T09:43:38.8466667+00:00

Hi Jonathan Priyaraj,

You can try this form command:

Get-MessageTrackingLog -Start "01/21/2024 09:00:00" -End "03/21/2024 17:00:00" | Where-Object {$_.Sender -eq "******@gmail.com"} | Measure- Object | Select-Object -ExpandProperty Count
Anonymous

2024-03-28T02:36:54.6466667+00:00

If you need further help, please feel free to reply this post directly so we will be notified to follow it up.

Just checking in to see if above information was helpful. Please let us know if you would like further assistance.

Share via

Count of emails sent by a particular id to my employee

1 answer

Your answer