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 5 times. Last update was at 16/07/2012 15:59:24

Version 6.2
1. Open AD Admin and reporting tool and connect to Active Directory
2. Select Audit Exports (Main Menu) | PDF Export and Select All Groups With Members from All Groups Tab

Version 6.0 and earlier

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

6. 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?

This message was edited 1 time. Last update was at 16/07/2012 16:01:29

Version 6.2

Select Audit Export| In PDF Format| Select Distribution or Security Groups Under All Groups Tab.

Version 6.0 & Earlier

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