re: How Can I Count the Number of Users in a Group?

Peter V — Mon, 09 Apr 2012 23:14:07 GMT

For just a simple search using joeware.net (free tool) adfind you can... Copy the below into a batch file and execute with adfind.exe in the same directory.

-------------------------------------------------------------------------------------------------------------------------

for /f "delims=" %%i in ('adfind -default -rb ou^=groups -f objectclass^=group distinguishedName -list') do (

for /f %%b in ('adfind -list -c -f ^"memberof^=%%i^" -c') do echo "%%i",%%b>> allgroupscount.csv

)

-------------------------------------------------------------------------------------------------------------------------

Explanation of Above (remarked out for my batch file.)

rem del d:\sharetest\allgroupscount.csv removes old output file so data is not appended

REm "delims=" ignores all delimiters (spaces) and reads entire line

REm %%i in ('adfind -default -rb ou^=groups -f objectclass^=group distinguishedName -list') passes the output of adfind to for loop

REM do ( allows for mulit function call from for loop

REM for /f %%b in ('adfind -list -c -f ^"memberof^=%%i^" -c') do echo "%%i",%%b>> d:\sharetest\allgroupscount.csv nested for loop that passes variables to csv file

rem ) end of for loop multi call

rem the caret symbol ^ is an escape character telling 'for' not to treat the following character as a control character.

re: How Can I Count the Number of Users in a Group?

OurTech — Mon, 01 Aug 2011 22:22:43 GMT

So can we use this script to output to a CSV with groups in an OU and how many users are in each group? How would we go about that?

Thanks.