Forum Discussion
mfranhind115
Sep 13, 2022Brass Contributor
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: ...
- Sep 13, 2022
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
Sep 13, 2022
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
- mfranhind115Sep 13, 2022Brass Contributorexcellent Harm_Veenstra!
just the last request: any chance to exclude the alias if identical to UPN?
thank you!- 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