# Adding other fields not available to Get-ADGroupMember

**URL:** <https://forums.powershell.org/t/adding-other-fields-not-available-to-get-adgroupmember/9299>\
**Category:** PowerShell Help\
**Created:** [September 5, 2017, 7:18pm UTC](https://forums.powershell.org/t/adding-other-fields-not-available-to-get-adgroupmember/9299 "2017-09-05T19:18:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![abasel](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@abasel](https://forums.powershell.org/u/abasel)\
**Post date:** [September 5, 2017, 7:18pm UTC](https://forums.powershell.org/t/adding-other-fields-not-available-to-get-adgroupmember/9299/1 "2017-09-05T19:18:48Z")

</div>

I am currently using the following command:  
  
**Get-ADGroupMember -Identity “ISE-EEFF-SDA-STANDARD” | Select Name,SamAccountName,DistinguishedName | Export-CSV -Path ISE-EEFF-SDA-STANDARD.csv -NoTypeInformation**

I am wanting to expand it so that I also get first (givenName), and last names (SN). How would I go about doing this?

---

<div class="post-metadata">

**Author:** ![miracles1315](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@miracles1315](https://forums.powershell.org/u/miracles1315)\
**Post date:** [September 5, 2017, 7:47pm UTC](https://forums.powershell.org/t/adding-other-fields-not-available-to-get-adgroupmember/9299/2 "2017-09-05T19:47:33Z")

</div>

You can do a custom attribute for them.

```
$ADGrpMems = Get-ADGroupMember -Identity ISE-EEFF-SDA-STANDARD
$ADGrpMems | Select-Object -Property Name,SamAccountName,DistinguishedName,@{Name = "FirstName";Expression = {(Get-ADUser $_.DistinguishedName).GivenName}},@{Name = "LastName";Expression = {(Get-ADUser $_.DistinguishedName).SurName}} | Export-CSV -Path ISE-EEFF-SDA-STANDARD.csv -NoTypeInformation
```

---

<div class="post-metadata">

**Author:** ![miracles1315](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@miracles1315](https://forums.powershell.org/u/miracles1315)\
**Post date:** [September 5, 2017, 7:48pm UTC](https://forums.powershell.org/t/adding-other-fields-not-available-to-get-adgroupmember/9299/3 "2017-09-05T19:48:48Z")

</div>

Updated the above code to include the export to CSV.

---

<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:** [September 6, 2017, 9:36am UTC](https://forums.powershell.org/t/adding-other-fields-not-available-to-get-adgroupmember/9299/4 "2017-09-06T09:36:59Z")

</div>

why not just pipe from get-adgroupmember straight to get-aduser.

```
Get-ADGroupMember -Identity "ISE-EEFF-SDA-STANDARD" |get-aduser -prop givenname,surname|select name,give
nname,surname,samaccountname,Distinguishedname| Export-CSV -Path ISE-EEFF-SDA-STANDARD.csv -NoTypeInformation
```

---

<div class="post-metadata">

**Author:** ![abasel](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@abasel](https://forums.powershell.org/u/abasel)\
**Post date:** [September 6, 2017, 4:42pm UTC](https://forums.powershell.org/t/adding-other-fields-not-available-to-get-adgroupmember/9299/5 "2017-09-06T16:42:49Z")

</div>

Many thanks, I went with the 2nd option and it worked like a treat.

---

<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:37pm UTC](https://forums.powershell.org/t/adding-other-fields-not-available-to-get-adgroupmember/9299/6 "2024-05-16T20:37:38Z")

</div>