# Export users from multiple groups and get user properties

**URL:** <https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220>\
**Category:** PowerShell Help\
**Created:** [April 14, 2016, 1:36am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220 "2016-04-14T01:36:40Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![windows-liveuser150](https://avatars.discourse-cdn.com/v4/letter/w/b487fb/32.png) [@windows-liveuser150](https://forums.powershell.org/u/windows-liveuser150)\
**Post date:** [April 14, 2016, 1:36am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/1 "2016-04-14T01:36:40Z")

</div>

This script works for one group. How can i get this to except multiple groups?

Get-ADGroupMember “ADGroup” -Recursive | select name | export-csv C:\Group.txt -NoTypeInformation -Append

$a = Get-Content C:\Group.txt

$a | Foreach-Object {$\_ -replace ‘"’, ‘’}| Out-File C:\Group.txt

Get-Content C:\Group.txt | Get-ADUser -Properties \* | Select-Object name,Surname,GivenName,emailaddress,distinguishedname | Export-Csv c:\Group.csv -notypeInformation

---

<div class="post-metadata">

**Author:** ![random-commandline](https://avatars.discourse-cdn.com/v4/letter/r/e56c9b/32.png) [@random-commandline](https://forums.powershell.org/u/random-commandline)\
**Post date:** [April 14, 2016, 2:48am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/2 "2016-04-14T02:48:29Z")

</div>

I don’t have access to my Active Directory environment to test, but something like this should work.

```
$groups = get-adgroup -Filter * -Properties members
$groups.members | ForEach-Object {
Get-ADUser $_ -Properties * | Select-Object name,
Surname,GivenName,emailaddress,distinguishedname} |
Export-Csv C:\groups.csv -NoTypeInformation
```

---

<div class="post-metadata">

**Author:** ![windows-liveuser150](https://avatars.discourse-cdn.com/v4/letter/w/b487fb/32.png) [@windows-liveuser150](https://forums.powershell.org/u/windows-liveuser150)\
**Post date:** [April 14, 2016, 5:01am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/3 "2016-04-14T05:01:51Z")

</div>

how does  
$groups = get-adgroup -Filter \* -Properties members

know what groups i want to export users from?

---

<div class="post-metadata">

**Author:** ![rdtechie](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/rdtechie/32/273_2.png) [@rdtechie](https://forums.powershell.org/u/rdtechie)\
**Post date:** [April 14, 2016, 5:07am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/4 "2016-04-14T05:07:33Z")

</div>

@Windows LiveUser150: Do you already have a textfile or CSV in where you have your groups specified?

---

<div class="post-metadata">

**Author:** ![windows-liveuser150](https://avatars.discourse-cdn.com/v4/letter/w/b487fb/32.png) [@windows-liveuser150](https://forums.powershell.org/u/windows-liveuser150)\
**Post date:** [April 14, 2016, 5:08am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/5 "2016-04-14T05:08:56Z")

</div>

yes. its about 10 so i just did it manually.

---

<div class="post-metadata">

**Author:** ![windows-liveuser150](https://avatars.discourse-cdn.com/v4/letter/w/b487fb/32.png) [@windows-liveuser150](https://forums.powershell.org/u/windows-liveuser150)\
**Post date:** [April 15, 2016, 5:32am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/6 "2016-04-15T05:32:33Z")

</div>

poke

---

<div class="post-metadata">

**Author:** ![david-schmidtberger](https://avatars.discourse-cdn.com/v4/letter/d/ba9def/32.png) [@david-schmidtberger](https://forums.powershell.org/u/david-schmidtberger)\
**Post date:** [April 15, 2016, 5:50am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/7 "2016-04-15T05:50:31Z")

</div>

@Windows LiveUser150:  
the code posted by random commandline would be running through all groups.

for your use-case, since you already seem familiar with get content, utilizing a text document listing the groups you want, i would do something along the lines of

```
$grouplist = get-content c:\groupstocheck.txt
foreach ($group in $grouplist)
{
get-adgroupmember $group|get-aduser -properties mail| Select-Object name,Surname,GivenName,mail,distinguishedname | Export-Csv c:\Group.csv -notypeInformation -append
}
```

obviously you could also use a CSV as an imput file and do import-csv instead but that changes a few things.

---

<div class="post-metadata">

**Author:** ![windows-liveuser150](https://avatars.discourse-cdn.com/v4/letter/w/b487fb/32.png) [@windows-liveuser150](https://forums.powershell.org/u/windows-liveuser150)\
**Post date:** [April 15, 2016, 7:33am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/8 "2016-04-15T07:33:56Z")

</div>

thanks for answering. I think i tried that but will give a shot

---

<div class="post-metadata">

**Author:** ![windows-liveuser150](https://avatars.discourse-cdn.com/v4/letter/w/b487fb/32.png) [@windows-liveuser150](https://forums.powershell.org/u/windows-liveuser150)\
**Post date:** [April 18, 2016, 5:42am UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/9 "2016-04-18T05:42:51Z")

</div>

That worked David  
At first i didnt have the -append and was only getting the last group in the list. I guess i didnt get it when i copied

Thanks

---

<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:41pm UTC](https://forums.powershell.org/t/export-users-from-multiple-groups-and-get-user-properties/6220/10 "2024-05-16T20:41:32Z")

</div>

Closed on May 16, 2024, 8:41pm UTC