lianne143
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Check the way below, to capture Windows user name account.
https://stackoverflow.com/questions/7805856/vba-retrieve-the-name-of-the-user-associated-with-logged-username
Check the way below, to capture Windows user name account.
https://stackoverflow.com/questions/7805856/vba-retrieve-the-name-of-the-user-associated-with-logged-username
ASKER
Apologies was not able to submit feedback earlier!
Thanks for your help
Thanks for your help
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