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
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?