Re: Script a Bulk Modification of ALL AD users?
- From: "Joe Richards [MVP]" <humorexpress@xxxxxxxxxxx>
- Date: Mon, 20 Nov 2006 11:11:48 -0500
I responded to this in another newsgroup, but AdMod will do CSV updates, read the /csv? usage screens carefully.
4000 users is easy, regular testing of admod was with 100k+ objects.
Joe Richards Microsoft MVP Windows Server Directory Services
Author of O'Reilly Active Directory Third Edition
---O'Reilly Active Directory Third Edition now available---
Lawrence Bowen wrote:
PLEASE read my question, I have a HUGE dilemma, but the answer MUST be simple!
I have often used VB scripts, LDIFDE scripts and CSVDE to automate various tasks in AD. However, I have recently been given the MOTHER of all AD projects. I have been supplied with a CSV spreadsheet containing data about all the companie's users that have to be imported into AD. The top row of the spreadsheet reflects LDAP names, but the friendly names of these LDAP names are things like First Name, Surname, Job Title, Area, Logon name etc, Mobile number etc. Now, there are columns under these for over 4000 Active Directory users! I am fortunate in that the data is accurate, and the fields for account names, and given names match the AD equivalent. The purpose of this spreadsheet is to update huge amounts of information for each user in AD, such as their phone numbers, their departments and numerous other fields.
I have been battling (and pulling out what is left of my hair) trying to work out how to use this CSV file in a script to rapidly modify all my 4000+ users, who thankfully will be in one OU. I have seen glimmers of hope in VB scripts, but what I need done seems more complex than another VB script I have found, and not being a programmer, I am left with more questions than answers.
My big question is, can ANYONE help me at all in this task, I mean Quest! By pointing me to information, or even given me outright answers, because I am sure I can't be the only AD administrator to ever have to perform a task like this??
CSVDE performs a similar function, but only for creating new accounts. I need to modify existing accounts using my data in this CSV file.
To summarise; I have a CSV file consisting of a number of columns, the heading of which represents an LDAP field for a user object. There are over 4000 rows, each representing a user. I need to find a way or porting all of this info into AD using scripts or WHATEVER! I will look at anything because I have been trying for over a week to come up with an answer, with no luck. I was so sure this would be a relatively easy administrator’s task.... tut tut :)
- Prev by Date: Re: time sync
- Next by Date: Re: Sizing the ADAM server
- Previous by thread: Re: Script a Bulk Modification of ALL AD users?
- Next by thread: Home Floder