Active Directory export to CSV ( by read-only user , dont want to use 3rd party app...)

Posted on 2004-10-26
Last Modified: 2010-04-14
Hi ,
I have a user that needs to get a txt file of members of a group from Active Directory on a regular basis...

Net group might be an idea , but it doesnt seem to work properly.. ie says it cant find a group ( its in an OU called Groups)

Thanks in advance
Question by:sgriffin
    LVL 11

    Expert Comment

    Hello Sgriffin,

    LDIFDE might be one way to do it:

    LVL 11

    Expert Comment

    An example could be:
    Ldifde.exe -f membership.txt -s DCServerName -r "(objectclass=group)" -l
    where member is the name of the group
    LVL 11

    Expert Comment

    Another way of doing it, exporting to a csv file, without using a third party utility:

    csvde -f c:\output.csv -r (objectclass=group) -l name,member
    LVL 2

    Author Comment

    where would I find csvde and ldifde? C:\winnt?

    Can I find out the members of a group without naming a member? as in:

    Ldifde.exe -f membership.txt -s DCServerName -r "(objectclass=group)" -l


    LVL 16

    Accepted Solution

    Net group command should work fine, so long as the machine is a member of the domain and the user is logged in to the domain.

    For instance, the command:
    NET GROUP "Domain Admins" /domain

    returns all members of the domain admins group. Note the quotes here because the group name has a space in it.


    LVL 11

    Expert Comment

    Hello again,

    Both should be available on any of your DCs and yes you can use the command you had typed above.

    Some uselful links are:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    846 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

    Need Help in Real-Time?

    Connect with top rated Experts

    5 Experts available now in Live!

    Get 1:1 Help Now