Chat with us, powered by LiveChat

Blog

Back

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!