The power of filter definitions

In general there is no limitation in defining a LDAP filter for the LDAP request. The flexibility is now shown in some exercises. The opportunity to aggregate the result sets will be especially illustrated.

A predefined user list (in a excel spreadsheet, for example) should be enhanced with the mail address. This can be easily realized by defining a "custom search" operation. In this example the group membership to domain administrators is the predefined criteria, but you can use also any other condition. First of all you will define an attribute category named mail. The picture shows the details:

The created category will now be used by the connection profile:

The list view layout will be selected.

The filter definition contains the following settings:

(memberOf=CN=Administratoren,CN=Builtin,DC=mydomain,DC=de)

The string "mydomain" and "de" has to be replaced with real values.

The summary screen looks like this:

The summary page offers the option to create an unattended answer file. This means you can specify e.g. an MS-Excel file, which will be produced automatically and which contain the objects with the desired attributes without any user activity. Excel should be installed on the machine of course, where the program is executed.

The Export Folder now contains the following files:

The following excel sheet will be produced by double clicking on run 'mail' import file:

When you finish the profile wizard in the user interface, the result can be exported of course into Excel manually through the context menu.