powershell and MSonline: how to get all the aliases in my accounts list

[mfranhind115]

Hi all,

under my tenant I have several domains with their accounts.

I would like to write a script (or a single command even), to get all the aliases.

Something like this would be fine:

alias, UPN

...

obviously, if a UPN has multiple aliases, the list should show multiple lines....

thanks!

mf

[#2 · Accepted solution]

@mfranhind115 

This should give you a list of Alias and UPN, use connect-msolService first

$total = @()
foreach ($user in Get-MsolUser -All) {
    foreach ($alias in $user.ProxyAddresses) {
        $founduser = [pscustomobject]@{
            Alias = $alias.Split(':')[1]
            UPN   = $user.UserPrincipalName
        }
        $total += $founduser
    }
}

$total | Sort-Object Alias

[#3]

excellent Harm_Veenstra!

just the last request: any chance to exclude the alias if identical to UPN?

thank you!

[#4]

@mfranhind115  No problem, I think this should work:

$total = @()
foreach ($user in Get-MsolUser -All) {
    foreach ($alias in $user.ProxyAddresses) {
        if (-not ($alias.Split(':')[1] -eq $user.UserPrincipalName)) {
            $founduser = [pscustomobject]@{
                Alias = $alias.Split(':')[1]
                UPN   = $user.UserPrincipalName
            }
            $total += $founduser
        }
    }
}

$total | Sort-Object Alias