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

[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

 

[Cary Shultz [A.D. MVP]]

Ed,

Take a quick look in this newsgroup. This question is asked a lot. There
was recently someone who posted a way to do this via an excel
spreadsheet.......

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

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

 

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

 

[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

 

[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