Mass update of sapUsername attribute - sin.e.bouli

Hi there,

I have a list of users (not all) in one of my OUs that I need to update
by adding the attribute sapUsername with the value specific for them.

e.g.

sAMAccountName is Test.User1 then sapUsername is TUSER1


sAMAccountName is Test.User2 then sapUsername is TUSER2


However, i have over 300 users to update and doing this manually is not
an ideal situation! Is their any way i can mass upload these?

Thanks,

Bouli


--
sin.e.bouli
------------------------------------------------------------------------
sin.e.bouli's Profile: http://forums.techarena.in/member.php?userid=51422
View this thread: http://forums.techarena.in/showthread.php?t=984659

http://forums.techarena.in

Mass update of sapUsername attribute - Tomasz Onyszko

Your favorite scripting language is Your solution. Or use combination of
cmd.exe, adfind.exe and admod.exe (last two from joe - www.joeware.net).

Assuming that You can have Your samaccountnames in a text file, each of
them in separate line, separated with semicolon from sapUsername.
Something like that:

samAccountname1;sapuser1
samaccountname2;sapuser2
samaccountname3;sapuser3
..
..
..
samaccountname300;sapuser300


You can use command line like this:


for /F "tokens=1,2* delims=;" %i in (sapUsernames.txt) do adfind.exe -b
dc=<domain>,dc=<tld> -s subtree -f "(&(samaccountname=%i))" -adcsv |
admod.exe sapUsername::%j




--
Tomasz Onyszko
http://www.w2k.pl/ - (PL)
http://blogs.dirteam.com/blogs/tomek/ - (EN)

Mass update of sapUsername attribute - Wiseman82

I wrote an app that allows you to edit user account data using MS Excel:

http://www.wisesoft.co.uk/Products/PasswordControl/BulkPasswordControl/EditInExcel.aspx

It should be possible to manipulate the data in excel and update AD.

This YouTube video includes a demo of the Edit in Excel feature:

http://uk.youtube.com/watch?v=sVcA8OLCTUY

Hope this helps,

David
http://www.wisesoft.co.uk
(My personal website and a free resouce for IT professionals)

Mass update of sapUsername attribute - sin.e.bouli

Thanks for these updates - i will try out and let you know how i get on!


--
sin.e.bouli
------------------------------------------------------------------------
sin.e.bouli's Profile: http://forums.techarena.in/member.php?userid=51422
View this thread: http://forums.techarena.in/showthread.php?t=984660

http://forums.techarena.in