Q

How to update multiple mailbox properties

What is the best way to update a user's mailbox properties if I need to do 300 of them? I currently have a spreadsheet with their new information, such as their positions, offices and telephone numbers.
Your options are to write a script or to use a tool such as LDIFDE. LDIFDE is the most common way to do what you're trying to do:

1. Export your directory using LDIFDE.

2. Then reformat the export into a spreadsheet-compatible format (such as comma-delimited or tab-delimited).

3. Import into Excel and make your changes.

4. Export from Excel to delimited and reformat back into LDIFDE-ready input.

5. Finally, import back into your Active Directory.

Hint: There are a few readily available utilities available to convert between spreadsheet-compatible and LDIFDE-compatible formats.


Do you have comments on this Ask the Expert question and response? Let us know.
This was first published in January 2005
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWindowsServer

SearchEnterpriseDesktop

SearchCloudComputing

SearchSQLServer

Close