[solved] Count number of specific fields - Looking For Empty Groups

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

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.

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!