Windows Forum

Ask something
Discussion Locked

Extracting User Manager database

0 helpful
6 replies

by r bailey

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'd like to extract our User Manager database into a text file or spreadsheet. I need to sort the list by Groups once I get it into some type of text format. Is there a utility somewhere that will do this? I'm running MS Exchange and I can extract that database to a *.csv file, but some of our users don't have e-mail accounts so it wouldn't include everyone. Any help would be appreciated.

6 replies

by tony.colgrove

In Exchange Server Admin program, from the menu's select:
Tools > Extract Windows NT Accounts
That will open a dialog box asking for which Domain to extract from and the output filename. The extract will give you all of the user database in a csvfile.

by r bailey

Extracting the NT Account list through Exchange works, but it doesn't include the Local/Global groups that each user is a member of.

by aekland

You can use the 'addusers' command found on the resource kit to dump the accounts to a csv. The only problem is if you have a lot of users in a group it will overflow in excel and you will not have all the group information, generally only groups like domain users causes this. You can edit it in word first to take care of the problem. If you want more information you can use the list of users to create a batch file that uses 'net user' to get more detatiled information about the users.
There are also several third party apps like aelita directory reporter that can provide much more detail with less hassle but at a price.

This discussion is closed to new replies.