Need help for eporting the report csv

Question

could you pls help to get, out put from the below script.

cls
$collection = import-csv "C:\test\Servercoll.txt"

foreach ($item in $collection)
{
Try
{
get-service -computername $item.Servername | where-object {$_.StartType -like "Automatic"} | ft Status,DisplayName,StartType,MAchinename
}
catch
{
Write-Output "Unable to connect to the Computer" $item.Servername
}

}

Answer 1

You can use the pipeline for this. Instead of intermixing a string into the "Success" data stream, which would make getting all of the results into a usable CSV, try something like this:

Import-Csv "C:\test\Servercoll.txt" |
    ForEach-Object {
        $sname = $_.Servername  # preserve name for any errors
        Try{
            Get-Service -computername $_.Servername -ErrorAction STOP | 
                Where-Object {$_.StartType -like "Automatic"} | 
                    Select-Object Status,DisplayName,StartType,Machinename
        }
        Catch{
            [PSCustomObject]@{
                Status = "Unable to connect to the Computer"    # maybe use "$_.Exception" instead of a fixed text
                DisplayName = ""
                StartType = ""
                Machinename = $sname
            }
        }
    } | Export-Csv -Path "C:\test\Services.csv" -NoTypeInformation

Answer 2

Hello,

Maybe this can help :

cls
$collection = import-csv "C:\test\Servercoll.txt"
$colObjServices = @()
foreach ($item in $collection)
{
Try
{
$objServices = get-service -computername $item.Servername | where-object {$_.StartType -like "Automatic"} | Select-Object Status,DisplayName,StartType,MAchinename
$colObjServices = $colObjServices + $objServices
}
catch
{
Write-Output "Unable to connect to the Computer" $item.Servername
}

}

$colObjServices | Export-Csv -Path "C:\test\Services.csv" -Delimiter ";" -NoTypeInformation