Unveiling Primary Mailbox Statistics

Keep your Microsoft Exchange environment running smoothly with these simple PowerShell commands.

Primary Mailbox Insights

Want to know how much space primary mailboxes are using? This single command gives you a clear picture of storage status, item count, and total size:

PowerShell Command

Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select DisplayName, StorageLimitStatus, @{Name = "TotalItemSize (MB)"; Expression = {[math]::Round(($_.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",", "") / 1MB), 2)}}, ItemCount | Sort "TotalItemSize (MB)" -Descending | Export-CSV "C:\temp\All Mailboxes.csv" -NoTypeInformation

This command does all the heavy lifting:

  • It fetches all user mailboxes fast.
  • It gathers essential stats like size and item count.
  • It converts sizes to MB for easy reading.
  • It sorts mailboxes from largest to smallest.
  • And finally, it exports everything to a neat CSV file for you.

Archive Mailbox Deep Dive

Need to check your archive mailboxes? Here’s a dedicated command for that:

PowerShell Command

Get-Mailbox -ResultSize Unlimited -Archive | Get-MailboxStatistics | Select DisplayName, StorageLimitStatus, @{Name = "TotalItemSize (MB)"; Expression = {[math]::Round(($_.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",", "") / 1MB), 2)}}, ItemCount | Sort "TotalItemSize (MB)" -Descending | Export-CSV "C:\temp\All Archive Mailboxes.csv" -NoTypeInformation

Why These Reports Matter

These reports are more than just data; they are powerful tools for better IT management:

  • Spot potential issues early: See who's nearing their storage limits.
  • Boost efficiency: Easily identify mailboxes for cleanup.
  • Plan smartly: Forecast storage needs and optimize your E3/E5 licensing.
  • Simplify reporting: Provide clear insights to leadership and compliance teams.

Pro Tip:

For large organizations, run these commands during **off-peak hours** to avoid any performance hiccups.

With these reports, you gain crucial visibility, helping you optimize your IT operations proactively and effectively.

Comments

Post a Comment

Popular posts from this blog

PowerShell Basics for Office 365 Administration (Episode 3)

At its core, PowerShell is designed around the concept of objects. Unlike traditional command-line interfaces that often work with text streams, PowerShell processes structured data in the form of objects. Understanding how objects, properties, and methods function, how variables store and manage this data, and how the pipeline enables seamless command chaining is fundamental to effective Office 365 administration. Understanding Objects, Properties, and Methods In the world of PowerShell, virtually everything you interact with is an object. An object is a structured data entity representing specific items, whether it's a user account, a mailbox, a group, or a system service. These objects possess two primary characteristics: Properties: These are the attributes or characteristics that describe the object. For example, a mailbox object might have properties like DisplayName , EmailAddresses , or RecipientTypeDetails . Methods: These represent the actions or functions that the ob...
Read more

PowerShell Basics for Office 365 Administration (Episode 4): Conditional Logic and Looping Structures

Welcome back to our PowerShell Basics series! In the previous episodes, we've covered connecting to Office 365 services (now primarily using Microsoft Graph), using cmdlets to retrieve and manage objects, and understanding variables and the pipeline. You now have the tools to interact with your environment. However, administration tasks often involve dealing with many objects (users, mailboxes, licenses) or performing actions only when certain conditions are met. Manually running commands for each item or decision is tedious and prone to errors. This is where the true power of scripting comes in, using conditional logic to make decisions and looping structures to process multiple items efficiently. A Note on Modules: As the MSOnline and AzureAD PowerShell modules are being retired, it's crucial to transition to the Microsoft.Graph PowerShell module. All examples in this episode will use Graph PowerShell for user and group management. For Exchange Online examples, we ...
Read more