asked on

Get a specific OU to display from a DN with GET-ADComputer

I have this powershell script :

Get-ADComputer -Filter {(OperatingSystem -NotLike '*server*' -and OperatingSystem -NotLike '*Tap*')} -Property * -Searchbase "OU=Paris,OU=France,OU=Europe,OU=Root,DC=contoso,DC=com" | Select-Object -Property name, @{label='Site';expression={$_.distinguishedName}}
It gives me this result :

name Site
---- ----
DESKTOP10 CN=DESKTOP10,OU=Desktops,OU=Computers,OU=Paris,OU=France,OU=Europe,OU=Root,DC=contoso,DC=com

How can I get the the OU Paris only that :

Name Site
-------- -------
DESKTOP10 Paris

Thks

oBdA

Like that, for example:

$SearchBase = "OU=Paris,OU=France,OU=Europe,OU=Root,DC=contoso,DC=com"
$Site = $SearchBase -replace '\AOU=(.*?),(OU|DC)=.*', '$1'
Get-ADComputer -Filter {(OperatingSystem -NotLike '*server*' -and OperatingSystem -NotLike '*Tap*')} -Searchbase $SearchBase |
	Select-Object -Property name, @{label='Site'; expression={$Site}}

Open in new window

And do AD a favor and don't retrieve all AD properties if all you need is the name (which is already in the default set returned).

Jean-Jacques CELMA

ASKER

Thks,

Could you explain to me the folling in details :

'\AOU=(.*?),(OU|DC)=.*', '$1'

ASKER CERTIFIED SOLUTION

oBdA

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial