13/09/99
What's new in v1.23:
- . comparison of dates ( last login time...) was rejected due to a type error (integer)
- . comparison operators were in english in the french version ;-)
------------------------------------------------------------------------------------------
This Delphi 3 application allows you to select a class of NDS object,
some properties you want to collect, additionnal conditions on values (exist,
non exist, equal, greater, less, between, contains...), exportation options
( delimiters...) and send the ouput of the search to a rich text edit.
Results can be edited (copy, paste, find, replace..) and saved to a text
file suitable for importation to databases products. Queries can be saved/reloaded
both in " internal format" or in SQL syntax. English and French version
available in the ZIP. Netware 32 bit clients
On the first screen, you select a starting context and class from the
list of available classes of your NDS shema.
On the second screen, you select as many properties as you want to export.
Only properties available for the selected class are shown. Currently,
supported properties types are string, longint, boolean and date.
You may select several times the same property to apply on it several
conditions (such as contains 'foo' and not contains 'bar'). The Up and
down arrows allows you to specify the order of the columns in the text
file.
On the third screen, you specify the conditions you want on the selected
properties. In the following example , we are looking for users have their
preferred server as Eurinsa and a Foreign e-mail address (SMTP), but no
Internet E-Mail address (LDAP)
You can enter values in the second and third columns only if the selected
operator requires one or two arguments. String comparisons are done without
respect of the case. The column 'Display' allows you not to display a property
with a condition on it.
Type checking and number of arguments will be done when you press on the
'Next' buttons. Here is some errors messages you may get :
On the fourth screen, you define some exportation options:
-
Sorting or not results by NDS login name (CN); no other reordering is currently
supported. It could be done anyway after importation to the database program.
-
Removing or not the full context names for related objects (i.e: an home
directory will be displayed as NDS:\\context\volume_name,path or only volume_name,path).
-
Perform a recursive search in the sub-containers.
-
Adding or not the properties names on the first line ( for further importation
to a database with automatic creation of the appropriate field names).
-
Adding or not the name of the container in column 1. This may be of some
use in recursive searches.
-
emitting or not the SQl on the top of the result
-
Using or not a delimiter around each column
-
Defining the three delimiters ( around values, between columns and between
each values for multi-valued properties).
You you get the results in the fifth screen. Results can be edited and
saved to a text file. A SQL statement is built from you visual query an
can be saved for later use.
The following example shows the use of multiple conditions on the same
properties. We are looking for group of which I am a user (member contains
ppollet) and of which my colleague (gay) is not in.
The multi-valued property member of the found group are separated by
a space, as specified in the option screen (default value).
