http://www.ldapsoft.com/forum/posts/list/4.page JForum - http://www.jforum.net 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. ]]> http://www.ldapsoft.com/forum/posts/preList/57/193.page http://www.ldapsoft.com/forum/posts/preList/57/193.page GMT
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

[i][color=blue]Select cn,member from RootDSE where objectClass=group subtreescope[/color][/i]

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. ]]> http://www.ldapsoft.com/forum/posts/preList/57/194.page http://www.ldapsoft.com/forum/posts/preList/57/194.page GMT
How can I only list distribution or security groups and their members?]]> http://www.ldapsoft.com/forum/posts/preList/57/195.page http://www.ldapsoft.com/forum/posts/preList/57/195.page GMT
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]]> http://www.ldapsoft.com/forum/posts/preList/57/196.page http://www.ldapsoft.com/forum/posts/preList/57/196.page GMT