使用 .txt 文件查找 AD 组中的 ManagedBy 和 ManagedBy 电子邮件

Question

我在尝试读取我的脚本并将 AD 组与我的脚本一起应用时遇到问题。现在，它只是发布我的脚本中的内容，但我想让脚本读取我的 .txt 文件中的内容并将其与脚本的其余部分一起使用。

$filePath = "C:\Users\UserName\Downloads\ADGroupList.txt"
Get-Content -Path $filePath

Get-ADGroup -filter {Name -like "$filePath" } -Properties managedBy |
ForEach-Object { 
$managedBy = $_.managedBy;

if ($managedBy -ne $null)
{
 $manager = (get-aduser -Identity $managedBy -Properties emailAddress);
 $managerName = $manager.Name;
 $managerEmail = $manager.emailAddress;
}
else
{
 $managerName = 'N/A';
 $managerEmail = 'N/A';
}

Write-Output $_; } |
Select-Object @{n='Group Name';e={$_.Name}}, @{n='Managed By Name';e={$managerName}}, @{n='Managed By Email';e={$managerEmail}}

导出 Csv -路径“C:\Users\用户名\Documents\ADGroupManagerList.csv”

Answer 1

最简单的方法是循环遍历 ADGroupList.txt 文件中的组名称（假设这是组名称列表，每个组名称位于单独的行上）

$filePath = "C:\Users\UserName\Downloads\ADGroupList.txt"

# just loop over the group names you have in the text file and capture the output
$result = Get-Content -Path $filePath | ForEach-Object {
    $group = Get-ADGroup -Filter "Name -like '$_'" -Properties managedBy
    # create an object pre filled in when no manager was found
    $obj = [PsCustomObject]@{
        'Group Name'       = $group.Name
        'Managed By Name'  = 'N/A'
        'Managed By Email' = 'N/A'
    }
    # test if the ManagedBy is populated
    if (-not [string]::IsNullOrWhiteSpace($group.ManagedBy)) {
        # try to use the DN in property ManagedBy to find the manager
        try {
            $manager = Get-ADUser -Identity $group.ManagedBy -Properties EmailAddress -ErrorAction Stop
            $obj.'Managed By Name'  = $manager.Name
            $obj.'Managed By Email' = $manager.EmailAddress
        }
        catch {
            Write-Warning "No user found for '$($group.ManagedBy)'.. Please check AD."
        }
    }
    # output the object so it gets collected in variable $result
    $obj
}

# write the file
$result | Export-Csv -Path "C:\Users\UserName\Documents\ADGroupManagerList.csv" -NoTypeInformation

Answer 2

要解决此问题，您可以使用此 powershell 脚本来获取组的 ma​​ngedBy。

Get-ADGroup -filter * -Properties managedBy |
ForEach-Object { 
$managedBy = $_.managedBy;

if ($managedBy -ne $null)
{
 $manager = (get-aduser -Identity $managedBy -Properties emailAddress);
 $managerName = $manager.Name;
 $managerEmail = $manager.emailAddress;
}
else
{
 $managerName = 'N/A';
 $managerEmail = 'N/A';
}

Write-Output $_; } |
Select-Object @{n='Group Name';e={$_.Name}}, @{n='Managed By Name';e={$managerName}}, @{n='Managed By Email';e={$managerEmail}}