ad report all users in all groups and user stats

Posted on 2014-07-15
Last Modified: 2014-07-30
I need a script of some sort to:

1) List all groups in a domain and their members (output into 1 single report ideally csv/xlsx)

2) List all users in a domain and include the following (username, account status (i.e. disabled or not), accurate last login date. Again output to csv or similar.

Any pointers most welcome. If any of the scripts require additioanl software on the windows 7 PC please detail that in your reply.
Question by:pma111
    LVL 2

    Accepted Solution

    Is this a once off or do you need to regularly provide these reports.

    I had a project recently where i had to audit a domain to prepare for a migration. I used this program.  Its a paid service but gives you a 60 day grace feature that has most of the reports available.

    You can complete a audit on all users, groups and group memberships and export them into various forms (Excel, HTTML etc)

    Some details on the reporting

    If its a once off , download and install the trail, run your reports and then uninstall.  If you need it as a regular process then you can simply purchase a license.  After the 60 day grace period it will limit the reports to first 100 objects.
    LVL 3

    Author Comment

    its a one off.. was hoping for scripts but will give your software a go!
    LVL 3

    Author Comment

    I was aware of get-aduser and get-adgroup member but couldnt see an easy way to do them for all groups and all users
    LVL 17

    Assisted Solution

    by:Premkumar Yogeswaran
    LVL 2

    Expert Comment

    Hi pma111,  

    Yeah i thought you may have been after a script however if you have limited scripting experience like i do then you would most probably run into a whole bunch of issues trying to customise the scripts to your exact needs. That software is basically point and click and will take a whole 5 minutes to install and a whole 5 minutes to work your self around the GUI so your comfortable.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This is a PowerShell web interface I use to manage some task as a network administrator. Clicking an action button on the left frame will display a form in the middle frame to input some data in textboxes, process this data in PowerShell and display…
    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    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…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    760 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

    11 Experts available now in Live!

    Get 1:1 Help Now