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


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
 
Ad

Advertisements

E

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.
 
C

Cary Shultz [A.D. MVP]

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
 
Ad

Advertisements

T

Tomasz Onyszko [MVP]

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?
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top