Back to blog

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!