Get-ADGroup - Group Name, ManagedBy Name and Email

Question

I'm looking to get the the Group Name, Managed By Name and Managed by Email in a PowerShell query similar to this.

Get-ADGroup -filter {Name -like "*Admins" }

The output would look something similar to:

Group Name | Managed By Name | Managed By Email

The issue I'm having is with joining Get-ADGroup and Get-ADUser. In SQL this "join" would happen on get-adgroup.managedby = get-aduser.distinguishedname. I know that's not how it works in Powershell, just thought I'd throw out an example of what I'm trying to do.

Any help would both be welcomed and appreciated.

Answer 1

I see @Mathias R. Jessen beat me to it, but here's what I had:

Get-ADGroup -filter {Name -like "*IT*" } -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}}