Re: Have username - need DN

Tech-Archive recommends: Speed Up your PC by fixing your registry

David, you're a lifesaver! I was able to easily edit your script, move some things around inside the CSV file, and Presto! 30 seconds later I had our whole AD updated!

Thanks so much for sharing!

-Brion

"Wiseman82" <nospam@xxxxxxxxxx> wrote in message news:261AC1AB-7E0C-4C64-BBE4-AEE08AFAB392@xxxxxxxxxxxxxxxx
I wrote a script and an app that allows you to update user attributes via CSV. Both can be configured to match user accounts from the CSV file based on the username rather than the DN.

http://www.wisesoft.co.uk/scripts/vbscript_update_user_attributes_from_csv.aspx
http://www.wisesoft.co.uk/Products/PasswordControl/BulkPasswordControl/CSVUpdate.aspx

The app is easier to use and generates an XML log file containing all the updates performed - this can be used to rollback changes if required. The script would allow for more customization, but doesn't have the benefit of the XML log file/rollback feature. It's still relativly easy to customize to your own requirements (you could even modify it to update from a database rather than a CSV file)

Hope this helps,

David


"Jorge de Almeida Pinto [MVP - DS]" <SubstituteThisWithMyFullNameSeparatedByDots@xxxxxxxxx> wrote in message news:eC7U404PJHA.728@xxxxxxxxxxxxxxxxxxxxxxx
normally that is resolved by using ILM 2007 FP1 Metadirectory/Synchronization/Provisioning Services

in your case you have several options:
* create a CSV file, create a script that reads each line, searches for the user in AD and then updating the attributes when it finds the user in AD
* create a batch file to retrieve the DNs based on the usernames. Add the DNs to the Excel ***, then create a CSV file and use ADMOD (joeware.net) to read the CSV and update the attributes

--

Cheers,
(HOPEFULLY THIS INFORMATION HELPS YOU!)

# Jorge de Almeida Pinto # MVP Identity & Access - Directory Services #

BLOG (WEB-BASED)--> http://blogs.dirteam.com/blogs/jorge/default.aspx
BLOG (RSS-FEEDS)--> http://blogs.dirteam.com/blogs/jorge/rss.aspx
------------------------------------------------------------------------------------------
* How to ask a question --> http://support.microsoft.com/?id=555375
------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test ANY suggestion in a test environment before implementing!
------------------------------------------------------------------------------------------
#################################################
#################################################
------------------------------------------------------------------------------------------

"Brion" <blah@xxxxxxxx> wrote in message news:uTRLjq4PJHA.2720@xxxxxxxxxxxxxxxxxxxxxxx
We want to update our AD contact info from our HR system. So I'm sitting here looking at a giant spread*** that contains username, phone #, department, title, etc. and wondering how I'm going to get it into AD. I know I can manipulate user accounts using dsmod, but it looks like dsmod requires the DN for input. I don't have the DNs - I have the usernames. How can I go about this?

Thanks in advance!
-Brion



.

Quantcast