• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 705
  • Last Modified:

PowerShell-Exchange 2010-Mailbox sze, User name, and Mailbox DB

I have just joined here, and they dont have any mailbox limit, so i am trying to generate a report for all the users (i.e. around 400), to get there username, with there mailbox size and in the database they are associated with, because over here they have couple of different databases in different drives.
So would it possible i can generate a report into a CSV file.

When i open up powershell, if i run a command under c:\windows\system32...it says i dont have permissions? so would it be ok if i run the command just under c:\, make up a folder and generate the report in that folder.

  • 2
2 Solutions
Normally, you can use EMS (Exchange Management Shell). Try below code:

Get-Mailbox -ResultSize Unlimited | Select-Object alias,IssueWarningQuota,Database,@{Name='Size (MB)';expression={$mbx = Get-MailboxStatistics $_.alias; $mbx.totalitemsize.value.toMB() }},@{Name='Storage Limit Status';expression= { $mbx = Get-MailboxStatistics $_.alias; $mbx.StorageLimitStatus }} >c:\status.csv

Open in new window

First, make sure you open the Exchange Managment Shell, and not regular Powershell.  if you are a member of the Organizer Management group you shouldn't run into any permissions problems.  As for the command, run this:

get-mailbox -resultsize unlimited |select displayname,database | export-csv c:\mailboxes.csv -NoTypeInformation
LeoAuthor Commented:
Found the answer as i was typing my response.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now