Mailbox size report

Posted on 2009-04-28
Medium Priority
Last Modified: 2012-05-06
Hi everyone-

I have found several scripts to run in Powershell that suposedly create a .csv or .txt file. Any way to find out WHERE it creates it? :D

EDIT: Ok never mind on the WHERE is it idea. figured that out. Was wondering if there is a way to get the Size in MB insteat of Bytes.
get-mailbox | get-mailboxstatistics | select-object DisplayName,TotalItemSize,StorageLimitStatus,LastLogonTime | export-csv mbxreport.csv

Open in new window

Question by:Willie2232

Assisted Solution

grandebob earned 400 total points
ID: 24255387
if you don't specify a full path (c:\temp\mbxreport.csv) it will put the file in your profile's default directory. easiest way to find one you've all ready done is just search your hard drive for the filename, be sure to include hidden/system folders.
LVL 71

Accepted Solution

Chris Dent earned 600 total points
ID: 24255532

It places output in the directory you ran the command from if you didn't give it a full name, nothing more to it than that :)

It should just need this for a conversion up to Mb:

Get-MailboxStatistics |  Select-Object DisplayName, `
  { $_.TotalItemSize.Value.ToMb() }, StorageLimitStatus, LastLogonTime `
  | Export-CSV mbxreport.csv

The ` character just allows it to continue over multiple lines, for pretty code. And "Get-Mailbox" is not necessary as Get-MailboxStatistics accepts the same parameters for Identity (running it with nothing specific will return data for all users).


Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to fix “Unable to mount database. (hr=0x80004005, ec=1108)”.
If you have come across a situation where you need to find some EDB mailbox recovery techniques, then here you will find the same. In this article, we will take you through three techniques using which you will be able to perform EDB recovery. You …
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…
how to add IIS SMTP to handle application/Scanner relays into office 365.
Suggested Courses
Course of the Month14 days, 15 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question