[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
Searching users with memberof  XML
Forum Index » General Discussion
Author Message
jjohn



Joined: 08/02/2010 19:10:57
Messages: 6
Offline

Sorry I am not good at this SQL query stuff but in my AD I am looking for membership in a particular group using memberOf but I am not getting the correct results.

Here is the sql statement I am running:

SELECT displayName FROM OU=Users,OU=TEST,DC=electric,DC=net WHERE memberOf NOT 'CN=zz%All TEST,OU=Groups,OU=TEST,DC=electric,DC=net'

Thanks
support



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

You can't have any wild character (%) in DN.
jjohn



Joined: 08/02/2010 19:10:57
Messages: 6
Offline

hmm thats the actual name for the group
zz%all TEST
support



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

Try escaping % with \
jjohn



Joined: 08/02/2010 19:10:57
Messages: 6
Offline

works with the \ thank you
 
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