Reporting on User and Mailbox types in Office 365
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 software 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!