Vadim Tabakman

 

LDAP Query Tool

Statistics

  • Entries (279)
  • Comments (1769)

Categories

Posted by Vadim Tabakman Sunday, March 25, 2012 7:11:00 PM Categories: Active Directory LDAP

LDAP Query Tool

Rate this Content 2 Votes

NEW VERSION RELEASED v2.0 - 12th June 2014

Click to Download the Latest Release

If you've worked with Active Directory, you know that LDAP queries are quite handy to get information out of AD.

I work with LDAP queries on a regular basis.  The one thing I have always had issues with, is remembering the query I can use and having an easy way to test it out.  So I created myself a tool where I can try different queries and save them so I can always come back to them.

 

Read more and download it here:

Copyright Vadim Tabakman

Comments

Wednesday, August 21, 2013 9:50:44 AM
martinkamke

re: LDAP Query Tool

Hello,

do you have example for the some ldap query`s?

thanx martin

 

 

Wednesday, August 21, 2013 9:57:56 AM

re: LDAP Query Tool

Hi martin,

one example is to find the members of an AD group.

Query : (&(objectclass=group)(name=Simpsons))

Property : member

This will give me the distinguished names of all members of an AD group called "Simpsons".

Hope this helps,

cheers,

Vadim

Monday, October 7, 2013 8:50:16 PM
sw4

re: LDAP Query Tool

how to get many ldap properties at once? I need a table with "full name , company, department" members of some ad group. please, email me or sent notify.

now I can get only 1 property from query, that I choose:

(&(objectClass=user)(memberof=cn=my_group,ou=Groups,dc=domain, dc=com)

If I type LDAP property: company - I get only names w/company, if I type "mail" - I got onlynames w/ email

Tuesday, October 8, 2013 11:27:19 AM

re: LDAP Query Tool

Hi sw4,

multiple properties are not currently supported.

cheers,

Vadim

Friday, May 2, 2014 8:14:08 AM
ra216
Gravatar

re: LDAP Query Tool

can you please provide any url to explain step by step execution of qurey Ldap option in nintex workflow

Saturday, May 3, 2014 11:55:12 AM

re: LDAP Query Tool

Hi ra216, what exactly are you looking for that isn't in the help for that action? cheers, vadim
Thursday, May 8, 2014 4:56:12 AM
ra216
Gravatar

re: LDAP Query Tool

Thanks vadim

Thursday, May 8, 2014 7:22:40 AM
ra216
Gravatar

re: LDAP Query Tool

hi vadim ,

After publishing nintex workflow , all the published versioning is created in the workflow setting.Is it possible to configure only latest version to be shown in the workflow published history.

Example : suppose i have created a nintex workflow called "Test1" under "library 1".I have modified and published the same workflow 10 times.so ten versions were created under
library 1-->Library tools-->Library-->workflow setting--> workflow settings-->Remove a workflow
Under this we can see all the versions of "Test1" workflow.
Is it possible to configure only latest version to be shown without provious versions.

Monday, May 26, 2014 7:43:58 AM
Rainer
Gravatar

re: LDAP Query Tool

Hi,

do you have an example for a query to check if a AD group named "yxz" already exists?
I need it for a workflow to check if the group already exists before the workflow creates a new AD group.

Best regards

Rainer

Wednesday, May 28, 2014 2:21:26 PM

re: LDAP Query Tool

Hi Rainer,

try this :

(&(objectclass=group)(name=groupname))

replace groupname with the name of the group.

If it returns empty, then that group doesn't exist.

cheers,

Vadim

Wednesday, May 28, 2014 10:30:51 PM
Nik
Gravatar

re: LDAP Query Tool

Hi Vadim,

Looking for some help in regards to search string in LDAP. We have some SIP phones that require to download the directory from AD. However, the users are distributed in multiple containers and a generic LDAP search\filter string (eg: objectclass=person) seems to return all objects (15,000)  not just users.

One comment\hint was this "you could do is specify a DN higher up in the tree and set a filter by dn & sn to only include items in the two directories you want. The syntax would be wacky but you use the FIND command on Active Directory Users and Computer to test the filter until you have it right."

Any idea on how this search\filter string would look like?

Cheers,

Nik

Thursday, June 5, 2014 7:39:37 AM
dylan666
Gravatar

re: LDAP Query Tool

Please could you add a "Base DN" field?

How can i make this search?

select the sAMAccountName of all (objectClass=user) in

OU=Users,OU=MyDomain,DC=MyDomain,DC=local

Tuesday, June 10, 2014 11:06:25 PM

re: LDAP Query Tool

HI dylan666,

what do you mean by a base DN field?

For the query you asked about, you should be able to put the OU=... line after your LDAP path.  That should point to specific location.

cheers,

Vadim

Thursday, June 12, 2014 9:10:25 AM
dylan666
Gravatar

re: LDAP Query Tool

Thanks, it was exaclty what I need!

Tuesday, July 29, 2014 6:01:17 AM
STGdb
Gravatar

re: LDAP Query Tool

Nice tool.  Quick question, what would be the format of username / password?  If I run it w/o credentials, everything works.  I'm trying to test with specific credentials but I always get a login error (even if I enter my own credentials).  And in the example above, the credentials area is rubbed out.

 

So what format should be used for the username?

 

Thanks

 

Tuesday, July 29, 2014 7:22:45 AM

re: LDAP Query Tool

Hi STGdb,

I use a domain\login format to log into my Active Directory, so that would work here.

The password is just the password for that account. No special format needed.

cheers,

Vadim

Tuesday, August 26, 2014 8:05:58 AM
dylan666
Gravatar

re: LDAP Query Tool

Please, split LDAP query result and Property in two columns using a datagrid!

And Please add support to multiple Properties  

Tuesday, August 26, 2014 8:13:09 AM

re: LDAP Query Tool

HI Dylan,

thanks for the comments.  I'll look into the datagrid for results.

As for multiple properties, that is currently supported.  Just put in a comma separate list of properties in to the properties field.

cheers,

Vadim

Thursday, August 28, 2014 9:55:34 AM
Hari
Gravatar

re: LDAP Query Tool

Hi vadim,

Its for the first time I am trying to use trying to integrate LDAP authorisation into an application. For which there is a specific procedure and I am struck in a point to identify the LDAP query . When I try to use your tool, I get an error message "unspecified error". I am using a localhost where I have installed openLDAP

These are my inputs: LDAP path: ou=groups,dc=maxcrc,dc=com, username and passwords are empty, LDAP query: objectClass=groupOfNames, Ldap properties=cn, LDAP scope = subtree.

Username: cn=Manager,dc=maxcrc,dc=com and password is secret, i get the same error if i enter it in the tool. Do you have any suggestions for me ? Thanks in Advance

Thursday, August 28, 2014 9:59:51 AM
Hari
Gravatar

re: LDAP Query Tool

An update to the above, I changed the path to LDAP://localhost:389/ou=groups,dc=maxcrc,dc=com and now I get an message "Invalid dn syntax has been specified" . Can you also let me know the proper syntax for the path ?

Thursday, August 28, 2014 4:38:01 PM

re: LDAP Query Tool

Hi Hari,

have you tried jus the LDAP path without the OU and DC parts?  See if you can query that.

cheers,

Vadim

Friday, August 29, 2014 3:19:26 AM
Hari
Gravatar

re: LDAP Query Tool

If i try ou=groups,dc=maxcrc,dc=com , I get a message "unspecified error"

Friday, August 29, 2014 7:15:20 AM

re: LDAP Query Tool

Hi Hari,

no, I meant try just the path like : LDAP://localhost:389

Have you looked at trying ADSI Edit to see if you can see what the LDAP path looks like?

cheers,

Vadim

Tuesday, October 21, 2014 6:03:33 AM
Krishna Reddy
Gravatar

re: LDAP Query Tool

Hi Vadmin

I am new to Nintex workflows

I want to get  GroupName  in ADS corresponding with their Department  name  of the particular user (ex: one user belongs to particular Department like HR,IT..... from that Dept  we can get  Group name of  that Dept )

can you  give suggestions  for how to write  Query  LDAP to get Group names

 

Tuesday, October 21, 2014 6:05:16 AM
Krishna Reddy
Gravatar

re: LDAP Query Tool

Hi Vadmin

I am new to Nintex workflows

I want to get  GroupName  in ADS corresponding with their Department  name  of the particular user (ex: one user belongs to particular Department like HR,IT..... from that Dept  we can get  Group name of  that Dept )

can you  give suggestions  for how to write  Query  LDAP to get Group names

 

Tuesday, October 21, 2014 6:06:25 AM
KRISHNA REDDY
Gravatar

re: LDAP Query Tool

I am new to Nintex workflows

I want to get GroupName in ADS corresponding with their Department name of the particular user (ex: one user belongs to particular Department like HR,IT..... from that Dept we can get Group name of that Dept )

can you give suggestions for how to write Query LDAP to get Group names

Tuesday, October 27, 2015 3:22:32 AM
Sinan
Gravatar

re: LDAP Query Tool

Hi Vadim,

I need get user information with LDAP Query on  two way trusted domains. example: SiteA.com SiteB.com SiteA and SiteB has two way trusted. 

How do I?  LDAP://SiteA.com/DC=SiteB.com

 

Thank You.

Sinan

Tuesday, October 27, 2015 3:23:39 AM
Sinan Arslan
Gravatar

re: LDAP Query Tool

Hi Vadim,

I need get user information with LDAP Query on  two way trusted domains. example: SiteA.com SiteB.com SiteA and SiteB has two way trusted. 

How do I?  LDAP://SiteA.com/DC=SiteB.com

 

Thank You.

Sinan

You must sign in to this site to post comments.
Already Registered?
Sign In
Not Yet Registered?
Register
http://vadimtabakman.com/ldap-query-tool.aspx