# Grab a list of AD Computers; determine if they are a member of this (1) secgroup

**URL:** <https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426>\
**Category:** PowerShell Help\
**Created:** [November 15, 2019, 4:00pm UTC](https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426 "2019-11-15T16:00:26Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeff-taylor](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/jeff-taylor/32/1015_2.png) [@jeff-taylor](https://forums.powershell.org/u/jeff-taylor)\
**Post date:** [November 15, 2019, 4:00pm UTC](https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426/1 "2019-11-15T16:00:26Z")

</div>

I have a set of computers in a txt file:

```
$members = Get-Content .\list.txt
```

How would I leverage this variable and query a known Security Group (MySecGroup) to see if any of those computers are members? and tell me True or False?

thank you

---

<div class="post-metadata">

**Author:** ![Olaf](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/olaf/32/992_2.png) [@Olaf](https://forums.powershell.org/u/Olaf)\
**Post date:** [November 15, 2019, 6:15pm UTC](https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426/2 "2019-11-15T18:15:13Z")

</div>

Have you tried to search for a solution? What have you tried so far?

---

<div class="post-metadata">

**Author:** ![dasgerman](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@dasgerman](https://forums.powershell.org/u/dasgerman)\
**Post date:** [November 18, 2019, 12:27pm UTC](https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426/3 "2019-11-18T12:27:27Z")

</div>

This is what I’ve come up with. There may be a better way of doing it.

```
$List = Get-Content .\list.txt
$GroupMembership = Get-ADGroupMember -Identity MySecGroup | select-object -expandproperty name
$Report = @()

foreach ($member in $GroupMembership)

{

    if($list -contains $member)
    {
   $Report += [psCustomObject]@{
   'ComputerName' = "$member"
   'Status' = "$true"}
    }

}

foreach ($member in $List)
{
    if($GroupMemberShip -notcontains $member)
    
    {
    $Report += [psCustomObject]@{
   'ComputerName' = "$member"
   'Status' = "$False"}
    }

}

Write-Output $Report
```

---

<div class="post-metadata">

**Author:** ![aapeli-hietikko](https://avatars.discourse-cdn.com/v4/letter/a/47e85d/32.png) [@aapeli-hietikko](https://forums.powershell.org/u/aapeli-hietikko)\
**Post date:** [November 18, 2019, 3:18pm UTC](https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426/4 "2019-11-18T15:18:19Z")

</div>

how about

[pre]

$list = get-content .\users.txt  
$secGroupMembers = Get-ADGroupMember ‘domain admins’ -Recursive | select -ExpandProperty samaccountname

foreach ($user in $list) {  
[psCustomObject][ordered]@{  
‘samAccountName’ = $user  
‘inSecGroup’ = $secGroupMembers -contains $user  
}  
}  
[/pre]

---

<div class="post-metadata">

**Author:** ![jeff-taylor](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/jeff-taylor/32/1015_2.png) [@jeff-taylor](https://forums.powershell.org/u/jeff-taylor)\
**Post date:** [November 19, 2019, 4:25pm UTC](https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426/5 "2019-11-19T16:25:52Z")

</div>

Thank you BenT. This works well

---

<div class="post-metadata">

**Author:** ![Olaf](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/olaf/32/992_2.png) [@Olaf](https://forums.powershell.org/u/Olaf)\
**Post date:** [November 19, 2019, 5:28pm UTC](https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426/6 "2019-11-19T17:28:44Z")

</div>

> [@](#):
>
> This is what I’ve come up with.

Don’t you feel like you just made someones homework for free? 😉

---

<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:31pm UTC](https://forums.powershell.org/t/grab-a-list-of-ad-computers-determine-if-they-are-a-member-of-this-1-secgroup/13426/7 "2024-05-16T20:31:02Z")

</div>