powershell to get all users and their managers recursively

Question

I am looking to pull all Active Directory users and their managers all the way up to the chain.

I get how to do get-aduser -filter * -properties * | select name, manager export-csv -path "csv path"

I also get:

$Users = Get-ADUser -filter * -Properties Manager

foreach($User in $Users){

$Manager = Get-ADUser $User.Manager -Properties DisplayName 

$ManagerName = $Manager.DisplaýName

"$($User.Name) -> $ManagerName"

}

But I am looking to get a recursive list of managers. So if I have a manager i also want my managers manager and so forth till i get all the way to the top.

manager list would look something like this:

Manager: steve | paul | mike | matt

it doesn't have to have the | to separate the manager but something like that where steve would be my direct manager and matt is the CEO.

Answer 1

Without writing the entire script, here's one way of getting the management chain for a single user:

$username = <sAMAccountname>
$user = Get-ADUser -Identity $username -Properties manager,DisplayName
$m = @{DisplayName=$user.DisplayName; Managers=@()}
while ($user.manager) {
    $manager = Get-ADUser -Identity $user.manager -Properties Manager,DisplayName
    $m.'Managers' += $manager.DisplayName
    $user = $manager
}
[PSCustomObject]@{User=$m.DisplayName;Managers=($m.managers -join'|')}

Note that the code ASSUMES that each user has only a single manager! The AD property 'managedBy' is a multi-valued property. If all your users have only one manager it should work. If there are multiple managers you'll have to modify the code.

Answer 2

What i have tried was this:

$username = <sAMAccountname>

$user = Get-ADUser -Identity $username -Properties manager

[array]$managementChain = @()

while ($user.manager) {

$manager = Get-ADUser -Identity $user.manager -Properties DisplayName 

$managementChain += [PSCustomObject]@{

    "Employee DisplayName" = $($user.DisplayName)

    "Manager DisplayName"  = $($manager.DisplayName)

}

$user = $manager

$managementChain | Export-Csv -path

}

All I get here is a export of a csv with 2 columns first is EmployeeDisplayName: but no info there. Second column is Manager DisplayName: I only get the direct manager display name. I'm sure I'm doing something wrong here.