Powershell for See direct reports to employees ADuser

wunx400 · 2022-08-03T08:43:11.000Z

I am currently learning Powershell and want to seek some advice , i am trying to find direct reports from managers so i can see who report direcly to Managers if it makes sense

Rod-IT · 2022-08-03T08:56:57.000Z

What do you have so far?

We wont write it for you, but we will help you.

Rod-IT · 2022-08-03T08:58:35.000Z

Searching would also give you this

How to list a direct reports in Powershell Programming & Development

Good morning All. I am trying to create a listing of a specific manager and their direct reports in powershell. The way my code works now is all of the Direct reports are being listed on 1 row. I would like each direct report to have a separate row. Here is what I have so far? #Script created on 10/20/2017 to display a specific Regional Managers and their direct Reports Write-Host "Processing" $Properties = @('Name', 'SamAccountName', 'Description', 'Office', 'telephoneNumber', 'EmailAddr…

wunx400 · 2022-08-03T09:00:40.000Z

$InactiveDays = 90
$Days = (Get-Date).Adddays(-($InactiveDays))

$users = Get-ADUser -Filter {LastLogonTimeStamp -lt $Days -and enabled -eq $true} -SearchBase ‘OU=Dinex,DC=Dinex,DC=DK’
-Properties LastLogonTimeStamp,samaccountname | select-object Name,samaccountname,@{Name=“Date”; Expression={[DateTime]::FromFileTime($_.lastLogonTimestamp)
.ToString(‘MM-dd-yyyy’)}} # | export-csv “C:\Temp\test.csv.csv” -notypeinformation
Get-ADUser $manager

$users = $users.samaccountname

foreach($user in $users)
{
Get-ADUser $user -Properties * | select -ExpandProperty manager
}

foreach($users in $user)
{
$nemt = Get-ADUser MGP -Properties directreports |select -expand directreports
}

wunx400 · 2022-08-03T09:05:47.000Z

it is my 2nd day ever working with powershell ever so im reading alot of it

thatnorthenitguy · 2022-08-03T09:22:08.000Z

I misread and gave you it the other way round, ignore me!

something like…

$User = Get-ADUser -identity user.name -Properties *
$User.manager.split(',')[0].trim('CN=')

Should work on a user by user case. You can then expand it to use a csv etc. Bit of googling should help you with the rest!

If you get stuck post the code you’ve come up with so far, people are much more likely to help out if you at leas make a start and don’t treat them as a script writing service

Rod-IT · 2022-08-03T10:02:42.000Z

Wunx400:

it is my 2nd day ever working with powershell ever so im reading alot of it

We all start somewhere.

saidbrandon · 2022-08-03T12:08:09.000Z

Welcome to the community! Please be sure to take a look at the sticky thread at the top of the forum. Here’s a direct link:

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Using Get-* Cmdlets is generally fairly safe, but Set-, Remove- can be a resume generating event. Since it’s your second day with PowerShell, I recommend taking it slowly and using extreme caution. Most Cmdlets support the -WhatIf Parameter. That’s useful so you can see what changes will be made before you make them. Nothing is more fun than deleting all of your users instead of just one due to a bad filter. Specifically regarding Active Directory, most online place will recommend using -Properties *, but it’s bad practice as it returns all properties of all users and can cause a strain if you have a large environment. It’s best to get into the practice of only requesting the properties you need.

Get-ADUser -Filter {....} -Properties Manager

You actually use it in your first of 3 Get-ADUser commands.

Here’s a thread that discusses the same thing you’re trying to do How to list a direct reports in Powershell