提取AD用户列表并返回管理员信息的脚本

Question

我正在编写脚本来提取用户的姓名、电子邮件地址和他们的经理信息。我需要一些帮助。到目前为止我有这个

$requestedUsers = Import-Csv "ADUserlist.csv"
$allUsers = Get-ADUser -filter 'Enabled -eq $true' -Properties name, EmailAddress, Manager
$filterdUsers = $allUsers | Where-Object { $_.SamAccountName -in$requestedUsers.SamAccountName }
$report = foreach ($user in $filterdUsers) {
$managerEmail = $allUsers |
Where-Object DistinguishedName -eq $user.Manager |
Select-Object -ExpandProperty EmailAddress
[PSCustomObject][ordered]@{
DisplayName  = $user.Name
EmailAddress = $user.EmailAddress
ManagerEmail = $managerEmail
}
}
$report | Out-GridView

没有输出我不知道我到底在哪里出错了。因此，如果有任何更改，我需要帮助。

Answer 1

应该是这样的

Import-Module -name 'ActiveDirectory'
$requestedUsers = Import-Csv -path "ADUserlist.csv" #Full path required
$allUsers = Get-ADUser -filter 'Enabled -eq $true' -Properties 'name', 'EmailAddress', 'Manager'
$filterdUsers = $allUsers | Where-Object { $_.SamAccountName -in $requestedUsers.SamAccountName }
$report = @()
foreach ( $user in $filterdUsers ) {
$managerEmail = ( $allUsers | Where-Object { $_.DistinguishedName -eq $user.Manager } ).EmailAddress
$PSO = [PSCustomObject]@{
DisplayName  = $user.Name
EmailAddress = $user.EmailAddress
ManagerEmail = $managerEmail
}
$report += $PSO
}
$report | Out-GridView

如果在AD控制器上运行此脚本，首先必须导入ActiveDirectory模块。
如果在非AD控制器上运行此脚本，则必须使用powershell remoting连接到AD控制器并运行该脚本。当然，您必须具有运行这些脚本的权限。