Combining Cmdlets

0_combining_cmdlets

# Connect to Exchage Online Management
Import-Module ExchangeOnlineManagement
Connect-ExchangeOnline

#Connect to Azure Active Directory
Import-Module AzureAD
Connect-AzureAD

1_combining_cmdlets

$ExchangeOnlineManagementUsers = Get-Mailbox
#Run this to test that $ExchangeOnlineManagementUsers actually contains data:
#Foreach ($user in $ExchangeOnlineManagementUsers) {Write-Output $user | select *}

$AzureUsers = Get-AzureADUser
#Run this to test that $AzureUsers actually contains data:
#Foreach ($user in $AzureUsers) {Write-Output $user}

$Result=@() 

Foreach ($a in $ExchangeOnlineManagementUsers) { #For each user in Exchange Online Management,
    Foreach ($b in $AzureUsers) { #for each user in Microsoft Online,

        if([string]$a.UserPrincipalName -eq [string]$b.UserPrincipalName){ #if their user principal names match,

            $Result += $obj = [PSCustomObject]@{ #create a custom PowerShell Object with properties from both EOM and MSO,
            #Alias = $a.Alias
            DisplayName = $a.DisplayName
            WhenMailboxCreated = $a.WhenMailboxCreated
            PrimarySmtpAddress = $a.PrimarySmtpAddress
            MailboxPlan = $a.MailboxPlan
            DirSyncEnabled = $b.DirSyncEnabled
            LastDirSyncTime = $b.LastDirSyncTime
            }

            #Write-Output $obj #then write that object to the console. 
        }
    }
}

$Result | Export-CSV "output.csv"