Forum Discussion

Brass Contributor

Sep 13, 2022

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

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: ...

office 365

Harm_Veenstra

Sep 13, 2022

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

Harm_Veenstra

MVP

Sep 13, 2022

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

mfranhind115

Brass Contributor

Sep 13, 2022

excellent Harm_Veenstra!

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

thank you!

Harm_Veenstra

MVP

Sep 13, 2022

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

Forum Discussion

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

Share

Resources