How to run a powershell command to all the servers as a report ?

rajasekar

Find more posts tagged with

PS1

sdk

report

Accepted answers

All comments

mrxinu

What would the command be and what would you expect the report to look like?

rajasekar

If I need to run below command in all the servers present in solarwinds.
Get-Service | Where-Object {$_.Status -eq "Running"}
And output I need to get for this command.
How I can execute and get the output??

mrxinu

Assuming you have a Windows account with administrative access to those systems I would use the SolarWinds SDK to get the list of servers from SolarWinds and then loop through them, executing the command you mentioned, and writing the results to either a single file or multiple files.

It would look like this:

Import-Module SwisPowerShell

$swis = Connect-Swis -Hostname example.com -Trusted

$nodes = Get-SwisData -SwisConnection $swis -Query "SELECT Caption FROM Nodes"

foreach ($node in $nodes) {
    # execute your command and store your results here
}