Selection of only one user from list

Question

I have this script that I need to use to retrieve the data of a particular user "ADTuser" from a list of servers the script works well, but the output file with my user add also other users' detail that is not needed for my final output how can I filter it to only the user that I need.

get-content C:\servers.txt | foreach-object { 
    $Comp = $_ 
    if (test-connection -computername $Comp -count 1 -quiet) { 
        ([ADSI]"WinNT://$comp").Children | ?{$_.SchemaClassName -eq 'user' } | %{ 
            $groups = $_.Groups() | %{$_.GetType().InvokeMember("Name", 'GetProperty', $null, $_, $null)} 
            $_ | Select @{n='Computername';e={$comp}}, 
            @{n='UserName';e={$_.Name}}, 
            @{n='Memberof';e={$groups -join ';'}},
            @{n='status'; e={if($groups -like "*Administrators*"){$true} else{$false}}}
        }  
    } Else {Write-Warning "Server '$Comp' is Unreachable hence Could not fetch data"} 
} | Out-File -FilePath C:\users.txt

Answer 1

This should be an easier way of doing what you're looking for, Get-CimInstance and Get-CimAssociatedInstance have been around since PowerShell 3:

Get-Content C:\servers.txt | ForEach-Object {
    $computer = $_
    try {
        $query = Get-CimInstance Win32_UserAccount -Filter "Name='ADTuser'" -ComputerName $_ -ErrorAction Stop
        foreach($object in $query) {
            $membership = Get-CimAssociatedInstance -InputObject $object -ResultClassName Win32_Group -ComputerName $_

            [pscustomobject]@{
                Computername = $_
                UserName     = $object.Name
                Memberof     = $membership.Name -join ';'
                Status       = $membership.Name -contains 'Administrators'
            }
        }
    }
    catch {
        Write-Warning "Server '$computer' is Unreachable hence Could not fetch data"
    }
} | Export-Csv C:\users.csv -NoTypeInformation

If that doesn't work for you, your code would require a simple modification on your first filtering statement:

Where-Object { $_.SchemaClassName -eq 'user' -and $_.Name.Value -eq 'ADTuser' }

It's important to note that Test-Connection -ComputerName $_ -Count 1 -Quiet is not a relevant test for this script, this command is testing for ICMP response and adsi over WinNT requires RPC connectivity as well SMB.

Putting it all together with minor improvements the script would look like this:

Get-Content C:\servers.txt | ForEach-Object {
    if (-not (Test-Connection -ComputerName $_ -Count 1 -Quiet)) {
        Write-Warning "Server '$_' is Unreachable hence Could not fetch data"
        return
    }
    
    $computer = $_
    ([adsi]"WinNT://$_").Children.ForEach{ 
        if($_.SchemaClassName -ne 'user' -and $_.Name.Value -ne 'ADTuser') {
            return
        }
        
        $groups = $_.Groups().ForEach([adsi]).Name
        
        [pscustomobject]@{
            Computername = $computer
            UserName     = $_.Name.Value
            Memberof     = $groups -join ';'
            Status       = $groups -contains 'Administrators'
        }
    }
} | Export-Csv C:\users.csv -NoTypeInformation