Get AD Group members (direct report ) property for each

itman55 · 2021-02-02T12:54:13.000Z

Hi There!

I do have one Email group I need to get ( direct report) property for each member in the DL, then export the result into CSV file.

Thank you in Advance

Neally · 2021-02-02T14:32:54.000Z

What have you tried? Where are you stuck?

We’re happy to help if you post what you have tried

If you post code, please use the ‘Insert Code’ button. Please and thank you!

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…

jimlong3 · 2021-02-02T15:36:20.000Z

This should get you started down that path:

Get-ADUser -SearchBase "OU=YourGroup,OU=Users,OU=YourDirectory,DC=domainname,DC=com" -Filter 'directReports -like "*"' -Properties directReports | FT Name, directReports -A -Wrap

Adjust your -Filter to only select the Users in the Group you want. Remove the entire SearchBase parameter to sweep your AD for anyone having Direct Reports.

Replace Format-Table with whatever you want to do with the list.

Give it a try & use the “</>” button & Powershell format to post the code that gets weird. Don’t forget to also post any error messages. For that, use the “</>” and select “Text” as the format.

Neally · 2021-02-02T15:41:03.000Z

Thanks for posting!

FT Name, directReports -A -Wrap
# should be
Format-Table Name,DirectReports -AutoSize -Wrap

If you post things, can you please spell it out / follow our guidelines ? Not everyone knows what those parameters and aliases mean, so it makes it easier :¬)
@ OP

Be careful using ‘Format-Table’ it might not work as you intend it. It breaks object e.g. if you want to export it to CSV, that would no longer work.
There is nothing wrong with using it, but you have to know when you can and when you can not use it.

jimlong3 · 2021-02-02T16:05:00.000Z

Neally:

Be careful using ‘Format-Table’

I should have made it more clear that Format-Table (FT) was a placeholder for whatever the OP wants to do with the results. Not worth the bother of spelling it out.

And I see now that my whitespace around that admonishment was lost somewhere, so it got jammed under the previous paragraph.

Sorry…

Neally · 2021-02-02T16:13:49.000Z

Jim6795:

I should have made it more clear that Format-Table (FT) was a placeholder for whatever the OP wants to do with the results.

Right, but ya know… people copy it verbatim and be like ‘It does not work’…

jimlong3 · 2021-02-02T17:07:25.000Z

That’s why I made sure it worked before I posted it! ;^)

I hand-typed the whole thing except I copypasta’d my own DistinguishedName… Too lazy to process it further than a screen dump. ¯_(ツ)_/¯

(One of the many reasons I’m happy to help is, this question led me to a solution for an idea I’ve been marinating for a while…)

itman55 · 2021-02-03T09:45:14.000Z

here what I have found:

Get-ADUser -Identity "SamAccountName" -Properties directReports | select  @{n="directReports";e={$_.directReports -join ";"}} | Export-Csv C:\Temp\dR.csv

just not sure how to fetch the data from DL members! as I am not expert in PowerShell

jimlong3 · 2021-02-03T15:45:46.000Z

ITMAN55:

just not sure how to fetch the data from DL members!

Add the -SearchBase parameter to Get-ADUser. Just run this:

Get-ADUser ITMAN55 | Format-List *

(obviously change ITMAN55 to a valid User Name) and look for the DistinguishedName. Use one of the Users’ names you’re interested in. Copypasta that DistinguishedName into Notepad & delete the “CN=ITMAN55,” section (and its comma), then paste the rest in quotes as your SearchBase.