Need to export a list of usernames from AD

[1etherer]

Not sure where to post this.

I have a list of users full names and there email addresses on a excel sheet and I need to export the active directory usernames of these users.

Is there a script I can create that will look in AD for the full name or email addresses in the excel sheet and then export the usernames to another excel sheet or text file.

I've looked all over the net but cant figure out how to do this.

I have 51 users.

Cheers

 

[MidnightShadow]

I'm not a pro with AD by any means, but a script? It seems that, unless there is already one out there, writing a script to do that would take just as long as entering those 51 names manually. You probably could've already finished in the time you've taken to research, then ask, and get a response.

 

[1etherer]

I'm not a pro with AD by any means, but a script? It seems that, unless there is already one out there, writing a script to do that would take just as long as entering those 51 names manually. You probably could've already finished in the time you've taken to research, then ask, and get a response.

Sorry! thats what I meant, was a script template so I can edit with my info and run it.

We will be getting alot of these requests now so a script will be handy.

 

[carnageX]

Start with this, and customize it as you need it:
https://social.technet.microsoft.co...ilter-email-address?forum=winserverpowershell

Guy is doing something similar to what you want.

Query used: "powershell get ad account by email"

 

[1etherer]

I found a guide and have got the results needed.

PowerShell: Find AD User by Full Name | 9to5IT

All you need to change is path to list of data , attributes you want to extract and path to save results to.

Carnage - Your "Query" helped me think to query "powershell get ad account by full name"

lol I have to kick myself sometimes lol

Cheers!! Carnage!!

 

[carnageX]

Lol good to see you got one that matched what you needed.