Sort column order

Hello!

I've a script that reads service state using WMI, before that, the script tests if the destination workstation is alive with Test-Connection. When it fails it return it's offline in a proper way to export to csv later.

#Get credential
$cre1 = Get-Credential "Enter Credential"
$hostname = Read-Host "Enter Machine name"
    #ICMP test 4 packets
    If(Test-Connection -ComputerName $hostname -count 4 -Quiet ){
        #Read service state
        Get-WmiObject -Class Win32_Service -Filter "name='service1' or name='service2'" -ComputerName $hostname -Credential $cre1
        Select Name, State, SystemName | Sort SystemName,name | Format-Table -AutoSize
    }
    #If ICMP fails
    Else{New-Object PSObject -Property @{Name="N/A";State="OFFLINE";SystemName=$hostname}
    }

The thing is, when it fails it's returning the columns in the wrong order (Name,State,SystemName): Name, SystemName, State.

How can I fix it?

EDITED:

When I do this inside a foreach and the select is outside the loop, at the end I export it to csv and it works just fine. The problem is only when I show it on the screen.


  • Edited by H Souza Friday, August 21, 2015 4:50 AM
August 21st, 2015 3:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics