PS Help (Pull users from specific group and OU)

alexdiaz4 · 2019-06-26T17:54:06.000Z

I have this:

$OUs = "OU=Sites,DC=bored,DC=test,DC=org", "OU=Sites,DC=bored,DC=test,DC=org"
ForEach ($OU in $OUs) {Get-ADGroupMember -identity "Students" | Get-ADUser -Filter * -SearchBase $OU -Property DisplayName, EmailAddress | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv"

but getting this error

Get-ADUser : The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input and its properties do not match any of the
parameters that take pipeline input.
At line:2 char:68

… dents-OL" | Get-ADUser -Filter * -SearchBase $OU -Property DisplayNam …
CategoryInfo : InvalidArgument: (CN=student,OU=S…test,DC=org:PSObject) [Get-ADUser], ParameterBindingException
FullyQualifiedErrorId : InputObjectNotBound,Microsoft.ActiveDirectory.Management.Commands.GetADUser

Any help would be great.

Thanks

Neally · 2019-06-26T17:58:25.000Z

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…

Neally · 2019-06-26T18:06:22.000Z

Why do you have a filter in there? I assume you want to get the info for each student?

maybe like this?

$OUs = "OU=Sites,DC=bored,DC=test,DC=org", "OU=Sites,DC=bored,DC=test,DC=org"
ForEach ($OU in $OUs) {
    Get-ADGroupMember -identity "Students" | 
    Get-ADUser -SearchBase $OU -Property DisplayName, EmailAddress | 
    Export-Csv "C:\Users\blah\Desktop\Student-OL.csv" -Append
}

alexdiaz4 · 2019-06-26T18:10:00.000Z

Correct about getting the info for each student.

Thank you for your assistance.

I get this when I run the provided PS:

cmdlet Get-ADUser at command pipeline position 2
Supply values for the following parameters:
(Type !? for Help.)
Filter:

Neally · 2019-06-26T18:13:14.000Z

drftordie:

Correct about getting the info for each student.

Thank you for your assistance.

I get this when I run the provided PS:

cmdlet Get-ADUser at command pipeline position 2
Supply values for the following parameters:
(Type !? for Help.)
Filter:

Do you need the searchbase? Can you filter for the OU before or after?

alexdiaz4 · 2019-06-26T18:18:31.000Z

Do you need the searchbase? Can you filter for the OU before or after?

I am fairly new to PS.

I do need tot he searchbase so that it can also separate by OU. I do not see why before or after would not work. How would I go about doing this?

Evan7191 · 2019-06-26T18:19:16.000Z

If you want to get users from a group, you shouldn’t need the OU.

Get-ADGroupMember -identity "Students" | ForEach { Get-ADUser -Property DisplayName, EmailAddress } | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv" -Append

Neally · 2019-06-26T18:21:00.000Z

I’d do it like this:

$OUs    = "OU=Sites,DC=bored,DC=test,DC=org", "OU=Sites,DC=bored,DC=test,DC=org"
$result = 
ForEach ($OU in $OUs) {
    get-aduser -filter * -SearchBase $ou -Properties DisplayName, EmailAddress, memberof |
    where memberof -match 'Students'
}

$result | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv"

alexdiaz4 · 2019-06-26T18:21:07.000Z

Evan7191:

If you want to get users from a group, you shouldn’t need the OU.

Get-ADGroupMember -identity "Students" | ForEach { Get-ADUser -Property DisplayName, EmailAddress } | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv" -Append

Evan,

The issue is that some staff are in that group as well. With that I need to also filter by OU, so that only the students in the student OU will show up.

Thanks

alexdiaz4 · 2019-06-26T18:31:44.000Z

Neally:

I’d do it like this:

$OUs    = "OU=Sites,DC=bored,DC=test,DC=org", "OU=Sites,DC=bored,DC=test,DC=org"
$result = 
ForEach ($OU in $OUs) {
    get-aduser -filter * -SearchBase $ou -Properties DisplayName, EmailAddress, memberof |
    where memberof -match 'Students'
}

$result | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv"

Ohhh ok I get what you did. That makes more sense. This worked great.
Thanks for your assistance.

Evan7191 · 2019-06-26T18:32:17.000Z

drftordie:

Evan7191:
If you want to get users from a group, you shouldn’t need the OU.
Get-ADGroupMember -identity "Students" | ForEach { Get-ADUser -Property DisplayName, EmailAddress } | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv" -Append
Evan,

The issue is that some staff are in that group as well. With that I need to also filter by OU, so that only the students in the student OU will show up.

Thanks

In that case, you have two options:

Query users based on OU, as Neally suggested.
Query users based on the group and then filter based on a property.

Get-ADGroupMember -identity "Students" | ForEach { Get-ADUser -Property DisplayName, EmailAddress } | Where-Object {$_.distinguishedName -match "OU1" -or $_.distinguishedName -match "OU2"} | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv" -Append

davelewis56 · 2019-06-27T07:34:41.000Z

You can also just use the filter directly:

$OUs = "OU=Sites,DC=bored,DC=test,DC=org", "OU=Sites,DC=bored,DC=test,DC=org"
$Results = Foreach ($OU in $OUs) {
    Get-ADUser -Filter "memberof -match 'CN=Group,DC=bored,DC=test,DC=org'" -SearchBase $OU
    } 
$Results | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv"

Some additional options (recursive, not in the group)

$OUs = "OU=Sites,DC=bored,DC=test,DC=org", "OU=Sites,DC=bored,DC=test,DC=org"
$Results = Foreach ($OU in $OUs) {
    Get-ADUser -Filter "-not memberof -RecursiveMatch 'CN=Group,DC=bored,DC=test,DC=org'" -SearchBase $OU
    } 
$Results | Export-Csv "C:\Users\blah\Desktop\Student-OL.csv"