Adding new lines to Existing CSV using powershell?

Question

I wrote a script that would fetch all the services running under an account name. This part works fine except I want to add results to an existing csv. Add-content is messing up with my format. Please help as i am new here.

script:

$servers = @("a", "b")
$domain = "abc.com"

foreach($server in $servers){

$serverFQDN = $server+"."+"$domain"
    Invoke-Command -computername $serverFQDN{
        param($server)
        Write-host "On" + $server -ForegroundColor Yellow
        Get-WMIObject Win32_Service | Where-Object {$_.startname -match "ciqdev*" }
        # | where-object {$_.state -eq "running"}           
    }-argumentlist $server | select pscomputername,caption | export-Csv Z:\RT\myCSV.csv

}

Manu · Accepted Answer · 2017-04-27 13:11:35Z

3

Use -Append :

export-Csv Z:\RT\myCSV.csv -Append

answered Apr 27, 2017 at 13:11

Manu

1,74214 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Adding new lines to Existing CSV using powershell?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related