JXplorer is a cross platform LDAP browser and editor. It is a standards compliant general purpose LDAP client that can be used to search, read and edit any standard LDAP directory, or any directory service with an LDAP or DSML interface. It is highly flexible and can be extended and customised in a number of ways. Apples Active Directory plug-in uses LDAP to query Active Directory. Particularly helpful on this front is a tool that can be used to move a local Mac users home folder to a network location.
- Mac Ldap Server
- Microsoft Ldap Tool
- Ldap Query Tutorial
- Ldap Query Tool For Mac Download
- Ldap Query Builder Tool
License: All 1 2 | Free
If you are looking for an SQL QueryTool that is powerful, containing all of the features that you need yet is still easy to learn and use, then FlySpeed SQL Query provides exactly what you need. This program, supporting all of the popular database structures amongst some lesser known ones, makes the task of accessing and exporting your data easy. You can also use a..
Category: Software Development / Databases & Networks
Publisher: SQL Query Tool, License: Shareware, Price: USD $29.00, File Size: 8.9 MB
Platform: Windows
Publisher: SQL Query Tool, License: Shareware, Price: USD $29.00, File Size: 8.9 MB
Platform: Windows
Free Real-time Business Intelligence for Exact Online Invantive's free SQL QueryTool for Exact Online provides you with real-time Business Intelligence across your entire enterprise. It provides access to your crucial company information stored in the Exact Online cloud. No programming, no coding, no Excel downloads; just use the SQL knowledge you already have. This enables..
Category: Business & Finance / Database Management
Publisher: Invantive Software B.V., License: Freeware, Price: USD $0.00, File Size: 281.0 KB
Platform: Windows
Publisher: Invantive Software B.V., License: Freeware, Price: USD $0.00, File Size: 281.0 KB
Platform: Windows
The QueryTool is a powerful data mining application. It allows you to perform data analysis on any SQL database. It has been developed predominately for the non technical user. No knowledge of SQL is required, most actions are data driven. NEW features : Query Builder, quickly and simply build powerful queries to interrogate your data; Summary; summarise any two columns..
Category: Business & Finance
Publisher: Tyson Software Ltd., License: Shareware, Price: USD $125.00, File Size: 2.6 MB
Platform: Windows
Publisher: Tyson Software Ltd., License: Shareware, Price: USD $125.00, File Size: 2.6 MB
Platform: Windows
Ldap Admin Tool is the premier GUI administration Tool for Ldap management, control and development. Ldap Admin Tool provides you with the ability to perform all the necessary Ldap admin routines such as creating, editing, copying, extracting and dropping Ldap objects. It supports all the latest Ldap features; moreover, you can..
Category: Utilities / Network
Publisher: LDAPSoft, License: Shareware, Price: USD $125.00, File Size: 13.4 MB
Platform: Windows
Publisher: LDAPSoft, License: Shareware, Price: USD $125.00, File Size: 13.4 MB
Platform: Windows
![Microsoft Microsoft](https://d2.alternativeto.net/dist/s/50c9bb55-a863-e411-80de-000d3a1003b1_2_full.png?format=jpg&width=1600&height=1600&mode=min&upscale=false)
If you are looking for an SQL QueryTool that is powerful, containing all of the features that you need yet is still easy to learn and use, then FlySpeed SQL Query provides exactly what you need. This program, supporting all of the popular database structures amongst some lesser known ones, makes the task of accessing and exporting your data easy. You can also use a..
Category: Software Development / Databases & Networks
Publisher: Active Database Software, License: Shareware, Price: USD $29.00, File Size: 13.5 MB
Platform: Windows
Publisher: Active Database Software, License: Shareware, Price: USD $29.00, File Size: 13.5 MB
Platform: Windows
Query, update, navigate and manage all major databases from one database Tool. RazorSQL is a universal database QueryTool, programming editor, database navigator, and administration Tool with built-in connection capabilities for DB2, HSQLDB, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and Sybase. Any other JDBC or ODBC (Windows only) compliant database..
Category: Software Development
Publisher: Richardson Software, License: Shareware, Price: USD $49.95, File Size: 14.3 MB
Platform: Windows
Publisher: Richardson Software, License: Shareware, Price: USD $49.95, File Size: 14.3 MB
Platform: Windows
Query, update, navigate and manage all major databases from one database Tool. RazorSQL is a universal database QueryTool, programming editor, database navigator, and administration Tool with built-in connection capabilities for DB2, HSQLDB, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and Sybase. Any other JDBC or ODBC (Windows only) compliant database..
Category: Software Development
Publisher: Richardson Software, License: Shareware, Price: USD $49.95, File Size: 7.0 MB
Platform: Mac
Publisher: Richardson Software, License: Shareware, Price: USD $49.95, File Size: 7.0 MB
Platform: Mac
ODBCView is a free SQL QueryTool that allows you to view and export data from any OBDC compliant database. Connect to an ODBC data source and enter a SQL statement to execute. Any resulting data is displayed on a read-only grid or it can be exported to a external CSV or HTML report file. Any valid SQL statement can be executed including UPDATE, DELETE and calls to database..
Category: Software Development
Publisher: SLIK Software Ltd, License: Freeware, Price: USD $0.00, File Size: 4.0 MB
Platform: Windows
Publisher: SLIK Software Ltd, License: Freeware, Price: USD $0.00, File Size: 4.0 MB
Platform: Windows
Mac Ldap Server
SQL QueryTool (using ODBC) is a Universal Data Access (UDA) Tool. It lets you Query ODBC data sources, author SQL scripts and queries, return Query results to a grid or free-form text, retrieve ODBC driver information, execute multiple SQL scripts or stored procedures simultaneously, and more. Supported Operating Systems: Windows 7/Server 2008 R2/Server..
Category: Business & Finance / Database Management
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 1.1 MB
Platform: Windows
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 1.1 MB
Platform: Windows
SQL QueryTool (using ODBC) is a Universal Data Access (UDA) Tool. It lets you Query ODBC data sources, author SQL scripts and queries, return Query results to a grid or free-form text, retrieve ODBC driver information, execute multiple SQL scripts or stored procedures simultaneously, and more. Supported Operating Systems: Windows x64 family (XP Professional..
Category: Business & Finance / Database Management
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 2.1 MB
Platform: Windows
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 2.1 MB
Platform: Windows
SQL QueryTool (using ADO) is a Universal Data Access (UDA) Tool. It lets you Query OLE DB data sources, author SQL scripts and queries, return Query results to a grid or free-form text, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, and more. Supported Operating Systems: Windows 7/Server 2008 R2/Server..
Category: Business & Finance / Database Management
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 1.3 MB
Platform: Windows
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 1.3 MB
Platform: Windows
SQL QueryTool (using ADO) is a Universal Data Access (UDA) Tool. It lets you Query OLE DB data sources, author SQL scripts and queries, return Query results to a grid or free-form text, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, and more. Supported Operating Systems: Windows x64 family (XP Professional x64..
Category: Business & Finance / Database Management
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 2.4 MB
Platform: Windows
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 2.4 MB
Platform: Windows
QueryTool (using ODBC) is a Universal Data Access (UDA) Tool. It lets you Query ODBC data sources, author SQL scripts and queries, execute multiple SQL scripts or stored procedures simultaneously, return Query results to a grid or free-form text, retrieve ODBC driver information, and more. Supported Operating Systems: Windows x64 family (XP Professional x64,..
Category: Business & Finance / Database Management
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 2.2 MB
Platform: Windows
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 2.2 MB
Platform: Windows
QueryTool (using ADO) is a Universal Data Access (UDA) Tool. It lets you Query OLE DB data sources, author SQL scripts and queries, execute multiple SQL scripts or stored procedures simultaneously, return Query results to a grid or free-form text, retrieve OLE DB provider properties, and more. Supported Operating Systems: Windows x64 family (XP Professional..
Category: Business & Finance / Database Management
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 2.4 MB
Platform: Windows
Publisher: George Poulose Software, License: Shareware, Price: USD $70.00, File Size: 2.4 MB
Platform: Windows
The Professional Edition of Ldap Admin Tool contains more features like predefined customiziable searches for both Ldap (common Ldap objects one click searches) & Active Directory (over 200 common one click searches). This is the edition of Ldap Admin Tool you’ll want to use if you use your machine mainly in a professional setting. For..
Category: Utilities / Misc. Utilities
Publisher: LDAPSoft, License: Shareware, Price: USD $0.00, File Size: 41.2 MB
Platform: Windows
Publisher: LDAPSoft, License: Shareware, Price: USD $0.00, File Size: 41.2 MB
Platform: Windows
AQT is a fast and easy-to-use cross-database QueryTool. With a powerful Query environment and a wide range of DBA and developer tools, it is the ideal database product irrespective of whether you are a data analyst, DBA or developer.
One Tool - this is all you’ll ever need!
Why have multiple tools when one can do it all? With AQT you can use a..
One Tool - this is all you’ll ever need!
Why have multiple tools when one can do it all? With AQT you can use a..
Category: Business & Finance / Database Management
Publisher: Cardett Associates, License: Shareware, Price: USD $180.00, File Size: 20.6 MB
Platform: Windows
Publisher: Cardett Associates, License: Shareware, Price: USD $180.00, File Size: 20.6 MB
Platform: Windows
Created originally by and for our development team to improve productivity while developing software solutions, QueryTool 2008 is a database management Tool used to simplify SQL database access, maintain connections, run SQL commands, edit data, and export results across a wide-variety of SQL database platforms. Employs a 'tabbed interface' to simultaneously..
Category: Business & Finance / Database Management
Publisher: Vertical Systems Inc, License: Shareware, Price: USD $24.95, File Size: 2.1 MB
Platform: Windows
Publisher: Vertical Systems Inc, License: Shareware, Price: USD $24.95, File Size: 2.1 MB
Platform: Windows
Booshtastic Query Tool lets you run queries against MySQL databases.
Category: Software Development / Databases & Networks
Publisher: bastecklein.com, License: Freeware, Price: USD $0.00, File Size: 320.0 KB
Platform: Windows, Mac, Vista
Publisher: bastecklein.com, License: Freeware, Price: USD $0.00, File Size: 320.0 KB
Platform: Windows, Mac, Vista
Validating and verifying that database records are being created and updated correctly is a very common Quality Assurance Task. Running SQL Queries against a database is the quickest way to extract the information that you need. Whether you are a beginner at writing SQL, or a seasoned pro, SQLStomper can help speed up the process of exploring SQL Databases, building SQL Statements, running SQL..
Microsoft Ldap Tool
Category: Utilities
Publisher: BugStomper Software, License: Shareware, Price: USD $24.99, File Size: 1.5 MB
Platform: Windows
Publisher: BugStomper Software, License: Shareware, Price: USD $24.99, File Size: 1.5 MB
Platform: Windows
Universal SQL Editor is a lightweight Intellisense-enabled database QueryTool. It allows you connect Oracle, DB2, SQL Server, Sybase and any ODBC compliant database, and edit complex SQL with Intellisense-like autocompletion, highlight references, parameter hinting, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently. In..
Category: Software Development / Databases & Networks
Publisher: Ming Software, License: Shareware, Price: USD $39.00, File Size: 2.5 MB
Platform: Windows
Publisher: Ming Software, License: Shareware, Price: USD $39.00, File Size: 2.5 MB
Platform: Windows
![Ldap query tool windows 10 Ldap query tool windows 10](https://backstage.forgerock.com/docs/opendj/2.6/admin-guide/images/Manage-Entries.png)
DBTree is a cross-platform (both database and operating system) general purpose database QueryTool. Some of the primary features of DBTree are a tabbed interface which allows you multi-database connectivity and multiple Workbooks per connection. A Workbo
Category: Software Development / Databases & Networks
Publisher: kccoder.com, License: Freeware, Price: USD $0.00, File Size: 1.1 MB
Platform: Windows, Mac, Linux, Solaris
Publisher: kccoder.com, License: Freeware, Price: USD $0.00, File Size: 1.1 MB
Platform: Windows, Mac, Linux, Solaris
SQL Developer is a is a database administration and QueryTool that provides a single consistent interface for various databases. Visually navigate through your database structure, create and execute SQL queries and scripts the easy way. Or reverse engineer complete data models with the integrated diagram editor. The follwing databases have been tested during development: Oracle..
Category: Software Development / Databases & Networks
Publisher: Jan Borchers, License: Shareware, Price: USD $99.00, File Size: 2.9 MB
Platform: Unknown
Publisher: Jan Borchers, License: Shareware, Price: USD $99.00, File Size: 2.9 MB
Platform: Unknown
A power SQL QueryTool for any databases. Provides console and GUI application; Supports Oracle, MS-SQL, PostgreSQL, MySQL, Access, Excel and so on, everyone can manage all of them in one program. Features:1. Provided Console Application (sqla.exe) and Windows Graphical User Interface (GUI) Application (wsqla.exe). 2. Supports most of popular DBMS in the world. (i.e.: Oracle, SQL..
Category: Business & Finance / Database Management
Publisher: SQLAll.Com, License: Shareware, Price: USD $29.00, File Size: 375.0 KB
Platform: Windows
Publisher: SQLAll.Com, License: Shareware, Price: USD $29.00, File Size: 375.0 KB
Platform: Windows
TotalQuery is a professional database sql QueryTool designed to make it easier to read, write and update data to all your databases. It delivers a broad range of functions and features that will help you to run multiple queries at the same time whilst being kept informed of what the connected databases are doing. Navigating the results is easy through an Excel styled grid/report..
Category: Software Development / Tools & Editors
Publisher: CoderTools, License: Shareware, Price: USD $79.95, File Size: 3.0 MB
Platform: Windows
Publisher: CoderTools, License: Shareware, Price: USD $79.95, File Size: 3.0 MB
Platform: Windows
DataLinks QueryTool allows business and IT users to quickly and easily access their data. No ODBC, writes SQL, easiest UI on the market today with simple preview data review. Data direct to Excel or XML on the fly and easily create live links. Added functionality such as de-dupe and orphaned records across disparate queries pushes DataLinks over the top.
Category: Business & Finance / MS Office Addons
Publisher: Business Intelligence, Inc., License: Commercial, Price: USD $199.99, File Size: 13.4 MB
Platform: Windows
Publisher: Business Intelligence, Inc., License: Commercial, Price: USD $199.99, File Size: 13.4 MB
Platform: Windows
The cfldap tag lets you search an LDAP directory. The tag returns a ColdFusion query object with the results, which you can use as you would any query result. When you query an LDAP directory, you specify the directory entry where the search starts and the attributes whose values to return. You can specify the search scope and attribute content filtering rules and use other attributes to further control the search.
Scope
The search scope sets the limits of a search. The default scope is the level below the distinguished name specified in the start attribute. This scope does not include the entry identified by the start attribute. For example, if the start attribute is 'ou=support, o=adobe' the level below support is searched. You can restrict a query to the level of the start entry, or extend it to the entire subtree below the start entry.
Search filter
The search filter syntax has the form attribute operator value. The default filter, objectclass=*, returns all entries in the scope.
The following table lists the filter operators:
The following table lists the filter operators:
Operator | Example | Matches |
---|---|---|
=* | (mail=*) | All entries that contain a mail attribute. |
= | (o=adobe) | Entries in which the organization name is adobe. |
~= | (sn~=Hansen) | Entries with a surname that approximates Hansen. The matching rules for approximate matches vary among directory vendors, but anything that 'sounds like' the search string should be matched. In this example, the directory server might return entries with the surnames Hansen and Hanson. |
>= | (st>=ma) | The name 'ma' and names appearing after 'ma' in an alphabetical state attribute list. |
<= | (st<=ma) | The name 'ma' and names appearing before 'ma' in an alphabetical state attribute list. |
* | (o=macro*) | Organization names that start with 'macro'. |
Springfield m1a super match serial numbers. (o=*media) | Organization names that end with 'media'. | |
(o=mac*ia) | Organization names that start with 'mac' and end with 'ia'. You can use more than one * operator in a string; for example, m*ro*dia. | |
(o=*med*) | Organization names that contain the string 'med', including the exact string match 'med'. | |
& | (&(o=adobe)(co=usa)) | Entries in which the organization name is 'adobe' and the country is 'usa'. |
| | (|(o=adobe)(sn=adobe)(cn=adobe)) | Entries in which the organization name is 'adobe' or the surname is 'adobe', or the common name is 'adobe'. |
! | (!(STREET=*)) | Entries that do not contain a StreetAddress attribute. Fiat grande punto ecu software update. |
The Boolean operators & and | can operate on more than two attributes and precede all of the attributes on which they operate. You surround a filter with parentheses and use parentheses to group conditions.
If the pattern that you are matching contains an asterisk, left parenthesis, right parenthesis, backslash, or NUL character, use the following three-character escape sequence in place of the character:
If the pattern that you are matching contains an asterisk, left parenthesis, right parenthesis, backslash, or NUL character, use the following three-character escape sequence in place of the character:
Character | Escape sequence |
---|---|
* | 2A |
( | 28 |
) | 29 |
|5C | |
NUL | 00 |
For example, to match the common name St*r Industries, use the filter:
(cn=St2Ar Industries).
LDAP v3 supports an extensible match filter that permits server-specific matching rules. For more information on using extensible match filters, see your LDAP server documentation.
(cn=St2Ar Industries).
LDAP v3 supports an extensible match filter that permits server-specific matching rules. For more information on using extensible match filters, see your LDAP server documentation.
Searching and sorting notes
- To search for multiple values of a multivalued attribute type, use the & operator to combine expressions for each attribute value. For example, to search for an entry in which cn=Robert Jones and cn=Bobby Jones, specify the following filter:filter='(&(cn=Robert Jones)(cn=Bobby Jones))'
- You can use object classes as search filter attributes; for example, you can use the following search filter:filter='(objectclass=inetorgperson)'
- To specify how query results are sorted, use the sort field to identify the attribute(s) to sort. By default, ColdFusion returns sorted results in case-sensitive ascending order. To specify descending order, case-insensitive sorting, or both, use the sortControl attribute.
- ColdFusion requests the LDAP server to do the sorting. Doing so can have the following effects:
- The sort order can differ between ColdFusion MX and previous versions.
- If you specify sorting and the LDAP server does not support sorting, ColdFusion generates an error. To sort results from servers that do not support sorting, use a query of queries on the results.
- Using filter operators to construct sophisticated search criteria can degrade performance if the LDAP server is slow to process the synchronous search routines that cfldap supports. Use the cfldap tag timeout and maxRows attributes to control the apparent performance of pages that perform queries, by limiting the number of entries and by exiting the query if the server does not respond in a specified time.
Getting all the attributes of an entry
Typically, you do not use a query that gets all the attributes in an entry. Such a query would return attributes that only the directory server uses. However, you can get all the attributes by specifying attributes='*' in your query.
If you do this, ColdFusion returns the results in a structure in which each element contains a single attribute name-value pair. The tag does not return a query object. ColdFusion does this because LDAP directory entries, unlike the rows in a relational table, vary depending on their object class.
For example, the following code retrieves the contents of the Airius directory:
If you do this, ColdFusion returns the results in a structure in which each element contains a single attribute name-value pair. The tag does not return a query object. ColdFusion does this because LDAP directory entries, unlike the rows in a relational table, vary depending on their object class.
For example, the following code retrieves the contents of the Airius directory:
<cfldap name='GetList' server=#myServer# action='query' attributes='*' scope='subtree' start='o=airius.com' sort='sn,cn'> |
This tag returns entries for all the people in the organization and entries for all the groups. The group entries have a different object class, and therefore different attributes from the person entries. If ColdFusion returned both types of entries in one query object, some rows would have only the group-specific attribute values and the other rows would have only person-specific attribute values. Instead, ColdFusion returns a structure in which each attribute is an entry.
Example: querying an LDAP directory
The following example uses the cfldap tag to get information about the people in the Airius corporation's Santa Clara office. Users can enter all or part of a person's name and get a list of matching names with their departments, e-mail addresses, and telephone numbers.
This example uses the sample Airius corporate directory that is distributed with the Netscape Directory Server. If you do not have access to this directory, modify the code to work with your LDAP directory.
This example uses the sample Airius corporate directory that is distributed with the Netscape Directory Server. If you do not have access to this directory, modify the code to work with your LDAP directory.
- Create a file that looks like the following:<!--- This example shows the use of CFLDAP --->
<html>
<head> <title>cfldap Query Example</title> </head>
<h3>cfldap Query Example</h3>
<body>
<p>This tool queries the Airius.com database to locate all people in the company's
Santa Clara office whose common names contain the text entered in the form.</p>
<p>Enter a full name, first name, last name, or name fragment.</p>
<form action='cfldap.cfm' method='POST'>
<input type='text' name='name'><br><br>
<input type='submit' value='Search'>
</form>
<!--- make the LDAP query --->
<!-- Note that some search text is required.
A search filter of cn=** would cause an error -->
<cfif (isdefined('form.name') AND (form.name IS NOT '))>
<cfldap
server='ldap.airius.com'
action='query'
name='results'
start='ou=People, o=Airius.com'
scope='onelevel'
filter='(&(cn=*#form.Name#*)(l=Santa Clara))'
attributes='cn,sn,ou,mail,telephonenumber'
sort='ou,sn'
maxrows=100
timeout=20000
>
<!--- Display results --->
<table border=0 cellspacing=2 cellpadding=2>
<tr>
<th colspan=4><cfoutput>#results.
RecordCount# matches found</cfoutput>
</th>
</tr>
<tr>
<th>Name</th>
<th>Department</th>
<th>E-Mail</th>
<th>Phone</th>
</tr>
<cfoutput query='results'>
<tr>
<td>#cn#</td>
<td>#listFirst(ou)#</td>
<td><a href='mailto:#mail#'>#mail#</a></td>
<td>#telephonenumber#</td>
</tr>
</cfoutput>
</table>
</cfif>
</body>
</html> - Change the server attribute from ldap.airius.com to the name of your installation of the Airius database.
- Save the page as cfldap.cfm and run it in your browser.
Reviewing the code
The following table describes the code:
Ldap Query Tutorial
Code | Description | |
---|---|---|
| Uses a form to get the name or name fragment to search for. | |
| Ensures that the user has submitted the form. This is necessary because the form page is also the action page. Ensures that the user entered search text. | |
| Connects anonymously to LDAP server ldap.airius.com, query the directory, and return the results to a query object named results. Starts the query at the directory entry that has the distinguished name ou=People, o=Airius.com, and searches the directory level immediately below this entry.Requests records for entries that contain the location (l) attribute value 'Santa Clara' and the entered text in the common name attribute.Gets the common name, surname, organizational unit, e-mail address, and telephone number for each entry.Sorts the results first by organization name, then by surname. Sorts in the default sorting order.Limit the request to 100 entries. If the server does not return the data in 20 seconds, generates an error indicating that LDAP timed out. | |
| Starts a table to display the output. Displays the number of records returned. Displays the common name, department, e-mail address, and telephone number of each entry.Displays only the first entry in the list of organizational unit values. (For more information, see the description that follows this table.) |
Ldap Query Tool For Mac Download
This search shows the use of a logical AND statement in a filter. It returns one attribute, the surname, that is used only for sorting the results.In this query, the ou attribute value consists of two values in a comma-delimited list. One is the department name. The other is People. This is because the Airius database uses the ou attribute type twice:
Ldap Query Builder Tool
- In the distinguished names, at the second level of the directory tree, where it differentiates between organizational units such as people, groups, and directory servers
- As the department identifier in each person's entry
Because the attribute values are returned in order from the person entry to the directory tree root, the ListFirst function extracts the person's department name.