This example queries the attributes of a user. Notice that the table name, UserNDS, is not the same as the object class name, User. This is because user is a keyword in SQL. Also, the NDS_Context, NDS_FullName, and NDS_Tree columns do not correspond to eDirectory attributes but are special columns available for each entry.
select CN, Surname, NDS_Context, NDS_FullName, NDS_Tree from UserNDS
Table 4-12 User Class Query Result Report
Notice that Michael Anderson is listed twice in the table. CN is a multi-valued attribute and two values have been entered: Michael and Mike. Only the first value is used in the object’s distinguished name, or as the column labels it, in the object’s NDS full name.