Answered Quota Help

  • Monday, February 27, 2012 7:45 AM
     
     

    Dear All

    Could you please help for the following things

    1.How will get the list of users those who exceeded the Quota.

    2.How can customize the Quota Waring message which is sending to users.

    3.How will get free space in each database.

    If anybody help in this regard it is very valuable.


    Ashraf


All Replies

  • Monday, February 27, 2012 8:21 AM
     
     

    Hi,

    Hope you are refering Exchange mailbox quota, What version do you use?

    ---Cheers

    P


    Padman De Silva

  • Monday, February 27, 2012 8:37 AM
     
     

    Yes

    Exchange mailbox Quota

    we are using exchange 2010


    Ashraf

  • Monday, February 27, 2012 9:03 AM
     
     Proposed Answer

    Run below PowerShell command to View only mailboxes that have exceeded their mailbox quotas


    Get-Mailbox-ResultSize Unlimited | Get-MailboxStatistics | where {$_.StorageLimitStatus-ne "BelowLimit"} | SelectDisplayName,StorageLimitStatus,@{name="TotalItemSize(MB)";expression={[math]::Round(($_.TotalItemSize.Split("(")[1].Split("")[0].Replace(",","")/1MB),2)}},@name="TotalDeletedItemSize(MB)";expression={[math]::Round(($_.TotalDeletedItemSize.Split("(")[1].Split("")[0].Replace(",","")/1MB),2)}},ItemCount,DeletedItemCount| Sort "TotalItemSize (MB)" -Descending | Export-CSV "C:\MyDocuments\Exceeded Quotas.csv" -NoTypeInformation

    You can use
    New-SystemMessagePowerShel command to Change the Default Message which sent to users who exceed Quota

    Also Refer Technet Article

    http://technet.microsoft.com/en-us/library/bb232173.aspx

    http://technet.microsoft.com/en-us/library/bb232089(v=exchg.80).aspx

    To get free space in a Mailbox Database use this command

    Get-MailboxDatabase–Status | fl Name,AvailableNewMailboxSpace

    ----Cheers

    P



    Padman De Silva


  • Tuesday, February 28, 2012 6:37 AM
     
     

    Free space command I am getting blank

    Name                     : FAC-DB5
    AvailableNewMailboxSpace :

    Name                     : EMP-DB5
    AvailableNewMailboxSpace :

    Name                     : VIP-DB1
    AvailableNewMailboxSpace :


    Ashraf

  • Tuesday, February 28, 2012 7:09 AM
     
     
    Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | where {$_.StorageLimitStatus-ne "BelowLimit"} | SelectDis
    ayName,StorageLimitStatus,@{name="TotalItemSize(MB)";expression={[math]::Round(($_.TotalItemSize.Split("(")[1].Split(
    )[0].Replace(",","")/1MB),2)}}, <<<< @name="TotalDeletedItemSize(MB)";expression={[math]::Round(($_.TotalDeletedItemS
    e.Split("(")[1].Split("")[0].Replace(",","")/1MB),2)}},ItemCount,DeletedItemCount| Sort "TotalItemSize (MB)" -Descend
    g | Export-CSV "C:\MyDocuments\Exceeded Quotas.csv" -NoTypeInformation
      + CategoryInfo          : ParserError: (:) [], ParentContainsErrorRecordException
      + FullyQualifiedErrorId : UnrecognizedToken

    Ashraf

  • Wednesday, February 29, 2012 2:41 AM
    Moderator
     
     Answered

    Hi

    Please make sure the Quota is on Single Mailbox or your Mailbox Database, they could be different

    And for Customize Quota Message, please refer to How to Manage Quota Messages

    http://technet.microsoft.com/en-us/library/bb232089(EXCHG.80).aspx 

    Cheers

    Zi Feng


    Zi Feng

    TechNet Community Support

  • Monday, March 05, 2012 1:57 AM
    Moderator
     
     

    Hi

    Any update?

    Cheers


    Zi Feng

    TechNet Community Support