asked on

Bulk update of AD users

Hi,

I have the task to update the attributes of about 300 users' attributes. This is going to take a lot of time, so investigating I came with this tool:
http://www.activedir.org/Articles/tabid/54/articleType/ArticleView/articleId/66/Default.aspx
http://www.wisesoft.co.uk/software/passwordcontrol/bulk_modify.aspx

This seems to work fine, but I have two questions to keep myself going:

1. How to export the users list from AD on windows server 2003?
2. Is there a better freeware solution?

Alan Hardisty

Admodify.net 2.1 is usually the free tool of choice:

http://admodify.codeplex.com/releases/view/6065#DownloadId=16355

You shouldn't need to export the user list with Admodify - it reads them from AD directly.

Glen Knight

You don't need to export the data.

And yes, ADModify is free and is perfect for this job:

http://admodify.codeplex.com/
http://technet.microsoft.com/en-us/library/aa996216(v=exchg.65).aspx

KenMcF

I would recomend using powershell with the Microsoft AD cmdlets or Quest AD cmdlets. What attributes ado you need to update and what information do you have for the users, do you have their logon name?

Glen Knight

For Windows 2003 I'd suggest ADModify is a better option than powershell?

KenMcF

The Quest cmdlets work with 2003, and the MS cmdlets work on a WIn7 computer with ADWS installed. It is just a personal pref to use powershell. I like using it because everything MS is going to be managed through PS in the future.

AxlTrauts

ASKER

KenMcF, I have their names. I have all that data on Excel.

KenMcF

THis is just an example if you would want to use powershell and Quest and a CSV file as your source

Foreach ($User in (import-csv c:\temp\users.csv)){
Get-qaduser $User.Samaccountname | Set-qaduser -description "This is a Test"
}

AxlTrauts

ASKER

ADModify makes the change the same to all users, that is not what I need. I'd like to add their unique data on each user from a CSV/Excel/TXT file. Unless I haven't seen that feature on ADModify yet... Amazing tool though!

KenMcF, I'm testing that today. That doesn't alters the password? do you know if that applies on custom fields?

KenMcF

Let me know what you need to update and i can post an example, this is one for the employeeID attribute

Set-qaduser -objectattributes @{employeeid="123456"}

SOLUTION

Glen Knight

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

AxlTrauts

ASKER

Yes demazter, that's what I showed in the first time :)
Ok, so I'll do both things, test using the cmdlet and using that tool from wisesoft.

KenMcF, I'm attaching a CSV of the fields I'm trying to insert. The point is that every field can have different values on each record.
Book1.csv

ASKER CERTIFIED SOLUTION

KenMcF

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

AxlTrauts

ASKER

Thank you both, both methods worked fantastic. I'm going for the freeware as it is "easier", but 'both did the trick.