I want to compare the data I have in csv file to the data which is in ldap produciton server.

There are thousands of users data in csv file and i want to compare the data with the data in production server.

Let's suppose I have user ID xtz12345 in the csv file with uid number 123456. Now I want to cross check the uidNumber of the same user ID xtz12345 in the production server.

Is there any way I can automate this? There are thousands of UserID to be checked and if i do it manually it probably gonna take a lot of time. Can anyone suggest what should I do?

CodePudding user response：

Powershell script is good start place.

import activedirectory module (assuming Windows ADdownload and install RSAT tools, here) in Powershell to fetch information from AD, example

use import-csv in powershell to read csv values. Now, compare first with second. example

Happy to help