Scripting would be my first
choice...
Script Center has great
examples:
http://www.microsoft.com/technet/scriptcenter/scripts/ad/users/list/default.mspx (Retrieving User Account
Properties)
http://www.microsoft.com/technet/scriptcenter/scripts/ad/users/modify/default.mspx (Modifying User Account
Properties)
http://www.microsoft.com/technet/scriptcenter/scripts/office/excel/default.mspx (Microsoft Excel and
scripts)
Cheers,
Jorge
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank Abagnale
Sent: Monday, October 03, 2005 10:20
To: Active
Subject: [ActiveDir] Cleanup of Active Directory...
Hi all,
If you remember some of my previous posts, I've had issues with excessive
numbers of Domain Admins and a poorly managed Active Directory network.
I have now managed to control the number of Domain Admins to a suitable
manner for our environment and delegated the appropriate permissions for the
Service Desk.
I now need ton data 'cleanse' Active Directory due to the number of
fields which contain incorrect data which has been manually entered by previous
Service Desk users.
The fields which are showing incorrect data are the ones in the General and
Organization tabs. Fields such as Description, Office, Title,
Department etc are all showing the wrong data and are
inconsistent. There are potentially 3500 users which may require
account fields to be modified
What I want to do is to clean this up. Is there a way in which I can export
this data to an excel spreadsheet and then re-import with out duplicating any
accounts? Do I need to script this?(if so, does anyone have any scripts?)
Alternatively, is it worth employing someone to do it manually? time
consuming and probably not the most favoured option, though any idea's would be
appreciated.
Oh, it's a Single W2k3 domain, 2003 FFL,
thanks...
frank
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
