Powershell to determin how many emails are over 2 years old O365

Question

Hi

Can anyone help me? We have a Hybrid on-prem Exchange / O365 environment

I am trying to find a way to produce a report which will give me a total number of emails per user that are over 2 years old, I don't want to know any details of the email, I just want a count of how many there are.

Thanks in advance.

Answer 1

@Claire Hicken

You need to user "New-MailboxSearch" command to create mailbox search for those mailboxes:

Get-Mailbox | where{$_.RecipientTypeDetails -eq "UserMailbox"} |foreach{ New-MailboxSearch -Name $_.Name  -SourceMailboxes $_.Name -StartDate "08/29/2019" -EndDate "8/30/2021" -EstimateOnly}  

Then use command below to start those search requests:

Get-MailboxSearch | Start-MailboxSearch  

Wait a long time, because the Mailbox Search may take a long time to run.
Then, you could use command below to check the completed search request:

Get-MailboxSearch | where{$_.Status -eq "EstimateSucceeded"} | fl Name,ResultNumberEstimate   

You could use command below to check status for all requests:

Get-MailboxSearch  

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.