Query LDAP Using Select Statements

This tutorial explains how to query ldap using select statements. To run select statements first connect to the directory server (To create a new connection please see Connecting to a LDAP Server using LDAP Admin Tool)

After successful connection, select the SQL button from the top menu, this will open the sql tab where you can enter the sql statements. You can also create simple sql statement from the right click context menu (Bottom tree pane).

Query LDAP Using Select Statments

To create a simple sql statement to query all records from a container, Select entry and from right click context menu select 'Select this record and all Children)

Select All records from a container

Ctrl+v (or paste) to paste the data to the sql window and Click Run button to run the select statement.

When you run the statement you will see the results in a tab window - If the select statement contained any where clause you will see the ldap filter created by the select statement in the status bar.