trying to write a PowerShell script to use a list of servers to gather user profiles and bring back to local server running the script

Question

I am trying to write a PowerShell script to use a list of servers to gather user profiles and bring the list of users back to the local server running the script. I am not very good at this and am hoping someone can assist me, please. The below is what I have so far however it throws a "missing for each statement" error when I try to run it.

$computers = Get-Content "C:\scripts\Servers1.txt" 
$hostname = get-content $computers
$sPath = "$hostname + .csv"
foreach ($computer in {
    gwmi win32_userprofile | select localpath, sid
    Get-Alias gwmi, select, ft
    write-host $sPath
#Export-Csv -Path $sPath -NoTypeInformation

} )
robocopy $sPath '\\powerserver\C$\Temp\ServerUsers'

Answer 1

Your script has multiple problems. Download this PDF and use it as a reference.

https://www.sapien.com/books_training/Windows-PowerShell-4

Try this.

$computers = Get-Content "C:\scripts\Servers1.txt"
$Report = @()              
foreach ($computer in $computers) {
    "Processing $computer"
    Get-CimInstance -ComputerName $computer win32_userprofile | select localpath, sid | foreach {
        $Report +=  [PSCustomObject]@{
            Computer = $computer;
            LocalPath = $_.localpath;
            SID = $_.sid
        }
    }
}
"Here is the report."
$Report 

$Report | Export-Csv -Path '\\powerserver\C$\Temp\ServerUsers\Report.csv' -NoTypeInformation

Answer 2

Here's another version of your script that doesn't report the profiles like these:

• C:\WINDOWS\ServiceProfiles\NetworkService
• C:\WINDOWS\ServiceProfiles\LocalService
• C:\WINDOWS\system32\config\systemprofile

Get-CimInstance -ComputerName (Get-Content "C:\scripts\Servers1.txt") win32_userprofile |
    ForEach-Object {
        if ($_.localpath -like "?:\users\*"){
            [PSCustomObject]@{
                Computer = $_.PSComputerName
                LocalPath = $_.localpath
                SID = $_.sid
            }
        }
    } | Export-Csv -Path '\\powerserver\C$\Temp\ServerUsers\Report.csv' -NoTypeInformation