Error Powershell

Question

Post reply

Error Powershell

joujousagem2006 1602

SSCommitted

Points: 1779
More actions
July 28, 2018 at 10:53 am

#373922

Hello everyone
Who can help me is what exactly is wrong in my script
my goal is to launch the command exec xp_readerrorlog 0,1
Import-Module sqlps -DisableNameChecking $path='C:\localhost\serveur.txt' $serveurs=Get-Content -path $path $serveurs $serveurs |foreach { $query="exec xp_readerrorlog 0,1" invoke-sqlcmd -Query $query -ServerInstance $serveurs }
Here is the error

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

frederico_fonseca SSCoach Points: 16010 More actions · Answer 1

try
Import-Module sqlps -DisableNameChecking $path='C:\localhost\serveur.txt' $serveurs=Get-Content -path $path

$query="exec xp_readerrorlog 0,1"

foreach ($server in $serveurs) { invoke-sqlcmd -Query $query -ServerInstance $server }

joujousagem2006 1602 SSCommitted Points: 1779 More actions · Answer 2

thanks
it works properly
another question please how can I add the name of my server in my script
I want to load the server name in front of each line
Import-Module sqlps -DisableNameChecking $path='C:\localhost\serveur.txt' [Array]$serveurs=Get-Content -path $path $query="exec xp_readerrorlog 0 ,1" foreach($server in $serveurs){ invoke-sqlcmd -Query $query -ServerInstance $server -Database master }

frederico_fonseca SSCoach Points: 16010 More actions · Answer 3

This really should not be sent to standard output but rather redirected to a database or a file as volumes can be quite high.

Import-Module sqlps -DisableNameChecking $path='C:\localhost\serveur.txt' [Array]$serveurs=Get-Content -path $path $query="exec xp_readerrorlog 0 ,1" foreach($server in $serveurs) { $results=invoke-sqlcmd -Query $query -ServerInstance $server -Database master foreach($result in $results) { $result|Select-Object LogDate,ProcessInfo,Text|Select-Object -Property @{n="server";e={$server}},LogDate,ProcessInfo,Text } }