Link to home
Start Free TrialLog in
Avatar of BO7AREB
BO7AREB

asked on

What is the best and easiest way to update some fields Active Directory Users "300+ user"

Hello everybody,

I would like to ask a question which I have already searched for it on the net but I have not found a solution for it tell now.

I have been given a job be my manager to update our active directory Users list the field which will be affected are:

In the GENERAL TAB:

 “First Name, Initials, Last Name, Display Name, Office and Telephone number"

In TELEPHONES TAB:

“Mobile, Fax and IP Phone"

In the Organization TAB:

“Title, Department, Company and last the Name under Manager"

We have 350+ users in the active directory. Those field on most of them are either empty or have a wrong information.

I would like to ask experts what is the best and easy way to edit those huge numbers of user while keeping track of what have been changed and what is still need to be done. Please inform me about any tool that could do it or it meant to do this kind of editing.

Thank you all in advance.
Avatar of Abhay Pujari
Abhay Pujari
Flag of India image

You want to update First Name, Initials, Last Name, Display Name and Telephone number - which is unique and I think u need to do it manually. Even if you create a script, you have to enter parameters for the same. Correct me if I am wrong,
If you select multiple users, then you can edit few things which are common in every case.
There is a tool for importing and exporting AD objects.
I don't know the exact workings anymore: but check google for ldifde.exe
This should make things easier.

And nicer: it is a native Windows tool...
 
LDIFDE works, however the input file syntax can be frustrating...

You will need a decent script, e.g. take this as a starting point:
http://www.computerperformance.co.uk/ezine/ezine42.htm

Of course you will have to have to input data in some kind of machine-readable format...
Check out the command line programs dsquery and dsmod.  They're both included in Windows XP and above.  If you have a text file with the username and data to be modified you can create a for loop to read the text file and run dsquery piped to dsmod to modify the AD object.
You can get help for them as follows:
Open a command prompt.
type in:
dsquery user /?
dsmod user /?
ASKER CERTIFIED SOLUTION
Avatar of darmented
darmented
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BO7AREB
BO7AREB

ASKER

it was not easy. but a good tool to work on the user on excel file.