[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
Export and Print Groups and their members from Active Directory  XML
Forum Index » General Discussion
Author Message
melissa



Joined: 01/10/2009 14:38:08
Messages: 6
Offline

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.
support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

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.

This message was edited 5 times. Last update was at 16/07/2012 15:59:24

melissa



Joined: 01/10/2009 14:38:08
Messages: 6
Offline

Thanks.

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



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

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

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

 
Forum Index » General Discussion
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.9 © JForum Team