The following SQL code queries the O attribute, the Telephone Number attribute, and the L (local) attribute from all Organization objects. Note that the specified column names are the same as the names of the corresponding attributes. The name of the table is Organization which is the class name for all Organization objects. The Telephone Number attribute name must be enclosed in quotes since it contains a space. In the NetWare Administrator utility the O, L, and Telephone Number attribute values are labeled as Name, Location, and Telephone respectively. Notice that a <null> result is returned for the FewUsers organization's telephone number. This simply means that the attribute has not been assigned a value in eDirectory.
SELECT O, L, “Telephone Number” from Organization