Formatting the results of a powershell script

Question

How can i add the server name at the left of each line result on this script?. Thank you!

$servers = Get-Content -path .\Machines.txt
[pscustomobject]$result = @()  
$subresult =
ForEach ($server in $servers) 
{
Set-Service -computername $servers -Name sacsvr -StartupType Disabled -PassThru
}
$result = $subresult 
$result | Out-File local_group_members.csv

This is an example result:

Status   Name               DisplayName                           
------   ----               -----------                           
Stopped  sacsvr             Special Administration Console Helper 
Stopped  sacsvr             Special Administration Console Helper 
Stopped  sacsvr             Special Administration Console Helper

TheMadTechnician · Accepted Answer · 2014-12-10 02:55:30Z

2

Alternatively you can just add a property to the objects you're outputting right now. Pipe your Set-Service to Add-Member like this:

Set-Service -computername $servers -Name sacsvr -StartupType Disabled -PassThru | Add-Member -MemberType NoteProperty -Name 'Server' -Value $Server -PassThru

Now each object that you pass to $subresult has a new property Server that is the name of the server it was run on. You'll probably want to pipe through Select when outputting to have the order you want.

$SubResult | Select Server, Status, Name, DisplayName | Export-CSV 'local_group_members.csv' -NoType

answered Dec 10, 2014 at 2:55

TheMadTechnician

36.5k3 gold badges48 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Crit Scratch Over a year ago

Thank you for your answer, its is very helpful. Another question, how can i add something to check if the server is up (like Test-Connection) and put the result also in the Export-CVS of this script?.

TheMadTechnician Over a year ago

That is a little more complicated, and better suited for it's own separate question. You would need to check if the server is up, and then either run Set-Service, and add a member to say that the server is up, or output that the server is down because if it's down running set-service is going to fail.

Anthony Neace · Accepted Answer · 2014-12-09 22:56:57Z

1

You can arbitrarily re-order or add to your output with Select-Object. You can use hash tables to include calculated properties such as your desired ServerName.

So for each server, you can set the services and tag the output with that server name:

ForEach ($server in $servers) 
{
    Set-Service -computername $server -Name sacsvr -StartupType Disabled -PassThru |
    Select @{Name = 'ServerName'; Expression = {$server}}, Name, DisplayName, Status
}

The above is shorthand for:

Select-Object -Property (properties)

The -Property parameter allows you to select any arbitrary grouping of properties on the type of object being piped in. Another parameter, -InputObject allows us to pipe in objects by value.

edited Dec 9, 2014 at 22:56

answered Dec 9, 2014 at 22:27

Anthony Neace

26.2k8 gold badges118 silver badges132 bronze badges

Collectives™ on Stack Overflow

Formatting the results of a powershell script

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related