How to list users synced from onprem AD and cloud-only users?

Teijo Hämäläinen 

I would recommend using the AzureAD PowerShell Module. You can use the following command to get a list of all Cloud Only Accounts:

Get-AzureADUser -All $true | Where-Object {$_.ImmutableId -eq $null}

If you want a list with the Cloud Only Accounts without guests, you could use the following command:

Get-AzureADUser -All $true | Where-Object {$_.ImmutableId -eq $null -and $_.UserPrincipalName -notlike "*#EXT#*"}