Sign in to follow this  
Followers 0
oakwood

Active Directory Groups and members

4 posts in this topic

Hi,

I am trying to query active directory and export the data. Here is what I am trying to do. I want to export all of the groups and all of the group's members. Then, I want to export this into a csv file or excel.

I have tried using PowerGui, and vbscript, and Powershell, and winbatch, but I know that AutoIt will save the day and I can show everyone where I work that AutoIt rules!!

So, to recap, I am wanting to export all of the groups and show their members too. I can do one group, but not all of them.

Thank you in advance for your help!!

Share this post


Link to post
Share on other sites



Please have a look at my Active Directory UDF (for download please check my signature). To query all groups and members use _AD_GetObjectsInOU.

I just returned from a very heavy party :D:oops::rip:, so I will post details tomorrow.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Thank you my friend. I will look at it. I hope it will help me. Thanks again!!

Share this post


Link to post
Share on other sites

Try this.

#include <ad.au3>
_AD_Open()
$aObjects = _AD_GetObjectsInOU("", "(objCategory=group)", 2, "sAMAccountName,member", "")
_AD_Close()


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0