[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 666
  • Last Modified:

Export group membership of Security groups

How do I export the list of members of security groups in the Active Directory?  I have an OU name "Security Groups", under which I have around 200 security groups.  Each group has a bunch of members.  I want to export them, sort them by the group owner, add a page break after each owner and print it.

I have no clue about scripting.  Are there any scripts available that can do this for me.

Please help!!!

Thanks,

Juzar
0
jzaveri
Asked:
jzaveri
  • 3
1 Solution
 
karstiemanCommented:
I have written a tool for this.
I cannot upload it, so mail me and i'll send it to you.
0
 
karstiemanCommented:
mail me at karstenreisser at hotmail dot com
0
 
oBdACommented:
Chcek the batch script below, it will create a text file in the folder where you start the script.
You can then open the text file in any editor or word processing programs of your choice, and replace [Break] with any string of your choice.

karstieman,
please check EE's help (http://www.experts-exchange.com/help.jsp), under Success Tips > About using email to solve your problem:
"The use of email to resolve a question at Experts Exchange is prohibited, because it gives the emailing Expert an unfair advantage over the other participants in a question. The same applies to the use of Remote Access to resolve a problem. Points cannot be awarded for a solution that is not posted on the site."

@echo off
setlocal
set LogFile=%~dpn0.log
:: *** Set Output to DN or Name:
set Output=DN
:: *** OU in which to search the groups:
set RootOU=ou=Security Groups,dc=your,dc=domain,dc=local
 
if exist "%LogFile%" del "%LogFile%"
for /f "delims=" %%a in ('dsquery group "%RootOU%" -limit 0') do call :process %%a
goto :eof
:process
set GroupDN=%~1
for /f "tokens=2 delims=,=" %%s in ("%GroupDN%") do set GroupName=%%s
echo Processing %GroupName% ...
if /i "%Output%"=="DN" (
  >>"%LogFile%" echo %GroupDN%
) else (
  >>"%LogFile%" echo %GroupName%
)
for /f "delims=" %%a in ('dsget group "%GroupDN%" -members') do (
  if /i "%Output%"=="DN" (
    >>"%LogFile%" echo %%a
  ) else (
    for /f "tokens=2 delims=,=" %%s in ("%%a") do >>"%LogFile%" echo %%s
  )
)
>>"%LogFile%" echo [Break]
goto :eof

Open in new window

0
 
karstiemanCommented:
@oBdA: didn't know that.
My program just existed of a couple of forms and I couldn't upload it...
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now