How to use pipeline input in a foreach loop?

Question

Trying to run a command in a foreach loop that contains different search locations, e.g.:

$ous ='ou=Staff,dc=example,dc=local', 'ou=Managers,dc=example,dc=local'

$colItems = $ous | ForEach { Get-ADUser -Filter * -SearchBase "ou=Example,dc=example,dc=local" -Properties whenCreated | select -Property Enabled,Name,SamAccountName,whenCreated }

I want to replace the OU in the search query each time

"ou=Example,dc=example,dc=local"

Ansgar Wiechers · Accepted Answer · 2015-05-27 18:53:25Z

1

If you use a pipeline with a ForEach-Object loop, you must use the current object variable ($_) to refer to the current object from the pipeline. Change this:

$ous | ForEach { Get-ADUser -Filter * -SearchBase "ou=Example,dc=example,dc=local" -Properties ... }

into this:

$ous | ForEach-Object { Get-ADUser -Filter * -SearchBase $_ -Properties ... }

See about_Automatic_Variables for more information.

answered May 27, 2015 at 18:53

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matt Leyland · Accepted Answer · 2015-05-27 14:01:43Z

1

I think this was my answer.

$colItems = ForEach ($ou in $ous) { Get-ADUser -Filter * -SearchBase $ou -Properties whenCreated | select -Property Enabled,Name,SamAccountName,whenCreated }

answered May 27, 2015 at 14:01

Matt Leyland

2,3293 gold badges17 silver badges17 bronze badges

1 Comment

Mathias R. Jessen Over a year ago

please use foreach($ou in $ous) (without the uppercase letters) - lessens confusion between the foreach loop construct and the ForEach-Object cmdlet alias

Collectives™ on Stack Overflow

How to use pipeline input in a foreach loop?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related