Export and print a list of users and what groups they are in from Active Directory

I need to export and print a list of users and what groups they are in from Active Directory - I can right click on a user, click on edit membership groups (or something like that) and it shows all the groups - I can now print screen but that is taking a long time - Is there an easy way?

I am using AD Admin & Reporting Tool.

This message was edited 2 times. Last update was at 16/12/2009 15:38:20

Please follow the following steps for a printable group members export 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,memberOf from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 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, that is exactly what I was looking for.

I hope this type of report is needed enough by other people that maybe someday it can be worked into the program.