How to Create Custom LDAP Query Reports?


 
Select option under AD Reports button. The Configuration Settings will appear on the screen which will allow you to select a domain and a corresponding domain controller. The report window will be launched after the domain and the selected domain controller are validated.
  
 
Right click on domain node in Custom LDAP Queries window and create a New Query. The New Query wizard will be displayed as shown below.

Step 1:Enter Custom LDAP Query Name and container(s) 


To create a Custom LDAP Query report

  1. In Name, type a query name.

  2. In Description, type a query description.

  3. Click Browse to define the container(s) from which to begin your search.


         To search all subcontainers of the selected container, select the Include subcontainers check box.

      4. Specify the Custom LDAP Query.

         The LDAP query is used to perform searches for a specific resource. To conduct your search, enter your search string here. For example, to find a common name in the domain, type (cn=name) where name is the name of the object.

      5. Click Next to proceed to the next step..


Step 2: Object Selection and LDAP query selection (optional)
   
       1. Choose Object Name from available combobox. 

        2. To specify LDAP query for the report click Edit button. For advanced LDAP query choose 'Advanced query' tab.

        3. The Report Criteria window shows up on screen. Select a fiels, an operator specify a value for the condition. Click Add to Filter button to add the filter condition. The Report Criteria windows is show below:



       4. Click OK to apply the criteria to the report. The applied report criteria would be displayed as shown below: 

     5. Choose Advanced Query to enter our manual LDAP queries.
    6. Click Next button to proceed to the next step.
Step 3:  Field Selection

   1. To select fields from a report, click on the desired field in the list of Available Fields, and then click button.

   2. To remove selected fields, click on the desired field in the list of Selected Fields, and then click button.

   3. You can use the arrow buttons to order the selected fields. To move a field up by one position in the list of selected fields click button. To move a field down by one position in the list of selected fields click button.

   4.To choose fields from another report, select the desired report from the Report Name drop-down list, and then perform the above mentioned steps.

   5. Click 'Finish' to save the Custom LDAP Query Report settings
   
The task will be added to domain node and will be displayed as shown below
  
 
To generate a Custom LDAP Query Report, Refer How to generate Custom LDAP Query Reports?