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

exchange 2007 mailbox size

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

0
annayeg
Asked:
annayeg
1 Solution
 
Suliman Abu KharroubIT Consultant Commented:
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
0
 
ontechCommented:
I agree with Suliman.

For more details on powershell commands
Go get it at http://go.microsoft.com/?linkid=5719336
0
 
AkhaterCommented:
the below code will do what you want and will show the output in GB

in the line "$mbxSize -lt 10" replace the 10 by any number if you want another threshold in GB


$mbxs = get-mailbox -resultsize unlimited

$all = @()

foreach ($mbx in $mbxs){

  
  $mbxStat = get-MailboxStatistics -identity $mbx

  $mbxSize = $mbxStat.TotalItemSize.Value.toGB()
       
  if ($mbxSize -lt 10){
     
     $out = new-object psobject 

     $out | add-member noteproperty Identity $mbx.name
     $out | add-member noteproperty Database $mbx.database
     $out | add-member noteproperty MailboxSize $mbxSize

     $all += $out
   }

   
   
} 

$all = $all | Sort-Object MailboxSize -Descending

$all | export-csv c:\list.csv

Open in new window

0
 
annayegAuthor Commented:
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
0
 
AkhaterCommented:
it should be .ps1 and not .ps2
0
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

Improved Protection from Phishing Attacks

WatchGuard DNSWatch reduces malware infections by detecting and blocking malicious DNS requests, improving your ability to protect employees from phishing attacks. Learn more about our newest service included in Total Security Suite today!

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