azure - 使用 Powershell 和 csv 文件从 Azure AD 检索用户

Question

我想从存储在 csv 文件中的 azure 获取用户

这是我到目前为止所尝试过的，但没有结果，也没有错误

Connect-AzureAD
$usercsv= Import-Csv -Path C:\Victor\csv.csv -Delimiter "," | Select-Object userPrincipalName
if ($usercsv){
    foreach($user in $usercsv){
        try{
            Get-AzureADUser -All $True | Where-Object {$_.userPrincipalName -like $user}
            return;
            }
        catch { 
            Write-Output "error"
            Write-Error $_.Exception.Message
            }
    }

}
else{
"No user data stored"
}

Answer 1

如果 CSV 实际上具有 UserPrincipalNames，这至少应该为您提供一些预期结果:

Connect-AzureAD
$usercsv = Import-Csv -Path C:\Victor\csv.csv #  -Delimiter "," > Is default for this cmdlet
foreach($user in $usercsv)
{
    $upn = $user.UserPrincipalName.Trim()
    $azUser = Get-AzureADUser -Filter "userPrincipalName eq '$upn'"

    if(-not $azUser)
    {
        Write-Warning "$upn could not be found in AzureAD"
        continue
    }

    $azUser
}