This spreadsheet is for the batch reading of membership of multiple objects. For each object either members or member of can be read.
The control buttons on the left hand side perform the following function:
Button |
Functionality |
Read |
Will read the objects specified in either row 1 and 2 or columns D and E sequentially populating the members properties in either rows or columns |
Clear Results |
Clears the contents of columns F and higher leaving the column headers intact |
The objects can be read in one of two formats which are specified in Cell "B15":
Format |
Functionality |
Column |
The objects to be read are specified in Row 1 and 2 in the column headers. The objects are read sequentially from Cell F1 until an empty cell is found. The membership of the objects are listed in the same column as their column header. |
Row |
The objects to be read are specified in Column D and E starting cell D3 and read sequentially through column D until an empty cell is found, The membership of the objects are listed in the same row as the header in column D and E. |
The membership can be read either members or memberof specified in Cell "B16"
Format |
Functionality |
Members |
Lists sequentially the members that are in the group object. |
Memberof |
Lists sequential the groups that the object is a member of. |
Output can be in 3 possible formats specified in Cell "B17"
Format |
Functionality |
Name |
The netbios names of the members or memberof |
Server\Name |
The full netbios names including Domain, Server or workstation netbios name |
ADSPath |
Of the form WINNT://Domain/Server/Object |
Once the object names to be read have been populated as column or row headers select the Read Button.
The objects will be read and membership names populated in columns or rows;
Result |
|
Empty Cell |
The object has been successfully read and has no membership |
List of members names |
The object has been successfully read and has membership listed |
Object not found |
An object of this name cannot be found |
Error |
There is an error reading the object |
Once all the objects membership has been read then the membership will also be outputted in a list format in the list sheet. Each row will have a object name and membership name. All the membership will be listed row by row until every membership for every object has been listed.
- Details
- Category: Client Server
- Published: 04 November 2013