Active Directory Example Scripts

[water]

To write a row you new to pass a 2D array to function _Excel_RangeWrite that holds all values in a single row.

Global $aArray[][] = [[1, 2, 3, 4]]

 

[kyo]

That's what I figured by going through the whole thread on the creation of the current Excel.au3, but thought there might be a simpler way.

I can also call _Excel_RangeWrite() once for each row.  It's not elegant but it would work.

Thanks for your help!!

[water]

I have added version 3.0 of ADCU to the download section of the forum under Home > Downloads > Misc > ADCU - Active Directory Compare Users 3.0.

Works with AutoIt 3.3.12.0 and the latest Excel UDF.

Edited June 14, 2015 by water

[water]

- (double post)

Edited August 30, 2015 by water

[kyo]

Thanks Water!  I'll see how you did it, it's still the best way to learn!

[water]

I hope ADQU (Active Directory Query User) and ADQG (Active Directory Query Group) will follow soon

[water]

Version 3.1.0.0 of ADCG (Active Directory Compare Groups) released to the Download section of the forum:

• Fixed: Coloring of lines is correct even after sorting the Listview
• Fixed: Ctrl+a und Ctrl+c only work when one of the Listviews has focus
• Changed: Moved to latest Excel UDF, enhanced performance
• Changed: Moved to latest OutlookEX UDF, enhanced performance
• Added: Button added to copy the content of the Detail view to the clipboard

Edited July 27, 2015 by water

[water]

Version 1.4.2.0 of the UDF has been released.

Now runs with all versions of AutoIt >= 3.3.8.1.

Please test before using in production!

For download please see my signature.

[water]

New Beta version of ADCU - Active Directory Compare Users for you to test.
What's new:

• User Functions: Define functions for the Main GUI, the Listviews and the Detail GUI. Buttons/Context menu entry is created using the information from the Ini-File.
• Column Headers: Change the text of the column headers by setting a key in the Ini-File.
• Select Properties: Now you can select the properties to be displayed by setting a key in the Ini-File.
• Detail GUI: Copy the whole table to the clipboard
• Enhanced performance: Filtering the displayed data is much faster.
• Documentation: The word/PDF documentation explains the new features
• Search feature (3.2.0.0): ADCU uses ANR (Ambiguos Name Resolution) to search in all naming related AD fields.

Could you please test this new version and tell me what you think about or if there are any errors!

Edited September 13, 2015 by water

[water]

Anyone interested in an "AutoFill" function for the user accounts? Takes a few seconds to generate the list so it would be optional (activate/deactivate by a flag in the Ini-File).

Edited August 30, 2015 by water

[legend]

Hi Water, that would be a great feature, so you could search for the full name as well, and not only the username

[water]

Maybe something like this?
You enter a name and when pressing the search button ANR (Ambiguos Name Resolution) will search all naming related fields in AD.
A list of found users will be displayed and you then select the one to be processed.

Edited September 13, 2015 by water

[legend]

That looks pretty neat,

I this that would be great

[water]

If I find some spare time I will soon release a new version with this new features. 

[water]

I have added version 3.2.0.0 to post #89.
It has the new search feature included.
Happy testing!

[legend]

What, i'm just about to test it now,

Can't wait to test it

 

EDIT: where can i find this file? : AD-Tools_User.au3

Edited August 27, 2015 by legend

[water]

Sorry, they were missing. I added the files to post #92.

[water]

Did you find some spare time to test the new ADCU?

[water]

Version 3.2.0.2 of ADCU (Active Directory Compare Users) released to the Download section of the forum.

Edited September 13, 2015 by water

[water]

Version 1.4.3.0 of the UDF has been released.

Fixed problems with _AD_JoinDomain and _AD_UnJoinDomain! Thanks to user Neutro!

Please test before using in production!

For download please see my signature.