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

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

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