Csv Export Script for Active Directory Users

Question

I extract with my script the users of my active directory

Import-Module ActiveDirectory
Get-ADUser -Filter * -properties * | Select SAMaccountname, givenname, surname, DistinguishedName | Export-Csv c: \ users \ administrator \ desktop \ users.csv -notypeinformation -Encoding UTF8

In this script I use the DistinguishedName command which returns the CN, the OU and the DC. My goal is to keep only the first OU and delete the rest when creating the .csv.

Example of what the script returns:

"SAMaccountname","givenname","surname","DistinguishedName"
"Jean-Yves.R","Jean-Yves","Raymond","CN=Jean-Yves Raymond,OU=Communication,OU=Direction Générale,OU=Elan & Co,OU=Domain Controllers,DC=ELAN-G1,DC=local"

Example of what I want:

"SAMaccountname","givenname","surname","DistinguishedName"
"Jean-Yves.R","Jean-Yves","Raymond","Communication"

TY :)

Use the filter parameter, and specify the OU you wish to query for (Communication). — DragonZero
– DragonZero, Commented Apr 19, 2017 at 11:39
Do you have an example to give me with the filter please? ty ^^ — Chrys
– Chrys, Commented Apr 19, 2017 at 11:45
stop using -properties *. It is horribly slow since it returns everything, even the non indexed properties, and you are only using the properties returned by default anyways. It is not needed. If you do need more properties just ask for the ones you want. -Properties employeeid — Matt
– Matt, Commented Apr 19, 2017 at 12:14

henrycarteruk · Accepted Answer · 2017-04-19 12:22:37Z

1

This will give you the OU property you want.

Get-ADUser -Filter * -properties * | Select SAMaccountname, givenname, surname,@{Name='OU';Expression={$($_.DistinguishedName).Split(",")[1].Replace("OU=","")}}

EDIT:

To deal with the Users OU:

Get-ADUser -Filter * -properties * | Select SAMaccountname, givenname, surname,@{Name='OU';Expression={$($_.DistinguishedName).Split(",")[1].Replace("OU=","").Replace("CN=","")}}

edited Apr 19, 2017 at 12:22

answered Apr 19, 2017 at 12:11

henrycarteruk

13.3k2 gold badges40 silver badges40 bronze badges

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

3 Comments

Chrys Over a year ago

Great ! It works perfectly if the user is in an OU create but if the user is just in "user" it shows me this: "Juny.R","Juny","Rab","CN=Users" It should be deleted "CN="

Matt Over a year ago

@Chrys Just add another replace in that case. You can chain them together.

Chrys Over a year ago

OK :) Your the best ^^ TY very much

Mark Wragg · Accepted Answer · 2017-04-19 11:48:47Z

0

Get-ADUser -Filter * -properties * | Select SAMaccountname, givenname, surname,@{l='DistinguishedName';e={([adsi]"LDAP://$($_.DistinguishedName)").Parent}}

This uses a calculated property within the Select statement to get the Parent property of the DistinguishedName via LDAP.

Source: https://social.technet.microsoft.com/Forums/windowsserver/en-US/830ff383-9057-45d8-ae10-5e567efd36f8/how-to-get-parent-container-path-of-the-ad-user-object?forum=winserverpowershell

answered Apr 19, 2017 at 11:48

Mark Wragg

23.6k7 gold badges48 silver badges77 bronze badges

2 Comments

Chrys Over a year ago

Hello :) It returns me this : "Jean-Yves.R","Jean-Yves","Raymond","LDAP://OU=Communication,OU=Direction Générale,OU=Elan & Co,OU=Domain Controllers,DC=ELAN-G1,DC=local"

Mark Wragg Over a year ago

Are you sure you copied it exactly as above?

Collectives™ on Stack Overflow

Csv Export Script for Active Directory Users

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related