Powershell: Find all computers in AD but exclude certain OU's

powershell active-directory ou
tcox8 picture tcox8 · Jul 5, 2016 · Viewed 7.1k times · Source

I am trying to list all computers in my domain except for those stored in any of the two OU's. As soon as I add the second OU using the -or operator things break.

Using this I return all computers except for those stored in my first unwanted ou:

[array]$Computers1 = get-adcomputer -filter '*' -SearchBase 'ou=WorkStations,dc=XXX,dc=XXX,dc=edu' | where { $_.DistinguishedName -notlike "*OU=Test,*" }

Adding the -Or operator causes the unwanted computers (those stored in both of these OU's) to be included in my results.

[array]$Computers1 = get-adcomputer -filter '*' -SearchBase 'ou=WorkStations,dc=XXX,dc=XXX,dc=edu' | where { ($_.DistinguishedName -notlike "*OU=Test,*") -or ($_.DistinguishedName -notlike "*OU=TIS,*")}

Answer

Bacon Bits picture Bacon Bits · Jul 5, 2016

You want -and, not -or:

[array]$Computers1 = get-adcomputer -filter '*' -SearchBase 'ou=WorkStations,dc=XXX,dc=XXX,dc=edu' |
    where { ($_.DistinguishedName -notlike "*OU=Test,*") -and ($_.DistinguishedName -notlike "*OU=TIS,*")}

Related questions

Get Local Admin Accounts on every computer in OU

I am trying to get a list of all user accounts in the administrators group on their respected machines, of our entire OU. I have found a script that shows this on a single computer, but I would like to …

Read More
Powershell - Filtering OUs while using get-adcomputer

I am trying to create a script that generates a list of computers based on specific properties which a computer may have. For example, I am trying to make a list of Windows XP computers and Windows 7 computers, throw their …

Read More
How to find computer object OU from server itself using CMD

How can I find what OU the computer belongs to using CMD or powershell cmdlet . I have found some long scripts but there has to be a one liner command for it. The computers dont have AD role installed on …

Read More