Export and Print Groups and their members from Active Directory

I have the instructions to create a printable list of users and what groups they are in from Active Directory (http://www.ldapsoft.com/forum/posts/list/56.page).
How can I create a printable list of groups and their members?

I am using AD Admin & Reporting Tool.

This message was edited 3 times. Last update was at 16/12/2009 15:39:11

Please follow the following steps for a printable list of groups and their members from Active Directory

1. Open AD Admin and reporting tool and connect to Active Directory

2. Click on the SQL button (top tool bar), copy and paste (top panel) the following statement

Select cn,member from RootDSE where objectClass=group subtreescope

3. Click on the Export button and select Excel Export

4. Uncheck ExportDN and Export Operational Attributes (Middle right)

5. Provide the file name and click Export

-------------Version 4.2+ skip to step 8 ---------------------------

6. Open the exported file - click Tool --> Macro --> Macro -- Enter a name for Macro (any name) and Click Create Button

7. Replace the text in the window with

Sub ReplaceTags2()
Dim c As Range
For Each c In ActiveCell.CurrentRegion.Cells
c.Value = Application.WorksheetFunction.Substitute(c, "|", Chr(10))
Next
End Sub

click Run button (Tool Bar)
------------------------------------------------------------------------------------

8. Select all row and columns (click top left header) copy and paste it to word.

Word will show all row text as excel has a row height limit.

Thanks.

How can I only list distribution or security groups and their members?

For Distribution Group follow all the steps mentioned above but change the step2 sql to following:

Select cn,member from RootDSE where objectClass=group and (groupType:1.2.840.113556.1.4.804:!=2147483648 or sAMAccountType=268435457) subtreescope

For security groups follow all the steps mentioned above but change the step2 sql to following:

Select cn,member from RootDSE where objectClass=group and groupType:1.2.840.113556.1.4.804:=2147483648 subtreescope