Easy way to extract group members in a security group into Excel

  • Thread starter Thread starter ed
  • Start date Start date
E

ed

Hi,

We need to do an audit of all our group memberships. The MMC doesn't allow
you to add a column to see group memberships. Is there an easy way to do
an export of all security groups to an Excel file? Does anyone have a
script?

Thanks in advance,

Ed
 
Thanks Cary - I was posting this new also to show a colleague how to submit
questions in newsgroups since they are new to this area. We'll do a search
for "excel" etc.
 
No problem, Ed.

I usually take the opportunity to remind people that they should first
search this NG before posting a question as it seems that the same seven or
eight questions are routinely asked ( in some way or another ).

It is always good to show a colleague the new groups and forums. They are
an excellent source of information. Shoot, when I first started with Active
Directory ( not so many moons ago ) I spent a lot of time in here!

--
Cary W. Shultz
Roanoke, VA 24014
Microsoft Active Directory MVP

http://www.activedirectory-win2000.com
http://www.grouppolicy-win2000.com
 
Hi,

We need to do an audit of all our group memberships. The MMC doesn't allow
you to add a column to see group memberships. Is there an easy way to do
an export of all security groups to an Excel file? Does anyone have a
script?
Click to expand...

Hi,
You will find examples of scripts how to enumerate groups and then group
members in the Scriptcenter which You can download from the Microsoft
Web page. Adding support for exporting it into excel file is pretty easy
 
Back
Top