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!

Click here if you would like to learn more about our Office 365 Management Platform.