Forum Discussion

AustinSundar's avatar
AustinSundar
Copper Contributor
Feb 21, 2023
Solved

Ps session disconnecting

unable to retrieve all mailbox config. PS session disconnecting or script is not running if we set result size to unlimited. Could someone please help on how to get the below details of all mailboxes...
office 365
  • Harm_Veenstra's avatar
    Harm_Veenstra
    Feb 27, 2023
    Could be the delimiter, I choose ' ; ' but perhaps it's ' , ' for you? And that's pretty slow. It is a lot of mailboxes of course, and how much RAM is PowerShell using in Task Manager during that?
Harm_Veenstra's avatar
Harm_Veenstra
MVP
Feb 21, 2023
What does (get-mailbox -resultsize unlimited -RecipientTypeDetails userMailbox,sharedmailbox).count give you?
  • AustinSundar's avatar
    AustinSundar
    Copper Contributor
    Feb 22, 2023
    we have 59488 mailboxes.
    • Harm_Veenstra's avatar
      Harm_Veenstra
      MVP
      Feb 22, 2023
      Ok, so it can retrieve them with get-mailbox. I think it's memory related, how much RAM does powershell consume during running the script?

      Instead of putting everything in one $report table, you could also export it to one csv with the append parameter. That way it will not consume that much memory
      • AustinSundar's avatar
        AustinSundar
        Copper Contributor
        Feb 23, 2023

        Harm_Veenstra i am not an expert in PS, but tried something like below. however, it failed after getting information of 8500 mailboxes. i also see the error below 

        Could you help to correct the mistakes in the script? or guide me

        PS Error

        $report = @()
$Mbxs = Get-Mailbox -ResultSize unlimited -RecipientTypeDetails UserMailbox, SharedMailbox
foreach ($Mbx in $Mbxs)
{
    $TotalItemSize = (Get-MailboxStatistics $Mbx.UserPrincipalName).TotalItemSize
    $ItemCount  = (Get-MailboxStatistics $Mbx.UserPrincipalName).ItemCount
    $TotalDeletedItemSize = (Get-MailboxStatistics $Mbx.UserPrincipalName).TotalDeletedItemSize
    $ArchiveTotalItemSize = (Get-MailboxStatistics $Mbx.UserPrincipalName -Archive -WarningAction SilentlyContinue).TotalItemSize
    $ArchiveItemCount  = (Get-MailboxStatistics $Mbx.UserPrincipalName -Archive -WarningAction SilentlyContinue).ItemCount
    $ArchiveTotalDeletedItemSize  = (Get-MailboxStatistics $Mbx.UserPrincipalName -Archive -WarningAction SilentlyContinue).TotalDeletedItemSize

    #$email= Get-Mailbox $mbx | select @{Name='EmailAddresses'; Expression={$_.EmailAddresses -join ","}}
    $report = $null
    $reportObj = New-Object PSObject
    $reportObj | Add-Member NoteProperty -Name "DisplayName" -Value $mbx.DisplayName
    $reportObj | Add-Member NoteProperty -Name "RecipientTypeDetails" -Value $mbx.RecipientTypeDetails
    $reportObj | Add-Member NoteProperty -Name "PrimarySmtpAddress" -Value $mbx.PrimarySmtpAddress
    $reportObj | Add-Member NoteProperty -Name "EmailAddresses" -Value $mbx.EmailAddresses
    $reportObj | Add-Member NoteProperty -Name "RetentionPolicy" -Value $mbx.RetentionPolicy
    $reportObj | Add-Member NoteProperty -Name "ArchiveName" -Value $mbx.ArchiveName
    $reportObj | Add-Member NoteProperty -Name "AutoExpandingArchiveEnabled" -Value $mbx.AutoExpandingArchiveEnabled

    $reportObj | Add-Member NoteProperty -Name "TotalItemSize" -Value $TotalItemSize
    $reportObj | Add-Member NoteProperty -Name "ItemCount" -Value $ItemCount
    $reportObj | Add-Member NoteProperty -Name "TotalDeletedItemSize" -Value $TotalDeletedItemSize
    $reportObj | Add-Member NoteProperty -Name "ArchiveTotalItemSize" -Value $ArchiveTotalItemSize
    $reportObj | Add-Member NoteProperty -Name "ArchiveItemCount" -Value $ArchiveItemCount
    $reportObj | Add-Member NoteProperty -Name "ArchiveTotalDeletedItemSize" -Value $ArchiveTotalDeletedItemSize
        
    $report += $reportObj
    $report|Export-Csv "" -Append -NoTypeInformation
}
$report

         

Resources