Get-MailboxShowNulls

Get-MailboxShowNulls.ps1

$empid = import-csv c:\Temp\Emp_ID_Import.csv
$empid | ForEach-Object {
    $PSObj = New-Object PSObject -Property @{
        SamAccountName_Input = $_.SamAccountName
    }
    
    $Mbx = Get-Mailbox -Identity $_.SamAccountName -ErrorAction SilentlyContinue
    
    if ($Mbx) {
        $PropHash = @{}
        $Mbx.PSObject.Properties | ForEach-Object {$PropHash[$_.Name] = $_.Value}
        $PSObj | Add-Member -NotePropertyMembers $PropHash
    }
    
    Write-Output $PSObj
} | Select SamAccountName_Input, Name, Alias, UserP* | Export-Csv C:\PSExport\MailEXP.csv -NoTypeInformation