This spreadsheet is for the batch reading of multiple groups at the same time. For each group read the members LDAP attribute is enumerated so each member is listed in a cell.

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

Button	Functionality
Read	Will  read the objects specified in either row 1 or column D sequentially populating the LDAP members attributes in either rows or columns
Clear	Clears the contents of columns E and higher leaving the column headers intact

The objects can be read in one of two formats which are specified in Cell "B16":

Format	Functionality
Column	The groups to be read are specified in Row 1 in the column headers. The groups are read sequentially from Cell E1 until an empty cell is found. The members of the groups are listed in the same column as their column header.
Row	The groups to be read are specified in Column D starting cell D2 and read sequentially through column D until an empty cell is found, The members of the groups are listed in the same row as the header in column D.

For groups with large membership use Column input/output.

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

·         Common Name

·         Samaccountname

·         Distinguished name

Both the input and output will be in the specified naming format. 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.

Once the group names to be read have been populated as column or row headers select the Read Button.

The groups will be read and members names populated in columns or rows;

Result
Empty Cell	The group has been successfully read and has no members
List of members names	The group has been successfully read and has members listed
Object not found	A group of this name cannot be found in the AD
Error	There is an error reading the group

Once all the groups members have been read then the members will also be outputted in a list format in the list sheet. Each row will have a group name and member name. All the members to groups will be listed row by row until every member for every group has been listed.

 

• < Prev
• Next >