LDAPSoft LDAP And Active Directory Tools Community Forums LDAPSoft Home
  [Search] Search   [Register] Register /  [Login] Login 
Please note that the forums are no longer being maintained by our staff as we provide live technical support with livehelp. Please use

live help or contact support in case of any technical question. For other questions please contact our customer service at 1-800-553-4131

 

Live Help

  Customer Service
contact us Tel.: 1-(800)-553-4131
E-mail: customerservice@ldapsoft.com
Technical Support
contact us Tel.: 1-(800)-553-4131
E-mail: support@ldapsoft.com
List all the users in an AD group and export that to an Excel worksheet SQL syntax  XML
Forum Index » General Discussion
Author Message
chrisT



Joined: 27/07/2010 14:33:52
Messages: 5
Offline

I would like to list all the users in an AD group and export that to an Excel worksheet. What is the SQL syntax to query and report that information

For example, I have group Presidents and I want to list all the presidents in that AD group.
support



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

Try the following statement where cn is the name of the group.

Select member from RootDSE where objectclass='group' and cn='Presidents'
chrisT



Joined: 27/07/2010 14:33:52
Messages: 5
Offline

Thanks for the sql syntax.
 
Forum Index » General Discussion
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.8 © JForum Team