4.11 Simple Search Query

The following SQL statement uses two User class attributes (Given Name and Surname) and one special column name NDS_Tree. It gathers information about users so it uses the UserNDS table. These attributes are public read attributes, so any logged in eDirectory user can execute this statement and generate a report.

SQL Statement

 SELECT "Given Name", "Surname", "NDS_Tree" 
 
 FROM UserNDS

Enter this statement into the query window, execute the statement, and retrieve the data.

Result Table

The SQL statement will generate a report similar to the following:

Table 4-10 Simple Search Query Result Report

Given Name

Surname

NDS_Tree

Kris

Hammons

NOVELL_INC

Lynn

Thayn

NOVELL_INC

Jan

Aitchison

NOVELL_INC

Alex

Buckley

NOVELL_INC

Tom

Turner

NOVELL_INC

Cory

Petersen

NOVELL_INC