oakwood Posted December 8, 2011 Share Posted December 8, 2011 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!! Link to comment Share on other sites More sharing options...
water Posted December 8, 2011 Share Posted December 8, 2011 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 , so I will post details tomorrow. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
oakwood Posted December 8, 2011 Author Share Posted December 8, 2011 Thank you my friend. I will look at it. I hope it will help me. Thanks again!! Link to comment Share on other sites More sharing options...
water Posted December 8, 2011 Share Posted December 8, 2011 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki 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