Powershell query for OU membership

I have a list of computers in a text file and I want to query AD to pull the OU they belong to. Is this possible, i know to query ad to pull the computer from the OU, but i want to take a preexisting list and query to get OU membership

LVL 1

leadthewayAsked: 2017-03-23

Who is Participating?

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get this solution by purchasing an Individual license! Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 18

Emmanuel AdebayoGlobal Windows Infrastructure Engineer - ConsultantCommented: 2017-03-23

Dsquery command will do this for you perfectly

LVL 1

leadthewayAuthor Commented: 2017-03-23

but I'd have to do one at a time right?

LVL 18

Emmanuel AdebayoGlobal Windows Infrastructure Engineer - ConsultantCommented: 2017-03-23

Put all the server in a text file and parse this to dsquery command.

LVL 1

leadthewayAuthor Commented: 2017-03-23

Can you help with the syntax, I'm not familiar with dsquery, mostly use PS

LVL 44

footechCommented: 2017-03-23

I'd just look at the distinguishedName, as that shows the OU. If you absolutely need just the OU then you'd want to parse the DN to strip off the computer name.

Get-Content computers.txt | Get-ADComputer | Select distinguishedName

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial