안녕하세요 향기입니다.
오늘은 AD 관리자를 위한 아주 유용한 Tool을 소개 합니다.
사용자 대량 변경 작업이 있을 경우에 편리하게 작업을 할 수 있습니다.
물론 Beta Ver.이지만 매우 유용합니다^^’
그리고 무료입니다.!! Free!! 대량 작업할 때 CSV나 엑셀 파일만 정리되어 있으면 큰 작업을 쉽게 할 수 있습니다.
꼭 써보시기 바랍니다^^;
Bulk AD Users
http://wisesoft.co.uk/software/bulkadusers/default.aspx
Bulk AD Users - A tool that allows bulk updates to Active Directory User Attributes
Introduction
WiseSoft Bulk AD Users is a tool that makes it easy to perform bulk updates to Active Directory User account attributes. Previously you might have wrote scripts to perform these types of updates or gone through a very tedious process of performing these updates one at a time via the ADU&C interface. Bulk AD Users makes this process much simpler and also provides an XML log file that allows you to undo any unwanted updates. The application has powerful query capabilities that allow you to target updates to only the required user accounts and number of methods are available for updating user account data depending on your specific requirements.
The Bulk Modify dialog will seem familiar to anyone that has used Active Directory Users & Computers. The interface is modeled on the user dialog, but the updates can apply to many user accounts. The XML Placeholders feature extends the flexibility of the Bulk Modify dialog by allowing you to base updates on existing attributes. You could update the display name format to "surname, firstname" or change the username format to "firstname.surname" for example. The Bulk Modify dialog is great for situations where the update can be based on existing attributes or a single value is required for all users.
The CSV update feature allows you to update user account attributes from a CSV file, making it suitable for updates where a different value is required for each user account. A CSV file could be produced from your HR database and then used to update employee information stored in Active Directory. It's also possible to export existing account data from Active Directory to CSV file, use a 3rd party application to manipulate the data and then re-import using the CSV Update tool.
Bulk AD Users allows you to edit user account data in Microsoft Excel with the Edit In Excel feature. Microsoft Excel is a very powerful tool for data manipulation allowing you to update user attributes using a combination of manual updates and formulas. It's very easy to write a formula in Excel to update the user principal name format to 'firstname.surname@domainname.com' for example. In this case, you could also choose the Bulk Modify feature to perform the update, but in other situations the formulas will be to complicated to convert into XML Placeholders.
For quick updates to a small number of accounts, the edit in grid feature can be used. The application also supports moving user accounts to a new container, reseting passwords and has quick options for enabling/disabling user accounts. Additional account options (logon hours, password never expires, force password change at next logon etc) can be manipulated through the Bulk Modify dialog.
Advantages of Bulk AD Users
It's possible to manipulate data in Active Directory by writing your own scripts, using command line tools and other 3rd party applications. I don't want to discourage people from using command line tools and writing scripts - quite the opposite; I actually encourage the use of scripts and provide information to help people write their own scripts on this website. There are some advantages to using Bulk AD Users over writing your own scripts to consider -
- Bulk AD Users is easier to use and doesn't require knowledge of any scripting language.
- Writing scripts can be time consuming and some attributes require special handling making them difficult to update via script.
- Updates performed by Bulk AD Users are logged automatically in an XML file. This file enables the application to rollback updates if required - An additional layer of safety not usually provided by command line tools and scripts.
- Bulk AD Users is freeware.
In most cases Bulk AD Users is the easiest method of performing bulk updates to user account attributes. You might still choose scripts and command line tools for specific update scenarios where you need additional automation or a great deal of control over the update process.
Is it really FREE? What's the catch?
Yes! You are free to use the application in any company/organization regardless of size, number of users etc. The application does not expire after a period of time and it's features are not limited in any way.
The application asks for a registration code - this is simply to keep track of the number of people that are using the application. You can get your registration code after signing up for your FREE WiseSoft.co.uk user account. The user account allows you to post on the forum and submit content to the website. Your details are not shared with any third parties and you won't be inundated with spam emails from this website. Emails are sent occasionally to inform users about updates to the website and applications (Only 3 updates were sent in 2008).
If you find the software useful and would like to make a donation, your support is very much appreciated.
Features
Searching
- Select users from group (with or without nested members)
- Select users from OU (Allows multi-select)
- Select users from query. A range of pre-defined filters are available and you can write your own custom LDAP filters.
- Ability to extend the list of pre-defined queries to include your own favorite searches.
- Select users from list. Enter user account names manually or from a file.
Updating
- Simple "Bulk Modify" interface for updates. A dialog similar to the user dialog in ADU&C, but it can work on a large number of user accounts.
- XML Placeholders feature. Can be used with Bulk Modify dialog to base updates on existing user account attributes. e.g. set displayname to "Surname, Firstname"
- Support for multi-valued attributes.
- "Other Tab" provides support for custom AD Attributes and attributes not normally shown in the user interface.
- Photo updates
- Member Of updates.
- Logon hours support
- UserName updates (with optional conflict resolution)
- Enable/Disable/Unlock. (support for other account options also available)
- CSV Update tool.
- Edit In Excel tool.
- Move Users
- Bulk password reset
- Edit In Grid.
- XML Log file produced for each update batch.
- Result dialog to show the success of the update.
- Rollback feature.
Note: This is not a full list of supported attributes. A large number of attributes are supported by the application and the application can even be used to update attributes that have been added by extensions to the schema.
Miscellaneous
- Connection dialog to connect to other domains.
- Connect to domain from a workgroup computer.
- Export data to Excel, CSV to tab-separated.
- Properties to Load dialog allows you to control which attributes are shown in the grid.
- Password Generation Options - Control the format of generated passwords.
- Extend Bulk AD Users by writing your own scripts.
- Additional customization available in application config file.
Essential Reading
- Planning for Bulk Updates - things to consider before you update your Active Directory database.
- Connecting to Active Directory - how to connect to your Active Directory Database.
- Selecting user accounts - how to select the user accounts you want to modify
Note: Additional documentation will follow. Most of the documentation for "Bulk Password Control" will also apply to Bulk AD Users - click here to view the documentation for the old version.