Mailbox usage/activity reports for Shared, room and equipment mailbox

[Robomurphy]

Hi!

We have a lot of Shared, room and equipment mailbox. I'm looking for a way to clean up the ones that's not in use.

Is there anyway i can do this for Shared, room and equipment mailbox?
The Email activity reports that exists in admin gui only works for licensed users.

I figure i could do something with audit logs, however doing audit logs on 3000+ mailboxes is very time consuming, is there any script available for doing this on multiple mailboxes?

[#2 · Accepted solution]

The Mailbox usage report should feature Shared mailboxes now. Apart from that, script away :)

Instead of looking at audit log events, you can do something simpler such as checking the newest message in Inbox/Sent items?

Get-MailboxFolderStatistics shared -FolderScope Inbox -IncludeAnalysis -IncludeOldestAndNewestItems | select *ItemReceivedDate,*ItemLastModifiedDate

[#3]

Aha, did not know that! Thanks. That makes my job alot easier. Too bad it doesnt include room/equipment mailboxes aswell.

But maybe i use newest message in inbox/sent for that. Thanks for help!

[#4]

Hi @Robomurphy you can get multiple reports on the room mailbox usage using the PowerShell Script. By using this Microsoft Graph PowerShell Script, you can able to find popular meeting rooms, identify active meeting organizers and analyze daily usage patterns for all exchange meeting rooms. In addition to this You can able to view Exchange Online individual room mailbox usage statistics. https://o365reports.com/2023/05/23/get-office-365-room-mailbox-usage-statistics-using-powershell