(Excel) SSH Parallel Remote Commands on Multiple Servers

Shows how to execute a command in parallel on multiple servers.

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.

' Executing a command on multiple servers simultaneously is straightforward.
' It's just a matter of using one SSH object per server..
Dim ssh1 As Chilkat.Ssh
Set ssh1 = Chilkat.NewSsh
Dim ssh2 As Chilkat.Ssh
Set ssh2 = Chilkat.NewSsh
Dim ssh3 As Chilkat.Ssh
Set ssh3 = Chilkat.NewSsh


port = 22

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

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

' Connect and authenticate with 2 more servers.
' For brevity, the success/failure won't be checked...
success = ssh2.Connect("ssh-server2.com",port)
success = ssh2.AuthenticatePw("sshLogin2","sshPassword2")
success = ssh3.Connect("ssh-server3.com",port)
success = ssh3.AuthenticatePw("sshLogin3","sshPassword3")

' Note: If we wanted, we could've used ConnectAsync and AuthenticatePwAsync
' to do the connecting and authenticating in parallel...

' The command to be run on each SSH server will sleep for 5 seconds,
' and then show the current system date/time.

cmd = "sleep 5; date"

' Start each command

ssh1Channel = ssh1.QuickCmdSend(cmd)
If (ssh1Channel < 0) Then
    Debug.Print ssh1.LastErrorText
    Exit Sub
End If

' For brevity, we're not checking the return values here:

ssh2Channel = ssh2.QuickCmdSend(cmd)

ssh3Channel = ssh3.QuickCmdSend(cmd)

' OK, at this point the command is running simultaneously on each server.

' Now collect the results of each command.

pollTimeoutMs = 50

numFinished = 0

' Note: You would rewrite this code to use arrays.

ssh1Finished = False

ssh2Finished = False

ssh3Finished = False
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.
    If (ssh1Finished <> True) Then
        channel = ssh1.QuickCmdCheck(pollTimeoutMs)
        If (channel = -2) Then
            Debug.Print ssh1.LastErrorText
            Exit Sub
        End If

        If (channel = ssh1Channel) Then
            Debug.Print "---- ssh1 channel "; channel; " finished ----"
            Debug.Print ssh1.GetReceivedText(channel,"ansi")
            numFinished = numFinished + 1
            ssh1Finished = True
        End If

    End If

    If (ssh2Finished <> True) Then
        channel = ssh2.QuickCmdCheck(pollTimeoutMs)
        If (channel = -2) Then
            Debug.Print ssh2.LastErrorText
            Exit Sub
        End If

        If (channel = ssh2Channel) Then
            Debug.Print "---- ssh2 channel "; channel; " finished ----"
            Debug.Print ssh2.GetReceivedText(channel,"ansi")
            numFinished = numFinished + 1
            ssh2Finished = True
        End If

    End If

    If (ssh3Finished <> True) Then
        channel = ssh3.QuickCmdCheck(pollTimeoutMs)
        If (channel = -2) Then
            Debug.Print ssh3.LastErrorText
            Exit Sub
        End If

        If (channel = ssh3Channel) Then
            Debug.Print "---- ssh3 channel "; channel; " finished ----"
            Debug.Print ssh3.GetReceivedText(channel,"ansi")
            numFinished = numFinished + 1
            ssh3Finished = True
        End If

    End If

Loop

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

' 	---- ssh2 channel 101 finished ----
' 	Fri Dec 23 00:25:48 UTC 2016
' 
' 	---- ssh3 channel 102 finished ----
' 	Thu Dec 22 18:25:12 CST 2016
' 
' 	---- ssh1 channel 100 finished ----
' 	Thu Dec 22 18:25:48 CST 2016