export AD user attributes powershell

I have a CSV file with usernames, the field heading is samaccountname

I would like to be able to read in this CSV and export AD attributes to another CSV
cmatchettAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jon BrelieSystem ArchitectCommented:
Which AD attributes are you trying to export?
0
cmatchettAuthor Commented:
samaccountname, OfficePhone
0
becraigCommented:
import-module ac*
import-csv c:\file.csv | %  {$user = $_.samaccountname; Get-Aduser | select (whaevet objects you need) | export-csv c:\results.csv -nti}

Open in new window


Since I am not sure what attributes you are after here is a list:

http://social.technet.microsoft.com/wiki/contents/articles/12037.active-directory-get-aduser-default-and-extended-properties.aspx
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

cmatchettAuthor Commented:
becraig, i am getting


cmdlet Get-ADUser at command pipeline position 1
Supply values for the following parameters:
(Type !? for Help.)
0
becraigCommented:
This should work:

import-module ac*
import-csv c:\file.csv | %  {$user = $_.samaccountname; Get-Aduser -identity $user -properties * | select  Officephone, samaccountname | export-csv c:\result.csv -nti

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joshua GrantomSenior Systems AdministratorCommented:
Missing an ending brace "}" it was set to overwrite the CSV with each user
$users = import-csv c:\file.csv | % {$user = $_.samaccountname; Get-Aduser -identity $user -properties * | select  SamAccountName,Officephone} | export-csv c:\result.csv -nti

Open in new window

0
becraigCommented:
Thanks Joshua, did this on the phone, so no validation :~(
0
cmatchettAuthor Commented:
great work.  love experts exchange.
0
Joshua GrantomSenior Systems AdministratorCommented:
its alright. Also, is OfficePhone a valid attribute?

Usually there is just

telephoneNumber, mobile, otherTelephone, facsimileTelephoneNumber, homePhone, ipPhone, otherPager, otherMobile, otheripPhone, otherHomephone, and otherFacsimileTelephoneNumber...

Unless its an added attribute from exchange.

Also, if you could give credit to becraig, I just added a brace. At least give him most of it.
0
becraigCommented:
It is one of the extended properties, I think i provided a link in the first post that covers this.
0
cmatchettAuthor Commented:
sorry, what i meant to do was select multiple answers and select craigs as the best.

Yes officephone is the telephone attribute.

How can i undo my points scoring?  Can you go to a moderator and ask them to do it?
0
becraigCommented:
You can just file a request for attention, though I am ok to split the points.
0
cmatchettAuthor Commented:
request for attention filed
0
cmatchettAuthor Commented:
great work
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.