LDAPSoft LDAP And Active Directory Tools Community Forums
Search
Register
/
Login
List all the users in an AD group and export that to an Excel worksheet SQL syntax
Forum Index
»
General Discussion
Author
Message
27/07/2010 14:36:40
Subject:
List all the users in an AD group and export that to an Excel worksheet SQL syntax
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.
27/07/2010 15:00:11
Subject:
Re:List all the users in an AD group and export that to an Excel worksheet SQL syntax
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'
27/07/2010 15:51:37
Subject:
Re:List all the users in an AD group and export that to an Excel worksheet SQL syntax
chrisT
Joined: 27/07/2010 14:33:52
Messages: 5
Offline
Thanks for the sql syntax.
Forum Index
»
General Discussion
Go to:
Select a forum
General Discussion
Feature Requests
Report Bugs
Official Bug List [read only]
Recent Topics
Hottest Topics
Member Listing
Powered by
JForum 2.1.9
©
JForum Team