title: Export the AD Group Membership of a list of users from a CSV Powershell
body: <p>I am trying to get a CSV output of all the users in the 'VPN Users' group that are also in the 'Domain Users' group. I'd like it to give their name and then their group membership. Each member should only be in the VPN group. I am looking to identify who is in both groups.</p>
  <p>To achieve this I have first exported a list of the users in the VPN Group to a CSV which works fine. Second part of the code is meant to go through the list of users in the CSV from that AD group and export an output as a CSV containing the users and their group membership which isn't working for me. For each user in the CSV it returns the error: Get-ADUser : Cannot find an object with identity: '&quot;User001_vpn&quot;'.....</p>
  <p>I'm not sure if the way I'm going about it is the best way to achieve the task in hand or if any of you might be able to help me make it work? It seems like Get-ADUser isn't finding the users from the CSV.</p>
  <pre><code>#Retrieves list of users that are in the VPN Users group and exports them into a CSV
  (Get-ADGroupMember &quot;VPN Users&quot; -Recursive | Get-ADUser -Properties * |
  Select-Object SamAccountName |
  ConvertTo-Csv -NoTypeInformation) |
  Select-Object -Skip 1 |
  Set-Content -Path &quot;C:\Documents\VPN Users Report\VPNUsers.csv”
  
  
  Get-Content “C:\Documents\VPN Users Report\VPNUsers.csv” | Get-ADUser | ForEach{
      $user = $_
      $groups = Get-ADPrincipalGroupMembership $user
      $groups | %{ New-Object PSObject -Property @{ User = $user.SamAccountName; Group = $_.SamAccountName } }
  } | Export-Csv &quot;C:\VPN Users Report\Results\Output.csv&quot;
  
  </code></pre>