Comparing HR list of employee data with Active Directory users attributes.

0 votes
asked by
edited by

Can we compare Excel files provided by HR Dept with Active AD users and produce second CSV with matching without fields like telephone number, employee number?

Currently I have VP Script which runs inside Excel to search AD Objects with following

employeeNumber ,userPrincipalName ,mailNickname

Ouput fields
userPrincipalName Found/Not found mail employeeNumber mailNickname Department title telephoneNumber Full Name

Is it possible to have a powershell script which does the same job for me instead of Excel VB script file?

1 Answer

0 votes
answered by (264k points)
edited by

Unfortunately, you will have to take advantage of the tutorials posted through Google Search because there is no exact way to do what you're asking. I have searched for all kind of websites related to this information, but there isn't one. You will get additional data through the mentioned websites.

Google Search results: http://goo.gl/wsyY6u

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...