powershell-3.0remote-serverinvoke-commandscriptblock

How to pass local variable to Invoke-Command's -ScriptBlock


I am trying to execute following PowerShell script from Server-2 against Server-1 (i.e. Remote server):

$DBServer = 'Server1' 

Invoke-Command -ComputerName $DBServer -ScriptBlock {
$status = Start-Process "C:\Program Files\iQ4bis\HaloSource\HaloSource.Run.exe" '"D:\Test\UsageTracking.iqp" /wf "Default Workflow" /e "Dev" ' -Wait -PassThru
$test2 = $status.ExitCode
if ($test2 -ne 0) 
{ 
    Throw "The command exited with error code: $test2"
}
else
{
    Write-host "Workflow executed successfully."    
}
}

Question: Code part

"C:\Program Files\iQ4bis\HaloSource\HaloSource.Run.exe" '"D:\Test\UsageTracking.iqp" /wf "Default Workflow" /e "Dev" ' -Wait -PassThru

I wanted to make it parameterized, as values for D:\Test\UsageTracking.iqp and Dev is going to change per project. How can I pass in new values using parameter? This is the how I wanted it if possible:

clear-host

$DBServer = 'Server1'
$v1 = 'D:\Test\UsageTracking.iqp'
$v2 = 'Dev'
$v3 = "C:\Program Files\iQ4bis\HaloSource\HaloSource.Run.exe"

Invoke-Command -ComputerName $DBServer -ScriptBlock {
param(
[string] $IQPFileDestinationLocation = $v1, [string] $ExecutionEnvironment = $v2, [string] $exe = $v3
)

$IQPFileLocation = $IQPFileDestinationLocation
$workflow = "Default Workflow"
$environment = $ExecutionEnvironment
$test = """$exe"" '""$IQPFileLocation"" /wf ""$workflow"" /e ""$environment""'"
$test

$status = Start-Process $test -Wait -PassThru

$test2 = $status.ExitCode
if ($test2 -ne 0) 
{ 
    Throw "The command exited with error code: $test2"
}
else
{
    Write-host "It went ok."    
}

} -ArgumentList $v1 ,$v2 ,$v3

When I run above, I get following error message:

    This command cannot be run due to the error: The system cannot find the file specified.
    + CategoryInfo          : InvalidOperation: (:) [Start-Process], InvalidOperationException
    + FullyQualifiedErrorId : InvalidOperationException,Microsoft.PowerShell.Commands.StartProcessCommand
    + PSComputerName        : ken-dev-bi001

The command exited with error code: 
At line:8 char:1
+ Invoke-Command -ComputerName $DBServer -ScriptBlock {
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (The command exited with error code: :String) [], RuntimeException
    + FullyQualifiedErrorId : The command exited with error code: 

any help would be appriciated to get it working.


Solution

  • All,
    So, finally I figured it out how to pass local variable to -ScriptBlock while using with the Invoke-Commandagainst the remote server.

    Here is the code I used and it worked like a charm:

    Write-Host "Workflow command was: "$HaloSourceCommandLine
    
    Invoke-Command -ComputerName $DBServer -ScriptBlock {
    param ([string] $t1 = $HaloSourceCommandLine, [string] $t2 = $HaloSourceExecutableLocation)
    
        $status = Start-Process $t2 $t1 -Wait -PassThru
        $ExitCodeInfo = $status.ExitCode
            if ($ExitCodeInfo -ne 0) 
            { 
                Throw "The command exited with error code: $test2"
            }
            else
            {
                Write-host "Workflow executed successfully."    
            }
    } -ArgumentList $HaloSourceCommandLine,$HaloSourceExecutableLocation
    

    Hopefully this will help to others if they are having issue executing -ScriptBlock against remote server via Invoke-Command

    Thanks, HP