Active Directory Example Scripts

[Crayfish]

Thank you for these exceptional detailed examples.

I just want to leave a note that these examples are extremely well cared for examples!

I will try it when I'm back at work.

[water]

I'm glad you like them

I created them for my company and it is just a minor effort to make them usable for everyone.

[Neutro]

I wrote 4 scripts that do the following:

- Get_AD_Groups_Excel.au3: creates an excel file containing all groups of an AD in different columns, each column containing all users that belong to these groups. The goal of this script is to easily see if there are some "unwanted" users in the different groups of your AD.

- Get_AD_Groups_Textfile.au3: same than above but with a textfile output, 1 line per group, users separated by a coma ",". The goal of this script is to export these informations into another software easily.

These 2 scripts require the file "sid.txt" to convert windows special accounts SID to readable english account names (this is an extract from microsoft website).

- Get_AD_Users_Excel.au3: creates an excel file containing all users of an AD in different columns, each column containing all groups that belong to these users. The goal of this script is to easily see if there are some "unwanted" groups that a user is a member of.

- Get_Ad_Users_Textile.au3: same than above with textfile output for exporting these informations to another software.

You need to run these scripts on a Windows domain administrator session to get it working, or modifify the AD_Connect() lines to include domain administrator login/password.

Special thank to water for helping me getting this done

Get AD groups and users informations.zip

Edited April 14, 2013 by Neutro

[water]

Thanks a lot for this additional examples!

[harbot]

@Water Just to check if your link are still working, coz been trying to download the .zip files but im not able to open it

Error : Does not appear to be a valid archive

[water]

@Water Just to check if your link are still working, coz been trying to download the .zip files but im not able to open it

Error : Does not appear to be a valid archive

Moved to the ">general help and support" thread because this is the "example scripts" thread.

[jcpetu]

Hi Water, nice to talk with you again, I got a question for you, is it possible to get the remote logged on user with your AD script?, or can I write some field on the computer object with the logged on user?

Thanks in advance and regards.

[water]

Moved to the >Active Directory General Help and Support thread.

[KLM]

Danke

[water]

Gerne. Glad you like the UDF

[water]

Version 1.4.0.0 of the UDF has been released.
Supports AutoIt 3.3.10.x plus adds a few new functions.

Please test before using in production!

For download please see my signature.

[water]

Version 1.4.1.0 (Bug fix) of the UDF has been released.

Only runs with AutoIt 3.3.10.2 and later.

Please test before using in production!

For download please see my signature.

[water]

Version 1.4.1.1 (Bug fix) of the UDF has been released.

Only runs with AutoIt 3.3.12.0 and later.

Please test before using in production!

For download please see my signature.

[kyo]

Some of the examples (ADCG and ADCU) will not compile with the new versions of Autoit - the Excel functions have changed a lot since then...

[JLogan3o13]

What version of AutoIt and what version of the UDF are you using?

[kyo]

What version of AutoIt and what version of the UDF are you using?

​The latest, and the latest!

Autoit 3.3.12.0

AD 1.4.1.1

All the _Excel functions have changed since Water wrote those examples, and now it's impossible to compile them "as-is".  I'm trying to convert the _Excel calls, but I'm not very successful yet..

Edited June 12, 2015 by kyo

[water]

I'm about to translate them so they work with the latest version of the AD UDF and AutoIt.
But don't hold your breath

[kyo]

Thanks Water.  I'm finding those utilities useful at work (I'm using a version I compiled a few years ago), and I'm coming back to them to learn from the code, but I'm having difficulties with the _Excel code.   

I won't hold my breath, but I'll check regularly! :-)

Thanks!

[water]

You still should be able to compile the example scripts with AutoIt 3.3.8.1 and version 1.4.0.0 of the AD UDF.

[kyo]

Yes I can, but I'm trying to avoid having two Autoit installs.   In this case I'm mostly trying to replicate the results in Excel by using the new _Excel_ functions in Autoit 3.3.12.0 (I'm now aware you are one of the authors of both AD.au3 and Excel.au3).  I'm having problems writing a 1D-array on a single row, which this simple line used to do:

_ExcelWriteArray($oExcel, $i + 2, 1, $Zf, 0, 1)

The _Excel_RangeWrite() function seems to be writing to consecutive rows by default.