locked
How to extract the totol mailbox size for all the user in exchange 2007 by using power shell. RRS feed

  • Question

  • Hi All,

    May I know how to extrace total mailbox size assign for all the user in exchnage 2007 by using power shell?

    Thank you.

     

     

     


    Doreen
    Monday, March 14, 2011 1:09 AM

Answers

  • On Mon, 14 Mar 2011 02:14:09 +0000, Doreenng wrote:
     
    >I looking for is quotas for each user mailbox size or prohibit send at for each user.
     
    Quotas aren't the same as mailbox size.
     
    If you want just the quotas imposed on mailboxes, try this:
     
    Get-mailbox -resultsize unlimited | ft
    displayname,prohibitsend*,issuewarn*,UseDatabaseQuotaDefaults
     
    ---
    Rich Matheisen
    MCSE+I, Exchange MVP
     

    --- Rich Matheisen MCSE+I, Exchange MVP
    • Marked as answer by Doreenng Monday, March 14, 2011 8:14 AM
    Monday, March 14, 2011 3:12 AM

All replies

  • On Mon, 14 Mar 2011 01:09:37 +0000, Doreenng wrote:
     
    >May I know how to extrace total mailbox size assign for all the user in exchnage 2007 by using power shell?
     
    The get-mailboxstatistics cmdlet, with no qualifiers will will tell
    you the size of each mailbox on the server.
     
    The get-mailbox cmdlet with no qualifiler will return all the
    mailboxes in the organization. Piping the results into
    get-mailboxstatistics will get you the size of each of those
    mailboxes. Piping the results of get-mailboxstatistics into a
    measure-object cmdlet will get you a total of all the mailbox sizes
     
     
    This should do it:
     
    get-mailbox -resultsize unlimited | get-mailboxstatistics |
    measure-object -property totalitemsize -sum
     
    ---
    Rich Matheisen
    MCSE+I, Exchange MVP
     

    --- Rich Matheisen MCSE+I, Exchange MVP
    Monday, March 14, 2011 1:31 AM
  • Hi,

    May I know how to extrace total mailbox size assign for each users in exchnage 2007 by using power shell? As the above command is for total mailboxstatistics..

    Thank you.

     


    Doreen
    Monday, March 14, 2011 1:55 AM
  • The command above gives the total of all mailbox sizes, in other words, the total of all items in currently everyone's mailbox. Were you looking for something different, like the total of all mailbox size quotas?

     

    Monday, March 14, 2011 2:00 AM
  • Hi,

    I looking for is quotas for each user mailbox size or prohibit send at for each user.

    Thank you.

     


    Doreen
    Monday, March 14, 2011 2:14 AM
  • On Mon, 14 Mar 2011 01:55:33 +0000, Doreenng wrote:
     
    >May I know how to extrace total mailbox size assign for each users in exchnage 2007 by using power shell? As the above command is for total mailboxstatistics..
     
    Well, you requested "total mailbox size assign for all the user". That
    little bit of code prodces the total.
     
    If you want the individual mailbox size:
    get-mailbox|get-mailboxstatistics|select displayname,totalitemsize
     
    ---
    Rich Matheisen
    MCSE+I, Exchange MVP
     

    --- Rich Matheisen MCSE+I, Exchange MVP
    Monday, March 14, 2011 3:07 AM
  • On Mon, 14 Mar 2011 02:14:09 +0000, Doreenng wrote:
     
    >I looking for is quotas for each user mailbox size or prohibit send at for each user.
     
    Quotas aren't the same as mailbox size.
     
    If you want just the quotas imposed on mailboxes, try this:
     
    Get-mailbox -resultsize unlimited | ft
    displayname,prohibitsend*,issuewarn*,UseDatabaseQuotaDefaults
     
    ---
    Rich Matheisen
    MCSE+I, Exchange MVP
     

    --- Rich Matheisen MCSE+I, Exchange MVP
    • Marked as answer by Doreenng Monday, March 14, 2011 8:14 AM
    Monday, March 14, 2011 3:12 AM
  • Hi,


    You can use this command in powershell:

    get-mailboxdatabase -Identity 'Server\Storage Group\database name' | get-mailboxstatistics | FT Displayname,Itemcount,TotalItemSize


    This will get you all the mailboxes, their size and total items in their mailboxes.

    I am really grateful for all your replies.

    Thanks

    Monday, March 14, 2011 6:09 AM