[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
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: 123
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.9 © JForum Team