VBScript program to create a Microsoft Excel spreadsheet listing the names of all users in the domain. The spreadsheet lists the Distinguished Name of each user in the first column, one name per cell. The Distinguished Name uniquely specifies each object in Active Directory. The Distinguished Name includes the "cn" attribute (common name), the container or Organizational Unit the user object resides in, and the complete DNS domain name.

The program can be used to create a spreadsheet of users to be used by other programs that set properties or perform other administrative tasks on many users at once. For example, this program creates a spreadsheet of users that can be used with the program SetPWForUserList3.vbs. The spreadsheet should be reviewed and edited to make sure it only includes users that should be modified.

Unless the users to be modified are in a group or Organizational Unit, it is much better to use a spreadsheet of users. This makes it easier to eliminate built-in accounts, administrators, guest accounts, etc. You can also troubleshoot the program with a short list of test users, then run the program again on the remaining users. In some cases, you might want to run the program several times on blocks of users. Spreadsheets of user names are much easier to manage.

CreateUserList3.txt <<-- Click here to view or download the program