(Excel) SSH Parallel Remote Commands on Single Server

Shows how to execute multiple commands in parallel on a single SSH server and retrieve the command output for each.

Note: This example requires Chilkat v9.5.0.65 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes Chilkat SSH/SFTP to have been previously unlocked.
' See Unlock SSH for sample code.

Dim ssh As Chilkat.Ssh
Set ssh = Chilkat.NewSsh


port = 22

success = ssh.Connect("the-ssh-server.com",port)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Authenticate using login/password:
success = ssh.AuthenticatePw("theSshLogin","theSshPassword")
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Start several commands on the server.

channel1 = ssh.QuickCmdSend("df")
If (channel1 < 0) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If


channel2 = ssh.QuickCmdSend("date")
If (channel2 < 0) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If


channel3 = ssh.QuickCmdSend("echo hello world")
If (channel3 < 0) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Now collect the results of each command.

pollTimeoutMs = 50

numFinished = 0
Do While numFinished < 3
    ' Check to see if anything has finished.
    ' QuickCmdCheck returns -1 if there are no errors and nothing else finished
    ' QuickCmdCheck returns -2 if there was an error (such as a lost connection)
    ' QuickCmdCheck returns a channel number if a channel finished.

    channel = ssh.QuickCmdCheck(pollTimeoutMs)
    If (channel = -2) Then
        Debug.Print ssh.LastErrorText
        Exit Sub
    End If

    If (channel >= 0) Then
        Debug.Print "---- channel "; channel; " finished ----"
        Debug.Print ssh.GetReceivedText(channel,"ansi")
        numFinished = numFinished + 1
    End If

Loop

' --------------
' Sample output:

' 	---- channel 105 finished ----
' 	hello world
' 
' 	---- channel 104 finished ----
' 	Thu Dec 22 17:43:58 CST 2016
' 
' 	---- channel 103 finished ----
' 	Filesystem    512-blocks      Used  Available Capacity  iused     ifree %iused  Mounted on
' 	/dev/disk2    2176716032 265739728 1910464304    13% 33281464 238808038   12%   /
' 	devfs                382       382          0   100%      662         0  100%   /dev
' 	map -hosts             0         0          0   100%        0         0  100%   /net
' 	map auto_home          0         0          0   100%        0         0  100%   /home
' 	/dev/disk3s2      374668    374668          0   100%    93665         0  100%   /Volumes/Google Chrome