<div>
You ccan use this :<br />
<br />
Get-MailboxStatistics | export-csv test.csv | where {$_.ObjectClass -eq &quot;Mailbox&quot;} | Sort-Object TotalItemSize -Descending | ft DisplayName,TotalItemSiza,<wbr />ItemCount,<wbr />StorageLim<wbr />itStatus<br />
<br />
and arrange them using excel &nbsp;to remove mailboxes larger then 10 GB<br />

</div>


You ccan use this :

Get-MailboxStatistics | export-csv test.csv | where {$_.ObjectClass -eq "Mailbox"} | Sort-Object TotalItemSize -Descending | ft DisplayName,TotalItemSiza,ItemCount,StorageLimitStatus

and arrange them using excel  to remove mailboxes larger then 10 GB


<div>
I agree with Suliman.<br />
<br />
For more details on powershell commands<br />
Go get it at <a href="http://go.microsoft.com/?linkid=5719336" rel="ugc">http://go.microsoft.com/?linkid=5719336</a>
</div>


I agree with Suliman.

For more details on powershell commands
Go get it at http://go.microsoft.com/?linkid=5719336 [http://go.microsoft.com/?linkid=5719336]

<div>
Hi guys,<br />
<br />
I tried pasting the above code in a notepad and rename it mailboxsize.ps2, but when I run it from EMS it opens up the code.<br />
Is there anything that I need to paste in the script?<br />
<br />
Thanks
</div>


Hi guys,

I tried pasting the above code in a notepad and rename it mailboxsize.ps2, but when I run it from EMS it opens up the code.
Is there anything that I need to paste in the script?

Thanks

<div>
it should be .ps1 and not .ps2
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I am trying to get a report that will list all the mailboxes that are less than 10 GB. &nbsp;I've used the following command but is gives me a lot of information that I do not need and it lists them by Byte size not GB.<br />
<br />
get-mailbox |get-mailboxstatistics | export-csv test.csv| sort-object totalitemsize -descending |ft DisplayName,@{label=&quot;Total<wbr />ItemSize(M<wbr />B)&quot;;expres<wbr />sion={$_.T<wbr />otalItemSi<wbr />ze.Value.T<wbr />oMB()}},It<wbr />emCount<br />
<br />

</div>
</div>


Hi,
I am trying to get a report that will list all the mailboxes that are less than 10 GB.  I've used the following command but is gives me a lot of information that I do not need and it lists them by Byte size not GB.

get-mailbox |get-mailboxstatistics | export-csv test.csv| sort-object totalitemsize -descending |ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount



exchange 2007 mailbox size

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.