Need help with powershell

chipperchoi · 2021-04-28T17:33:58.000Z

Hey all,

I am trying to piece together a simple script to run against a list of servers to pull the services running on it and the account that is running it.
This only seems to pull from the local machine that is actually running the script. I am sure I’m missing something obvious here but can’t seem to see it myself


```
$computers = Get-Content -Path C:\temp\Serverlist.txt
foreach($computer in $computers)
{Get-WmiObject win32_service | Where-Object {$_.state -eq "running"} | Select-Object systemname,name,startname,state | Export-Csv c:\temp\ServerServicesLogonAs.csv -NoTypeInformation}

```

Neally · 2021-04-28T17:36:33.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

gary-m-g · 2021-04-28T17:39:15.000Z

In your loop, your only asking for local computer info; you need:

gwmi -ComputerName $computer …

chipperchoi · 2021-04-28T17:40:20.000Z

Sorry about that. Updated the post

chipperchoi · 2021-04-28T17:47:58.000Z

Gary M G:

In your loop, your only asking for local computer info; you need:

gwmi -ComputerName $computer …

OMG, I am such an idiot…wow I can’t believe I didn’t see that.

Thank you very much. I need more sleep…

Neally · 2021-04-28T17:48:06.000Z

Gary M G:

In your loop, your only asking for local computer info; you need:

gwmi -ComputerName $computer …

That and you need to append the CSV, as it is right now it would overwrite it. Or even better write it to a variable and then export the whole thing.

e.g.

or if you want it individually

$computers = Get-Content "C:\temp\Serverlist.txt"
foreach($computer in $computers){\
    Get-WmiObject win32_service -ComputerName $computer | 
    Where-Object {$_.state -eq "running"} | 
    Select-Object systemname,name,startname,state | 
    Export-Csv "c:\temp\ServerServicesLogonAs_$computer.csv" -NoTypeInformation
}

$computers = Get-Content -Path "C:\temp\Serverlist.txt"

$report = 
foreach($computer in $computers){
    Get-WmiObject win32_service -ComputerName $computer | 
    Where-Object {$_.state -eq "running"} | 
    Select-Object systemname,name,startname,state 
}

$report | export-csv "c:\temp\ServerServicesLogonAs.csv" -NoTypeInformation

chipperchoi · 2021-04-28T17:58:36.000Z

Thank you Neally!