The project created in this example can also be found in the directory \Tools4ever\User Management Resource Administrator\Example Projects\Generic\Tables\DisabledUsers\DisabledUsers.ufp.
LDAP table - Creating a table listing all disabled users in a domain
Start the UMRA Console application and connect to the UMRA Service: Select UMRA Service, Connect&ldots; and connect to the computer on which the UMRA Service is installed.
Start the UMRA Console and create a new Forms project.
Right-click in the Forms window and choose the Add form field command.
Select the Table option.
Select the Generic table option and click the Configure button.
Click the Configure button once more.
Select the option LDAP query under Table type. A dialog box appears to configure your LDAP table.
Click the LDAP binding tab. In this window, the binding method for the LDAP query is specified. You can either choose a default binding to the Global Catalog or Active Directory root, or define your own binding string. For this example, we want to perform an LDAP search on all user objects in a domain, so we can select the option Global Catalog. This is is a searchable master index with data about all objects in the domain.
Click the LDAP Filter tab to define a search filter.
You can either enter an LDAP search query directly in the LDAP search filter window or select a predefined search filter from the Example LDAP search filters list box. For this example, please enter the following LDAP query:
(&(objectCategory=person)(objectClass=user) (userAccountControl:1.2.840.113556.1.4.803:=2)).
The next step is to specify which attributes should be returned.
Click the Attributes tab.
The list of attributes for an Active Directory is endless. Which one you need to choose, also depends on the script action you wish to perform on the user selection. For this simple example, select the predefined attribute setting "Users - general information". This will return the cn attribute and the description attribute. Click the Set button when you are done. The LDAP query is now ready to be tested.
Click the Run test tab.
Click the Test button. The result of your LDAP query will appear in the Table data section. Click OK three times to return to the Forms window.
Right-click in the form window and choose the Toggle auto preview command to preview your table. The result should be similar to the figure shown below (the user names in your network will of course be different).
You have now created an LDAP table which returns all the disabled users in a domain. Script actions can now be added to your project specifying what action needs to be performed on the selected data.
See also:
UMRA tables - Special table type - Generic table Variable
UMRA tables - Assigning selected table entries to a variable
Hands-on:
Examples - UMRA tables - Creating a form table to connect to a database
Examples - UMRA tables - Showing the content of a variable in a form table