Active Directory Export Script

Posted on 2010-09-14
Last Modified: 2012-05-10
I need to export the name of each OU, Security Group and Distribution Groups along with their members names to a text file.  Our domain name is FSS.local and our DC is FSSFS.  Does anyone have a clue how to do this?
Question by:steveLaMi
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 33673789
at the command line

net users /domain
will get you a list of users

net groups /domain
will get you a list of groups

you can direct them into a text file like this
net users /domain>USERS.TEXT
net groups /domain>>USERS.TEXT

Expert Comment

ID: 33673978
For security group membership, create a batch file that reads:
cscript listgroup.vbs>grouplist.txt

Create a vbs file named "listgroup.vbs" containing:

On Error Resume Next
Set objGroup = GetObject _
  ("LDAP://cn=<groupname>;ou=<path to group>;dc=FSS,dc=local")
arrMemberOf = objGroup.GetEx("member")
WScript.Echo "<groupname>"
For Each strMember in arrMemberOf
  WScript.echo strMember

This will create a file named whatever you put in place of <groupname>. You'd have to do this with each security group or distribution list.

Author Comment

ID: 33673995
Is there a way to get the users of a distribution group into a text file?
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 57

Expert Comment

by:Mike Kline
ID: 33673996
I would suggest something like adfind or powershell.  Michael Smith has a good overview of doing this with adfind
In addition to that if you want to export the OUs and their names
adfind -default -f objectcategory=organizationalunit name

Author Comment

ID: 33674005
Matt... I didnt see your answer before I posted my last comment, I will give it a try
LVL 17

Accepted Solution

Tony Massa earned 500 total points
ID: 33674190
Here's a script that will prompt for the DNS domain name, and group name, then put the user info into an Excel spreadsheet.  Note:  Assumes you have Excel installed on the computer you're running it on.

Expert Comment

ID: 33675267
Here is another script which you can use to get all groups and group member details:

Featured Post

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
Had a business requirement to store the mobile number in an environmental variable. This is just a quick article on how this was done.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question