# Need help finding users in multiple ad groups in single list

**URL:** https://forums.powershell.org/t/need-help-finding-users-in-multiple-ad-groups-in-single-list/14072
**Category:** PowerShell Help
**Created:** [April 1, 2020, 9:51am UTC](https://forums.powershell.org/t/need-help-finding-users-in-multiple-ad-groups-in-single-list/14072 "2020-04-01T09:51:27Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![dmccullough](https://avatars.discourse-cdn.com/v4/letter/d/b487fb/32.png) [@dmccullough](https://forums.powershell.org/u/dmccullough)
#### Post date: [April 1, 2020, 9:51am UTC](https://forums.powershell.org/t/need-help-finding-users-in-multiple-ad-groups-in-single-list/14072/1 "2020-04-01T09:51:27Z")

</div>

I am tasked with getting a complete list of users from two different AD Groups. i.e. Group-A “VPN” and are also in Group-B “DEN”. I would also like to export the list with the name of the user and email address. Is this possible? I did see previous postings like this:

```
_$groups = "VPN","DEN"__$resultsarray =@()__foreach ($group in $groups) { __$resultsarray += Get-ADGroupMember -Id $group | select samaccountname,name,@{Expression={$group};Label="Group Name"}__ }__$resultsarray_
```

But it outputs into two separate lists.

```
_samaccountname name Group Name_ _-------------- ---- ----------_ _usera Test User A VPN __userb Test User B VPN__ usera Test User A DEN__userb Test User B DEN_
```

&nbsp;

I would like to output all on one line, something like this:

```
_samaccountname name Group A Group B_ _-------------- ---- ---------- ---------_ usera Test User A VPN DENuserb Test User B VPN DEN
```

Any assistance would be much appreciated!!!

&nbsp;

---

<div class="post-metadata">

### Author: ![rob-simmers](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/rob-simmers/32/1010_2.png) [@rob-simmers](https://forums.powershell.org/u/rob-simmers)
#### Post date: [April 1, 2020, 11:36am UTC](https://forums.powershell.org/t/need-help-finding-users-in-multiple-ad-groups-in-single-list/14072/2 "2020-04-01T11:36:15Z")

</div>

If the users need to be a member of BOTH groups, why are you listing what groups they are in? You can filter like so and find users that are a member of both groups:

```
$users = Get-ADUser -Properties Mail -Filter {(MemberOf -eq 'CN=SG - AppX,OU=Groups,OU=Demo,DC=DEMO,DC=LOCAL') -and (MemberOf -eq 'CN=SG - VPN,OU=Groups,OU=Demo,DC=DEMO,DC=LOCAL')} |
         Select Name,
                UserPrincipalName,
                SamAccountName,
                Mail

$users
```

---

<div class="post-metadata">

### Author: ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)
#### Post date: [May 16, 2024, 8:30pm UTC](https://forums.powershell.org/t/need-help-finding-users-in-multiple-ad-groups-in-single-list/14072/3 "2024-05-16T20:30:00Z")

</div>