[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
[solved] Count number of specific fields - Looking For Empty Groups  XML
Forum Index » General Discussion
Author Message
davideladio



Joined: 15/01/2014 09:45:58
Messages: 4
Offline

Hi there, i'd like to count, for example, how many 'member' objects it has so i can detect empty groups.

i'm trying different sql querys but no one works...

Any help? many thanks in advance!

finally i found the solution myself, this is the ldapsql query i used:

select $cn from ROOTDSE where $objectClass='group' and not $member=*

It returns some non empty groups, i dont know why, but is a great starting point and with a little bit of Excel work around i have what i need.

Hope it helps someone else.

This message was edited 1 time. Last update was at 20/01/2014 04:39:04

davideladio



Joined: 15/01/2014 09:45:58
Messages: 4
Offline

i also tried

select * from ROOTDSE where $objectClass='group' and not $member

but didnt work... i'm looking for every group without members in my active directory...

Thanks!
 
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