Hello,

I have an script that collects the service status for machines in a list and writes the output to a csv file:

$file= "C:\temp\wk.txt"
$cre= Get-Credential "ENTER YOUR CREDENTIAL"
Get-Content $file |
ForEach-Object {
    #ICMP test 4 packets
    If(Test-Connection -ComputerName $_ -count 1 -Quiet ){
        #Read service state
        Get-WmiObject -Class Win32_Service -Filter "name='service1' or name='service2'" -ComputerName $_ -Credential $cre -ErrorAction SilentlyContinue
    }
    #If ICMP fails
    Else{New-Object PSObject -Property @{Name="N/A";State="OFFLINE";SystemName=$_}
    } 
} | Select Name,State,SystemName | Sort SystemName,Name | Export-Csv "C:\temp\wk_service_result_new.csv" -NoTypeInformation

The problem is that the script write to the file only when it goes through all machines and the list have more than 2000 machines so it takes too long to finish and if somehow my computer crash or even the script process and end-up with no result.

Is there any method I can use to make the script the result right right after it finishes on a machine instead waiting it to finish with all of them?

Thanks in advance.

Turns out the problem was the Sort instruction I've placed between the Select and the Export-CSV.

I deleted that and it started working just nice.

Thanks anyway.

• Marked as answer by H Souza 22 hours 45 minutes ago

Turns out the problem was the Sort instruction I've placed between the Select and the Export-CSV.

I deleted that and it started working just nice.

Thanks anyway.

• Marked as answer by H Souza Friday, September 04, 2015 8:27 AM

Turns out the problem was the Sort instruction I've placed between the Select and the Export-CSV.

I deleted that and it started working just nice.

Thanks anyway.

• Marked as answer by H Souza Friday, September 04, 2015 8:27 AM