Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

a) Can I export all users irrespective of there group memberships to a CSV File, for e.g. users.csv ?

b) Can I also export all OUs to a CSV, so I can later re-import them into a New DC on a New Domain ?

c) Can I export all Groups to a CSV, so I can re-import them into the New DC / New Domain ?

Basically, we have a lot of users, groups, OUs, we are just testing to see if we had to manually re-create all users, groups, ous, via CSV files ?

is this possible ? Will be grateful if someone could provide a script / command to get there.


Thank you all for your suggestions, I think I may have not explained my Question better. Basically, I am not doing or wish to do this for Backup purposes.

I just want to see how this works, for e.g. : If I manually create a CSV file with a list of say 20 or 30 users, what would that csv file should be like ? I mean attributes or fields so that it can be imported into AD with one command or script?

So, I thought if one would export first they would know which attributes would be necessary to create accounts into AD.

Now, the question is :-) :

a) How to create that CSV File, what fields are required?
b) Can we set a Default password too for those new accounts?
c) Can we also specify which OU to create that users in or I can move them later?

I hope I have asked clearly this time, it's not meant to be a backup of any kind, just a way to create multiple users or move multiple users around with ease.

Thanks again for your input.

share|improve this question
add comment

2 Answers

If you're looking at ways to backup Active Directory, the best and most reliable way to do that without creating domain controllers in some remote network is to use the VSS Writer for Active Directory with a VSS-aware backup utility. There is one that comes with Server 2008, and most off-the-shelf backup frameworks for Windows can handle that (possibly with a fee). This kind of backup will get everything, including all user, group, and computer objects with passwords.

To get Group Policy, and anything in them like login-scripts, backed up you need to use the VSS FRS writer.

With both of these you can get a full backup of an AD domain. They can also do atomic restores (single objects) to handle oops-deletes.


If you really just want a bunch of CSV files, take a look into the dsquery utility (link). It'll be able to search AD, and when used in conjunction with dsget it'll grab most of the object information for most objects.

A note, though. The above pair of utilities are not a backup method for AD. It won't grab password information. It is useful for documenting object location and group-membership information. To my knowledge, both do not have any visibility on group-policy objects.

share|improve this answer
    
+1, Also worth noting is csvde, which will produce CSV output by default. It may also be used to import/restore CSV files into the domain. –  jscott Sep 4 '11 at 14:05
    
Thanks for your suggestions everyone, I am aware of AD Backup and applications around, I have updated the question, kindly check. Thanks –  rihatum Sep 4 '11 at 19:07
add comment

To answer your updated question, if what you are looking to do is a bulk import of users into AD you want to look at for and dsadd. I will give you an example of a script that I wrote to do this at a previous job of mine.

My CSV file would look like this:

FirstName,LastName,samid,password

I would create a batch file that looked something like this:

for /F "eol=; tokens=1,2,3,* delims=," %%i in (%1) do dsadd user "cn=%%j %%i,ou=Students,dc=contoso,dc=com" -samid %%k -upn %%k@contoso.com -fn %%j -ln %%i -display "%%j %%i" -pwd %%l -desc K -memberof "cn=glb_Students,ou=Global,ou=UD_Groups,dc=contoso,dc=com" -loscr kix32.exe -mustchpwd yes -hmdrv "H:" -hmdir \\fileserver1\%%k$

The %%i,%%j,%%k,%%l relate to the columns in the CSV file

There is a chapter on all of the ds command line tools (dsquery,dsget,dsadd,dsmod) in this book:

Windows Command-Line Administrator's Pocket Consultant, 2nd Edition by William R. Stanek

If you are running Window Server 2008 R2, this may also be helpful: link

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.