Crayfish Posted November 19, 2012 Share Posted November 19, 2012 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. Link to comment Share on other sites More sharing options...
water Posted November 19, 2012 Author Share Posted November 19, 2012 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. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
Neutro Posted January 19, 2013 Share Posted January 19, 2013 (edited) 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 Identify active network connections and change DNS server - Easily export Windows network settings Clean temporary files from Windows users profiles directories - List Active Directory Groups members Export content of an Outlook mailbox to a PST file - File patch manager - IRC chat connect example Thanks again for your help Water! Link to comment Share on other sites More sharing options...
water Posted January 20, 2013 Author Share Posted January 20, 2013 Thanks a lot for this additional examples! My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
harbot Posted July 23, 2013 Share Posted July 23, 2013 @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 Link to comment Share on other sites More sharing options...
water Posted July 23, 2013 Author Share Posted July 23, 2013 @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. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
jcpetu Posted September 21, 2013 Share Posted September 21, 2013 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. Link to comment Share on other sites More sharing options...
water Posted September 21, 2013 Author Share Posted September 21, 2013 Moved to the >Active Directory General Help and Support thread. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
KLM Posted September 25, 2013 Share Posted September 25, 2013 Danke K L M ------------------ Real Fakenamovich ------------------ K L M ------------------ Real Fakenamovich ------------------ Link to comment Share on other sites More sharing options...
water Posted September 25, 2013 Author Share Posted September 25, 2013 Gerne. Glad you like the UDF My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted January 3, 2014 Author Share Posted January 3, 2014 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. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted February 17, 2014 Author Share Posted February 17, 2014 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. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted July 21, 2014 Author Share Posted July 21, 2014 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. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
kyo Posted June 12, 2015 Share Posted June 12, 2015 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... Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted June 12, 2015 Moderators Share Posted June 12, 2015 What version of AutoIt and what version of the UDF are you using? "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
kyo Posted June 12, 2015 Share Posted June 12, 2015 (edited) What version of AutoIt and what version of the UDF are you using?The latest, and the latest! Autoit 3.3.12.0AD 1.4.1.1All 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 Link to comment Share on other sites More sharing options...
water Posted June 12, 2015 Author Share Posted June 12, 2015 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 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
kyo Posted June 12, 2015 Share Posted June 12, 2015 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! Link to comment Share on other sites More sharing options...
water Posted June 12, 2015 Author Share Posted June 12, 2015 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. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
kyo Posted June 12, 2015 Share Posted June 12, 2015 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now