locked
List of exchange users with mailbox size per database. RRS feed

  • Question

  • Hello Friends,

    Need small help i need to take out the list of users start with Alphabet A, B , C till Z per database along with their mailbox size limit so is there any simple way to get the list.

    Thanks

    Amit

    Monday, December 23, 2013 10:47 AM

Answers

  • Hi,

    How about this?

    http://help.outlook.com/en-us/140/gg576861.aspx

    EDIT: Or maybe this:

    $out = @()
    
    $users = Get-Mailbox -ResultSize Unlimited
    
    ForEach ($user in $users) {
    
        $userMailboxStatistics = Get-MailboxStatistics $user
    
        $props = @{
            Username = $user.SamAccountName
            DisplayName = $user.DisplayName
            Database = $user.Database
            OrganizationalUnit = $user.OrganizationalUnit
            'Quota Status' = $userMailboxStatistics.StorageLimitStatus
            TotalItemSize = $userMailboxStatistics.TotalItemSize
        }
    
        $out += New-Object PsObject -Property $props
    
    }
    
    $out | Sort-Object Database,DisplayName | Export-Csv .\mbxDetails.csv -NoTypeInformation

    Adjust the $props hash as needed to add/remove properties to the output object.


    Don't retire TechNet! - (Don't give up yet - 12,420+ strong and growing)


    • Edited by Mike Laughlin Monday, December 23, 2013 3:19 PM
    • Marked as answer by Bill_Stewart Tuesday, February 18, 2014 7:42 PM
    Monday, December 23, 2013 2:11 PM