?
Solved

AD security groups

Posted on 2012-04-11
7
Medium Priority
?
361 Views
Last Modified: 2012-06-04
Hi can anyone tell me if theres a way to export the users from a Active Directory Security group to maybe like an Excel spreadsheet? I need to see how many users are in a group. Thanks
0
Comment
Question by:Thomas N
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 37833741
Sure.  Hopefully you'll have access to the csvde command:

csvde -f groupmem.csv -r "(sAMAccountName=Groupname)" -l member 

Open in new window


That'll put it in a csv file, which can easily be imported into Excel.

A second option would be to use Powershell...
0
 
LVL 1

Expert Comment

by:Tosiisoa
ID: 37833755
If you have 2008 you can export users to .csv or .txt file ADUC. (Active directory users and computers)
Just open the group you want and choose Action -> Export list...

I'm not sure if you can do this in 2003. Then you can use csvde or ldifde.
 
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37833758
in powershell

Get-ADGroupMember "Group Name" | Get-ADUser | Select-Object Name, mail | Export-Csv -Path "C:\group.csv" -NoTypeInformation
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 57

Accepted Solution

by:
Mike Kline earned 2000 total points
ID: 37833759
You can use a tool like csvde to export   http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm

I also like a third party tool (free) called adfind from MVP Joe Richards

http://www.joeware.net/freetools/tools/adfind/index.htm

Joe has some nice shortcuts

adfind -sc g:"group name" member

just want the count

adfind -sc g:"group name" member -list | adfind -c


adfind
Powershell is another good way to get this info

Thanks

Mike
0
 
LVL 6

Expert Comment

by:-tjs
ID: 37834031
Here's another nifty command built into Windows (any domain member should have this) that will list members directly in your group and also members implicitly part of your group through nested groups:

dsquery group -name "My Group Name Goes Here" | dsget group -members -expand
0
 
LVL 17

Expert Comment

by:Tony Massa
ID: 37834529
ADFind is awesome, so I'll always suggest it for stuff like this.  To expand on mkline71's post, the new version of ADFIND allows you to count the number of multivalued attributes now.  
Added -cv switch which will count values on multivalue attributes. I find this is useful for working out how many group members there are etc in a given very large group.
Hooray Joe Richards!  You're the best.
0
 

Author Comment

by:Thomas N
ID: 37952684
thanks
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
Uncontrolled local administrators groups within any organization pose a huge security risk. Because these groups are locally managed it becomes difficult to audit and maintain them.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question