Powershell & nice formatting of the output file

Question

I wrote a small powershell script that reads name of sql server instances from text-file then loops them and output results of the query to the text file.

foreach ($Instance in Get-Content C:\temp\SQLServers.txt)
{
$Instance;
$File ="c:\temp\SqlLoopLog.txt"
Add-Content $File "`r`n$Instance"
Invoke-Sqlcmd -ServerInstance $Instance -Database msdb -Query "select * from dbo.[sysjobs]" | Out-File $File 
}

But when called Invoke-Sqlcmd the content of the file SqlLoopLog.txt is re-set each time. But if I add -append then the information is output in one row instead of the several rows and it is un-readable. How to output data in readable format?

Loïc MICHEL · Answer 1 · 2013-02-14T17:32:05.823

0

can you try :

$output=(Invoke-Sqlcmd -ServerInstance $Instance -Database msdb -Query "select * from dbo.[sysjobs]").tostring()
$output+="`n"
$output | out-file -append $file

edited Feb 14 '13 at 17:32

answered Feb 14 '13 at 12:46

Loïc MICHEL

24,935
9
74
103

I've got error: Method invocation failed because [System.Data.DataRow] doesn't contain a method named 'op_Addition'. – Helen Dyakonova Feb 14 '13 at 16:27
I just done some changes in the code snippet. Can you try the current one – RinoTom Feb 14 '13 at 18:49

Powershell & nice formatting of the output file

1 Answers1