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

Question

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?

Answer 1

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