Link to home
Start Free TrialLog in
Avatar of lianne143
lianne143Flag for United States of America

asked on

How to get the values of users attribute on an excel file.


We have 200 staff and if I go to the active directory – User Properties-Attribute Editor
There is an Attribute called: employeeNumber .

I would like to import all the 200 users employeeNumber attributes to a CSV or excel with one colum having the names and another Colum having the attribute of employeeNumber.

Please post me the exact syntax that I need to run or let me know if there is any utility that I can tun to get this value.

Thanks, and any help much appreciated.
Avatar of Sajid Shaik M
Sajid Shaik M
Flag of Saudi Arabia image

go with powershell

Get-ADUser -Filter * -Properties * | Select-Object name, lastlogondate, employeeNumber,
 department | export-csv -path c:\temp\userexport.csv

Open in new window

please check the folloing link for more options and step by step 

all the best
Avatar of oBdA

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lianne143


Apologies was not able to submit feedback  earlier!
Thanks for your help