Solved

Exporting security groups with user information, csvde - csv dump

Posted on 2013-11-25
5
1,248 Views
Last Modified: 2014-01-14
Hi,

How's it going? I'm wondering if anyone can help me with a shell command that will export all security groups from a specific OU with the names\accounts of each member of the groups in a format that's  importable to a new AD domain.  

I've tried going to a few sites and using various commands but I'm running into issues as I'm a complete noob, this one doesn't work at all and I'm in a rush due to a project.
"csvde -d "ou=West,dc=MyDomain,dc=com" -f group.csv -l objectClass,cn,member,distinguishedName,sAMAccountName,groupType,objectCategory"

Any help would be most appreciated.

Cheers
0
Comment
Question by:RWA203
  • 3
5 Comments
 
LVL 30

Expert Comment

by:Gareth Gudger
Comment Utility
Try looking at the Import/Export options of LDIFDE.
http://support.microsoft.com/kb/237677
0
 
LVL 40

Expert Comment

by:Subsun
Comment Utility
You can use the following script if you have MS AD PowerShell enabled..
Get-ADGroup -Filter {GroupCategory -eq "Security"} -ResultSetSize Unlimited | % {
$Group = $_
Get-ADGroupMember $Group.Name | Select @{L='GroupName';e={$Group.Name}},Name,ObjectClass
} | Export-Csv C:\Result.csv -NoTypeInformation

Open in new window

If not you may install Quest AD PS in any member computer in you domain and use the following script..
ActiveRoles Management Shell for Active Directory
Get-QADGroup -SizeLimit 0 | ?{$_.GroupType -eq "Security"} | % {
$Group = $_
Get-QADGroupMember $Group.Name | Select @{L='GroupName';e={$Group.Name}},Name,Type
} | Export-Csv C:\Result.csv -NoTypeInformation

Open in new window

0
 

Author Comment

by:RWA203
Comment Utility
Cheers, I have powershell. I'll give it a try.
0
 

Accepted Solution

by:
RWA203 earned 0 total points
Comment Utility
I ended up using Manage engines ADManager Plus, which is what I would recommend to anyone doing a migration. The 30 day trial gives you full reports functionality for just about anything you can think of as well as bulk import export stuff. Really useful.
0
 

Author Closing Comment

by:RWA203
Comment Utility
This is far easier and has all reports built into a gui, rather then trying to learn the powershell commands or learning to script .Great for non scripty people who need to get things done quickly.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
A procedure for exporting installed hotfix details of remote computers using powershell
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now