Reporting on User and Mailbox types in Office 365

27 Sep 2012 by Dan Rose

This article will show you how to create a report showing how many users, mailboxes and mailbox types you have in Office 365.
The PowerShell cmdlet below will show you a break down of the number of mailboxes you have by their type; be it User Mailboxes, Room Mailboxes, Shared Mailboxes and so forth.
If you don’t have time to mess about with PowerShell, our Office 365 reporting application includes a very detailed report showing this information.
Otherwise jump right in and connect to Office 365 using PowerShell. Then run the following cmdlet:

Get-User | Group RecipientTypeDetails

Using this simple one liner you can group all mailbox types and counts into a simple and effective report.

Count Name Group ----- ---- ----- 45 User {andyj, cogmotivereports, jimm, carls...} 211 UserMailbox {barry, ben, chris, cynthia...} 12 RoomMailbox {ConferenceRoom1, ConferenceRoom2} 1 DiscoveryMailbox {DiscoverySearchMailbox{D919BA05-46A6-415f-80AD-7E}} 41 SharedMailbox {Shared1}

If you then wanted to expand on each group then you can type another one-liner to expand on each RecipientType.

Get-User | where {$_.RecipientTypeDetails -eq "UserMailbox"} Name RecipientType ---- ------------- John UserMailbox Ben UserMailbox Chris UserMailbox Simon UserMailbox Dan UserMailbox David UserMailbox Carol UserMailbox Bob UserMailbox Melissa UserMailbox Tim UserMailbox Tom UserMailbox
Simple!