gcue Posted March 28 Posted March 28 np at all im already converting via regex (which i think would be faster than _AD_FQDNtoSamAccountName) thought it'd be a cool add since the similar function provides the option. i even tried copilot but it didnt work. this is what copilot suggested $__oAD_Command.CommandText = "<LDAP://" & $sAD_HostServer & "/" & $sGroup & ">;;sAMAccountName;" & $sRange & ";base" that didnt work - got an empty array then it suggested but same issue $__oAD_Command.CommandText = "<LDAP://" & $sAD_HostServer & "/" & $sGroup & ">;;member;" & $sRange & ";base" $__oAD_Command.PropertiesToLoad.Add("sAMAccountName") no worries - not a big issue just thought id check with you - maybe there's extra syntax in the ldap query to specify to already get return value in samaccountname format - which would be the fastest route
water Posted March 28 Author Posted March 28 (edited) Will put your request onto my to-do-list. What I will be working on in the next few months is the ability to request additional properties to be returned by the LDAP query. Example: _AD_GetAccountsExpired now only returns the FQDN, the expiration date/time in UTC and local time of expired accounts. You will then be able to request additional properties like sn, givenname etc. As long as they belong to the same class ("user" in this example). Edited March 28 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
gcue Posted March 28 Posted March 28 awesome. let me know if you need any help testing the least i could do - very thankful to you
water Posted March 28 Author Posted March 28 👍 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
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