Compare AD full name with Excel full name and then import samaccount name into rows that match
Posted on 2011-02-23
I have a csv file from an oracle sql query that has signonid,fisrtname,lastname. What i want to do is pull samAccountName from AD to populate a new column with the matching names.
This will be used to tie an AD samaccountname to their oracle account.
So it will look something like this:
I'm thinking the script would open the excel, query AD to match first and second fields. Then it would return the sam and append it before it loops to the next.
I can find scripts to read AD, to read csv, to write in csv but I can put them together to query AD, match name to the name in the csv and then populate the csv with the sam name at the end of each row.
I used search but I'm still looking for anything usefull.
Any assistance is appreciated. Thanks.