how to pass parameters to Powershell script and run it on a remote computer

Question

I am trying to pass 2 parameters to a PS script which will patch the SQL Server on a remote machine. Here is the code i used :

$Patcher = "\\remoteShareLocation\SQLpatcher.ps1"
$ver = "SQL2012"
$inst = "NEWINST"

Invoke-Command -ComputerName RMTMACHINE -credential dmn\usrname -ScriptBlock {$Patcher $ver $inst}

This asks for credentials but doesn't run and show any output also. Anything wrong with syntax ? Any alternate cmdlet please ?

Loïc MICHEL · Accepted Answer · 2015-02-19 10:30:24Z

7

if you have powershell V3 or higher you can use the using prefix to "transmit" the local vars to remote host :

Invoke-Command -ComputerName RMTMACHINE -credential $cred -ScriptBlock {$using:Patcher $using:ver $using:inst}

for olders versions look at the -argumentlist parameter of invoke-command

answered Feb 19, 2015 at 10:30

Loïc MICHEL

26.3k10 gold badges79 silver badges111 bronze badges

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

1 Comment

wallybh Over a year ago

Just to complement: If $Patcher, $ver and $inst are commands then you have to put "&" before that. Ex.: Invoke-Command -ComputerName RMTMACHINE -credential $cred -ScriptBlock { & $using:Patcher $using:ver $using:inst}

Community · Accepted Answer · 2017-05-23 12:17:11Z

0

Try

$cred = Get-Credential
Invoke-Command -ComputerName RMTMACHINE -credential $cred -ScriptBlock {$Patcher $ver $inst}

or create a credential object like this:

$username = "username"
$password = "password" | ConvertTo-SecureString -asPlainText -Force
$cred = New-Object System.Management.Automation.PSCredential($username,$password)

You'll need to pass a credential object instead of Domain\username.

And to run a script file remotely please have a look at https://stackoverflow.com/a/10446318/4550393

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Feb 19, 2015 at 10:23

Norman

3,5193 gold badges28 silver badges45 bronze badges

1 Comment

user3180704 Over a year ago

Did not work with credentials also, so tried sending parameters : $ScriptBlockContent = { param ($p, $v, $i) powershell.exe -ExecutionPolicy Bypass $p $v $i } Invoke-Command -ComputerName RMTMACHINE -credential $cred -ScriptBlock $ScriptBlockContent -ArgumentList $Patcher, $ver, $inst. This also throws error saying : The term '\\remoteShareLocation\Patcher.ps1' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included,verify that the path is correct and try again.

Collectives™ on Stack Overflow

how to pass parameters to Powershell script and run it on a remote computer

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related