#PSTip Count the number of mailboxes per department

Yesterday I got an email asking for help to create a report of all user mailboxes in Exchange per department. When you execute a Get-Mailbox command, you’ll see that the Department property is not included in the result.

[PS]> Get-Mailbox shay |  Get-Member d*

   TypeName: Microsoft.Exchange.Data.Directory.Management.Mailbox

Name                                 MemberType Definition
----                                 ---------- ----------
Database                             Property   Microsoft.Exchange.Data.Directory.ADObjectId Database {get;}
DeliverToMailboxAndForward           Property   bool DeliverToMailboxAndForward {get;set;}
DisabledArchiveDatabase              Property   Microsoft.Exchange.Data.Directory.ADObjectId DisabledArchiveDatabase...
DisabledArchiveGuid                  Property   guid DisabledArchiveGuid {get;}
DisplayName                          Property   string DisplayName {get;set;}
DistinguishedName                    Property   string DistinguishedName {get;}
DowngradeHighPriorityMessagesEnabled Property   bool DowngradeHighPriorityMessagesEnabled {get;set;}

The Department property is a part of the Get-User cmdlet.

[PS]> Get-User shay | Format-Table Name,Department -AutoSize

Name      Department
----      ----------
Shay Levy Computers

The most common solution is to invoke the Get-User command for each mailbox object and grab its Department property:

Get-Mailbox | Select-Object Name,@{n='Department';e={ ($_ |Get-User).Department}}

But that requires executing two cmdlets to get the information. We can generate a quick report of users count per department:

Get-User -ResultSize Unlimited | Group-Object Department -NoElement

What about mailboxes? You can try and filter the results of the above command to include just user mailboxes using a Where-Object command, but a better way would be to use one of the parameters of the Get-User cmdlet and filter the objects as early as you can.

Get-User -ResultSize Unlimited -RecipientTypeDetails UserMailbox |
Group-Object Department -NoElement | Sort-Object Count -Descending
Filed in: Columns, Tips and Tricks Tags: , ,
© 2018 PowerShell Magazine. All rights reserved. XHTML / CSS Valid.
Proudly designed by Theme Junkie.
%d bloggers like this: