none
export report with all over quota mailboxes only RRS feed

  • Question

  • Dear All

    Good Day
    i was trying to export report with all over quota mailboxes only whether over the default DB limits quota or over the exception quota if mailboxes have exception set other than the DB default limits.

    I was trying the below command  but nothing exported:

    Get-MailboxDatabase | Get-MailboxStatistics | Where-Object {$_.StorageLimitStatus -match 'IssueWarning|ProhibitSend|MailboxDisabled'} | Export-Csv C:\New\OverSize8.CSV –NoTypeInformation –Encoding UTF8

    is there any mistake or another command can help me to export report of over quota mailboxes only.

    My Exchange version: Exchange 2013 CU15
    Thursday, June 13, 2019 7:30 AM

All replies

  • I'd change your Where condition to:

    {$_.StorageLimitStatus -like "*IssueWarning*" -or $_.StorageLimitStatus -like "*ProhibitSend*" -or $_.StorageLimitStatus -like "*MailboxDisabled*"}

    I'd also put a Select-Object after the Where command to specify the properties you want to export rather than all of them.  You want to be careful with -match because it works with regular expressions, so if you aren't trying to use a regular expression, you might get unexpected results.


    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
    Celebrating 20 years of providing Exchange peer support!


    Thursday, June 13, 2019 7:53 PM
    Moderator
  • Hi,

    Please check to see if StorageLimitStatus is empty when you run Get-MailboxStatistics cmdlet. Unlike versions of Exchange Server Information Store earlier than Exchange Server 2013 Information Store, the new Information Store does not cache the values of mailbox quotas. You can check this to know more about the symptom: Empty StorageLimitStatus field when you run the Get-MailboxStatistics cmdlet in Exchange Server 2013 or Exchange Server 2016

    If StorageLimitStatus is empty in your environment, you can try to get the mailbox quota usage instead. Here a script may give you some useful information: Exchange 2013 mailbox quota usage and size report . You can start with it, and make some modification to reach your requirements.

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

    Regards,

    Lydia Zhou


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, June 14, 2019 6:47 AM
    Moderator
  • Hi,

    Did you try the script provided above? 

    If you have solved your problem, could you share with us? Maybe it will help more people with similar problems. 

    Regards,

    Lydia Zhou


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, June 19, 2019 1:41 AM
    Moderator