syntax error

Question

Hi All

I am using the below query to pull all the users from the country USA, in the below query i want to exclude users from one particular OU which is Temp OU(OU=TempOU,OU=MyOU,DC=mycompany,DC=com). how do i exclude TempOU in the below query
OU=TempOU,OU=MyOU,DC=mycompany,DC=com

$Syntax = "(co -like '*USA*')"
Get-ADUser -Filter $Syntax -Properties DisplayName,SamAccountName,EmailAddress,Userprincipalname |Select DisplayName,SamAccountName,EmailAddress,Userprincipalname Export-csv C:\temp\output.csv -Notypeinformation

Answer 1

There's no provision to exclude OU's in a filter (or to include them, either), but you can exclude them from the results.

$Syntax = "(co -like '*USA*')"
Get-ADUser -Filter $Syntax -Properties DisplayName,SamAccountName,EmailAddress,Userprincipalname |
    Where-Object {$_.distinguishedName -notlike "*,OU=TempOU,OU=MYOU,DC=*"} |
        Select-Object DisplayName,SamAccountName,EmailAddress,Userprincipalname|
            Export-csv C:\temp\output.csv -Notypeinformation

Answer 2

How can i add two OUS or For example i have a TempOU and it has sub OUS, how can i exclude all OUS under Temp OU

OU=TempOU,OU=MyOU,DC=mycompany,DC=com
OU=TempOU2,OU=TempOU,OU=MyOU,DC=mycompany,DC=com