We help IT Professionals succeed at work.
Get Started

Help generating a csv file of users group membership with PowerShell

ndalmolin_13 asked
Last Modified: 2015-03-05
Hello Powershell Experts,

I'm trying to recreate my work domain on a virtual machine on my laptop to do some testing on.  I have recreated the OU structure.  I have recreated all of the groups (and they are in the proper OUs).  I have recreated all of the user accounts (and they are in the proper OUs).  I have used Powershell and CSV files to do all of the work up this point.  Now I would like to recreate group membership using Poweshell.  My thought was to do something like this in the production domain:

$Users = Get-QADUser  | select samaccountname

foreach ($User in $Users){Get-QADGroup -ContainsMember $user.SamAccountName | select `

I was anticipating an output like:
SamAccountName                                                                   Group
NickD                                                                                           Domain Users
NickD                                                                                          Accounting
JimJ                                                                                              Domain Users
JimJ                                                                                              IT
JimJ                                                                                             Local Admins
DrewB                                                                                        Domain Users
DrewB                                                                                        HR
DrewB                                                                                        Benefit Admin
DrewB                                                                                        Payroll

I could then take this output and export it to a csv file to move to the test domains and add membership from this file.

The problem is my code doesn't generate any output.  I just get:
SamAccountName                                                               Group

If I run the following, I get an accurate list of groups for the $user.samaccountname:
get-qadgroup -containsmember $user.samaccountname

Please help me out with what I'm doing wrong on this.

Watch Question
Most Valuable Expert 2012
Top Expert 2014
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE