Hi SpiceHeads,

Just migrating over to 365, looking at shared mailboxes at the moment. We have about 4500 of them but I am told that about 75% of these are not being used.

Does anyone know any useful scripts etc to see the last time an email was sent from or to these mailboxes?

I am just trying to work out a quick way to eliminate the really old rubbish ones.

Any ideas folks?

Cheers,

Dan

3 Spice ups

Hi there, I think these articles may help, however for querying 4500 mailboxes may just take a bit of time, you may want to limit the last 30 days.

https://social.technet.microsoft.com/Forums/en-US/2131381c-75b7-4d6b-b733-db103e81c668/get-mailbox-last-sent-mail-date?forum=exchangesvradminlegacy

1 Spice up

Here is what I ran across: Exchange Powershell Question - Last Sent Emails from Mailbox | Microsoft Learn . I haven’t used the script listed in the answer myself, but it looks like it should work unless things are significantly different about 2010 and 2013 in the Message Tracking Logs.

1 Spice up

TRy this. It’s a report I use for tracking mailbox sizes. It also reports the last access date when a client (outlook, smartphone, etc) opened that mailbox.

Rename the text file to .ps1 and run from the exchange powershell console.

MBX_Report2013.txt (3.59 KB)

I ran the script that Sosipater provided in my Exchange 2013 lab and it worked, please have a try.

1.16.1.png1.16.2.png