Hello,
(Please ignore the typos)
My requirement is that I need to install and configure one software on multiple servers more than 500 servers. I have powershell script which needs 5 parameters to install it on one machine.
To run this on multiple remote server I am creating one more script to iterate through and using something like below -
Foreach ($server in $serverlist)
{
$s= new-pssession $server
Invoke-command -session $s -scriptblock { param ( $arg1, $arg2, $arg3, $arg4)
Start-job -scriptblock {param ( $arg1, $arg2, $arg3, $arg4)
— do some stuff here
$mycmd = invoke-sqlcmd -query “exec master…xp_cmdshell 'cd c:\mydir & c:\windows\system32\windowspowershell\v1.0\powershell.exe .\myscript.ps1 "$arg1” "$arg2" "$arg3" “"$arg4”'" -Serverinstance $server -Darabase “master”
— do some stuff here
} -ArgumentList $arg1, $arg2, $arg3, $arg3
} -ArgumentList $arg1, $arg2, $arg3, $arg3
}
Note:
-
Installation of software can be done by any account but configuration must happen using SQL server service account hence I am using here invoke- sqlcmd
-
Problem is i am not able to run this and it’s not working .
-
Also, How can I track and perform looging of each command and variable?
Currently I am using below for logging after every important command inside the loop.
Creating log file with timestamp on host server from where I am running script. Then
$file= -join("Microsoft.Powershell.core.filesystem::, $myhost, "", “C$\mydir\abc.log”)
$Message = “Some message”
$Message | Out-File -Filepath $file -Appen
Any help here is much appreciated.