Hi

I want to determine mailbox sizes of users who are enabled in Active Directory. Can't concatenate below two commands which are giving me separate results for mailbox sizes for all users and the second one is giving me users who are active in AD

Get-MailboxStatistics -Server dftsmexmbx01 | Select DisplayName, ItemCount, TotalItemSize | Sort-Object TotalItemSize -Descending | Export-CSV C:\Users\desktop\MBSizes.csv

Get-User -RecipientTypeDetails UserMailbox -ResultSize Unlimited | where {$_.UseraccountControl -notlike *accountdisabled*} | Select-Object DisplayName,WindowsEmailAddress,UserAccountControl

Thanks

• Edited by usman siddiqui 16 hours 22 minutes ago

run this 

Get-Mailbox -resultsize unlimited  ?{recipienttypedetails -eq "Usermailbox" | Get-MailboxStatistics |  select-object DisplayName, {$_.TotalItemSize.Value.ToMB()} | export-csv mbsizes.csv

Its stuck as you can see in below picture. Meanwhile is it going to extract for enabled users in AD only? because  we have quite a lot disabled users who have active mailboxes in Exchange

• Edited by usman siddiqui 16 hours 11 minutes ago

Hi,

Try this:

Import-Module activedirectory

$array = @()
Get-ADUser -Filter * | ? {$_.Enabled -eq $true} | % {

if(Get-Mailbox $_.SamAccountName -ErrorAction SilentlyContinue)
    {

        $array += (Get-Mailbox $_.SamAccountName | Get-MailboxStatistics | select displayname,totalitemsize,@{Name="SizeMB";Expression={$_.totalItemSize.Value.ToMB()}} | sort sizemb -descending)
    }
}


$array | Export-Csv -NoTypeInformation c:\mailboxsizes.csv

Mark Gossa

• Edited by Mark Gossa 10 hours 23 minutes ago
• Proposed as answer by Mark Gossa 10 hours 23 minutes ago