Hello,
I'm trying to execute remote commands using powershell and trying to load the commands output to the database. I'm able to load the data to database successffully but the data is loading as a paragraph format which is not readable. Could someone suggest
any solution for this ?
Sample Code:
$output = invoke-command -session $session -ScriptBlock {
echo '<------starting batch------->'
cd 'C:\temp\'
cmd /c 'dir'
cmd /c 'hostname'
echo '<------ending batch------>'
}
$formatted_output = ($output | Out-String) -replace "(.`r`n)", "`$1`r`n"
write-host $formatted_output
Sample Variable Output:
<------starting batch------->
Volume in drive C has no label.
Volume Serial Number is 0CE1-E926
Directory of C:\temp
06/26/2017 03:17 PM <DIR> .
06/26/2017 03:17 PM <DIR> ..
08/10/2016 09:07 PM <DIR> Clt-Inst
06/07/2016 04:31 PM 56,406,016 splunkforwarder-6.4.1-debde650d26e-x64-release.msi
06/26/2017 02:44 PM 35,922,892 Windows6.0-KB968930-x64.msu
2 File(s) 92,328,908 bytes
3 Dir(s) 418,918,834,176 bytes free
<servername>
<------ending batch------>
Code used to insert/update the sqlserver table:
$connString = "Server="+$server+";Database="+$db+";Integrated Security=sspi"
$sqlConnect = New-Object System.Data.SqlClient.SqlConnection $connString
$sqlConnect.Open()
$sqlcmd = "Update table01 set log ='"+$formatted_output+"' where server=servername"
$sqlCommand = $sqlConnect.CreateCommand()
$sqlCommand.CommandText = $sqlcmd
$sqlCommand.ExecuteNonQuery()
$sqlConnect.Close()
But when i try to insert this variable data to sql server it is saving the data as paragraph format. I would like to retain the carriage returns when inserted to the database. Could someone guide me achieving this?
thank you.
