This spreadsheet is for the batch querying of multiple objects of the same type. LDAP attributes can be specified and compared against lists of objects in columns.

The control buttons on the left hand side perform the following function:

Button	Functionality
Read	Will  read the objects specified in column E sequentially populating the LDAP attributes specified as row headers, column F and Higher
Clear	Clears the contents of columns F and higher leaving the column headers intact

When reading Objects specified in column E objects will be read sequential starting in cell E2 and continuing in column E until an empty cell is found.

Objects can by specified in cell "B15" by Either;

•     Common Name
•     Samaccountname
•     Distinguished name

The object category is specified in "B16", this can either be;

•    User
•    Group
•          Computer
•    Contact

Populate the LDAP attributes you wish to read as the headers of columns F and higher.

Populate the objects of the desired type that are to be read in column E and select the "Read" button.

Distinguished names will be read directly and offer the best performance in large directory structures. Common names or Samaccountname need to have their distinguished names queried and there is small time delay for each object in performing this lookup.

The error result of the reading objects will be displayed in column D:

Result
OK	The object has been read successfully
Not found	The object or attribute cannot be found
Error	There is an error reading the object or attribute

• < Prev
• Next >