How to separate columns in Powershell when exported to CSV

Question

Pretty new in PowerShell scripting, just wanted to ask how to achieve separated columns for my query below. Since currently all columns returned by the query is placed under one column when exported to csv file.

$QueryPath="\\fbrwnutap05\c$\DBA\Extended Events SQL DM\UAT\SQLDM_ExtendedEvent_UAT.sql"
$OutputFile= "\\FBRWNUTAP05\c$\DBA\SSRS\ExtEvent\QueryOutput_UAT.csv"

$ExecuteQuery= Get-Content -path $QueryPath | out-string

$OutputFile

FOREACH($server in GC "\\fbrwnutap05\c$\DBA\SSRS\ExtEvent\ServerList.txt")
{

invoke-sqlcmd -ServerInstance $server -query $ExecuteQuery -querytimeout 60000 | ft -autosize | out-string -width 4096 >> $OutputFile 

}

Vivek Kumar Singh · Accepted Answer · 2018-03-29 10:09:37Z

2

Try this

invoke-sqlcmd -ServerInstance $server -query $ExecuteQuery -querytimeout 60000 | export-csv $OutputFile -NoTypeInformation -append

edited Mar 29, 2018 at 10:09

answered Jul 25, 2017 at 8:25

Vivek Kumar Singh

3,3601 gold badge19 silver badges30 bronze badges

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

1 Comment

user6811411 Over a year ago

When exporting to a csv the | ft -autosize is superfluous.

Collectives™ on Stack Overflow

How to separate columns in Powershell when exported to CSV

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related