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.

Hi

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

https://networkproguide.com/powershell-export-active-directory-users-to-csv/ 

all the best
ASKER CERTIFIED SOLUTION
Avatar of oBdA
oBdA

Link to home
membership
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

ASKER

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