Compiling user accounts

Posted on 2010-01-07
Last Modified: 2013-11-25
I'm looking for a tool, if one exists to basically compile all my user accounts in my AD domain that are both active and inactive.  Basically the output should be on an excel spreadsheet.  Does anyone know of a tool?  I'm know I can basically export the infor from AD but that's not really giving me what I need.
Question by:WellingtonIS
    LVL 57

    Accepted Solution

    adfind by MVP Joe Richards is a great tool
    adfind -default -f "&(objectcategory=person)(objectclass=user)" samaccountname displayname sn givenname description -csv >  c:\users.csv
     I just outputted a few common attributes but you can add more to it.
    CSVDE is another common method
    Other good ways are powershell, built in DStools.

    Author Comment

    The adfind looks like a great tool I just need instructions on how to use it.  Are there such instructions?
    LVL 57

    Expert Comment

    by:Mike Kline
    The command I listed there should give you what you need (CSV file on the C drive)
    you can also use adfind /??

    Author Closing Comment

    Thanks I got it.
    LVL 11

    Expert Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I worked at a US software company that used offshore contractors for ten years and offshore employees for three years. We had a positive experience and you can too.   When I interviewed people for positions in the US, I would tell them that we wor…
    Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
    This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

    754 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

    16 Experts available now in Live!

    Get 1:1 Help Now