gr1fter Posted July 20, 2011 Share Posted July 20, 2011 @gr1fter Your example crashes here with error: Can you post an example how the desired result should look like? Thanks, but i think i got it. I had to change this to For $iIndex = 1 To $adOU[0][0] to For $iIndex = 2 To $adOU[0][0] and it skipped the first line and got me where i needed. Link to comment Share on other sites More sharing options...
water Posted July 20, 2011 Author Share Posted July 20, 2011 @BlackHoleSun... For my test computer the description is 5th in the array, but it might not always be that way, so how can I have the message box show only the description field, instead of hard-coding 5 in it? I tried putting "description" in it, but it errors out. Any way to do that with out loops looking at what each value is?You can either use _AD_GetObjectAttribute($sAD_Object, $sAD_Attribute) to get a single attribute which doesn't need any kind of "decryption" (like date values etc.) or you specify the required property when calling _AD_GetObjectProperties($sAD_Object, "description"). 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 20, 2011 Author Share Posted July 20, 2011 @gr1fter Glad you got it working! 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...
BlackHoleSun Posted July 20, 2011 Share Posted July 20, 2011 @BlackHoleSunYou can either use _AD_GetObjectAttribute($sAD_Object, $sAD_Attribute) to get a single attribute which doesn't need any kind of "decryption" (like date values etc.) or you specify the required property when calling _AD_GetObjectProperties($sAD_Object, "description").A Million Thanks!! Link to comment Share on other sites More sharing options...
water Posted July 20, 2011 Author Share Posted July 20, 2011 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...
gcue Posted July 21, 2011 Share Posted July 21, 2011 is there a function to get all groups from AD? I am trying to get a listing of all groups starting with BU_ thanks in advance. Link to comment Share on other sites More sharing options...
water Posted July 21, 2011 Author Share Posted July 21, 2011 _AD_GetObjectsInOU("", "(&(objCategory=group)(name=BU*))", 2, "") 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...
gcue Posted July 21, 2011 Share Posted July 21, 2011 hmm im getting an error code 2 No records returned from Active Directory. $sAD_DataToRetrieve is invalid (attribute may not exist) do i need to do something before then reference that? #include "AD.au3" #include <array.au3> _ad_open() $array = _AD_GetObjectsInOU("", "(&(objCategory=group)(name=BU*))", 2, "") if @error Then MsgBox(0,"",@error) EndIf _ArrayDisplay($array) _ad_close() Link to comment Share on other sites More sharing options...
water Posted July 21, 2011 Author Share Posted July 21, 2011 (edited) Sorry, my fault. You have to specify the data you want to retrieve. "" isn't enough. #include "AD.au3" #include <array.au3> _ad_open() $array = _AD_GetObjectsInOU("", "(&(objCategory=group)(name=BU*))", 2, "samaccountname") if @error Then MsgBox(0,"",@error) EndIf _ArrayDisplay($array) _ad_close() Edited July 21, 2011 by water 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...
gcue Posted July 21, 2011 Share Posted July 21, 2011 getting error code 3 now maybe wildcards arent supported? or is it a different character other than * ? Link to comment Share on other sites More sharing options...
water Posted July 21, 2011 Author Share Posted July 21, 2011 I'm not at my windows pc at the moment. So I can't test it myself. But could you try: #include "AD.au3" #include <array.au3> _ad_open() $array = _AD_GetObjectsInOU("", "(&(objCategory=group)(samaccountname=BU*))", 2, "samaccountname") if @error Then MsgBox(0,"",@error) Else _ArrayDisplay($array) EndIf _ad_close() 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...
gcue Posted July 21, 2011 Share Posted July 21, 2011 np - same error code 3 btw. =/ Link to comment Share on other sites More sharing options...
water Posted July 21, 2011 Author Share Posted July 21, 2011 And if you just ask for all groups? #include "AD.au3" #include _ad_open() $array = _AD_GetObjectsInOU("", "(objCategory=group)", 2, "samaccountname") if @error Then MsgBox(0,"",@error) Else _ArrayDisplay($array) EndIf _ad_close() 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...
gcue Posted July 21, 2011 Share Posted July 21, 2011 error code 3 Link to comment Share on other sites More sharing options...
water Posted July 21, 2011 Author Share Posted July 21, 2011 Holy s..t - there was a typo + invalid wildcard with the used attribute. This should work: $array = _AD_GetObjectsInOU("", "(&(objectCategory=group)(cn=BU_*))", 2, "samaccountname") 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...
gcue Posted July 21, 2011 Share Posted July 21, 2011 bingo! it does... many thanks for your help!!! and quick responses =) Link to comment Share on other sites More sharing options...
water Posted July 21, 2011 Author Share Posted July 21, 2011 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 August 4, 2011 Author Share Posted August 4, 2011 (edited) Water, I've searched the AutoIt forums looking for some help with my project and I keep seeing your name come up in refernece to Active Directory assistance. I'm wondering if you could show me how to use your AD.au3 functions to pull a list of users from a particular container? Using the _ADGetObjectsInOU function, Id like to pull a list of users showing thier "Display Name" and "Logon Name". Any assistance would be much appreciated! If I should not use the PM is way, please let me know. Thanks in advance. HockeyFan21Please have a look at example 2 in the _AD_GetObjectsInOU.au3 example script. Your code should look like: $sOU = "CN=...." ; The container where you would like to start searching (FQDN) $aObjects = _AD_GetObjectsInOU($sOU, "(&(objectcategory=person)(objectclass=user))", 2, "sAMAccountName,displayname") Edited August 4, 2011 by water 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...
HockeyFan Posted August 4, 2011 Share Posted August 4, 2011 Please have a look at example 2 in the _AD_GetObjectsInOU.au3 example script. Your code should look like: $sOU = "CN=...." ; The container where you would like to start searching (FQDN) $aObjects = _AD_GetObjectsInOU($sOU, "(&(objectcategory=person)(objectclass=user))", 2, "sAMAccountName,displayname") Water, Thank you so much...YOU ROCK!!! HockeyFan Link to comment Share on other sites More sharing options...
water Posted August 4, 2011 Author Share Posted August 4, 2011 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...
Recommended Posts