6/18/2023 0 Comments Ldap query user distinguished nameThere are a handful of methods for querying AD but the method I am using here is with a Linked Server and OPENQUERY.įor the linked server you will need to know what to connect to (probably a domain name or possibly a domain controller) and an account with password that will allow you access. If you don’t know what a column is called then you’ll never get to see it. Also unlike SQL, you can’t simply extract all columns from a table with an asterisk in order to ascertain what is available. I’d like to think it wasn’t but, that is how it looks.įirstly, depending upon the version of various bits and pieces an LDAP query will return either 901 rows or 1000 rows, before an error is raised. Having looked through a slew of internet resources it is obvious that the work required to do this has changed little over many years – and it looks like is was deliberately designed to make it difficult. Recently I have had to extract user’s details from Active Directory (AD) for certain security groups.
0 Comments
Leave a Reply. |