Pinging Workstations

[Jbajin]

I have about 600 workstations that I need to make sure are one during code drops. I want to be able to Ping the machine just once using it's computer name and if it doesn't respond list it in a list box. I currently have a listbox that contains the workstations names. Does anyone seen or know how to do such a thing???

Thanks,

Joseph

'1) Place a command button on the form and place this code in the Click event
   Dim ECHO As ICMP_ECHO_REPLY
   Dim pos As Integer

  'ping an ip address, passing the
  'address and the ECHO structure
   Call Ping("209.48.177.35", ECHO)

  'display the results from the ECHO structure
   Form1.Print GetStatusCode(ECHO.status)
   Form1.Print ECHO.Address
   Form1.Print ECHO.RoundTripTime & " ms"
   Form1.Print ECHO.DataSize & " bytes"

   If Left$(ECHO.Data, 1) <> Chr$(0) Then
      pos = InStr(ECHO.Data, Chr$(0))
      Form1.Print Left$(ECHO.Data, pos - 1)
   End If

   Form1.Print ECHO.DataPointer

'2) Add a .BAS module and paste this code in that module
'3) Click the command button
Option Explicit

Public Const IP_STATUS_BASE =  1100 0
Public Const IP_SUCCESS = 0
Public Const IP_BUF_TOO_SMALL = ( 1100 0 + 1)
Public Const IP_DEST_NET_UNREACHABLE = ( 1100 0 + 2)
Public Const IP_DEST_HOST_UNREACHABLE = ( 1100 0 + 3)
Public Const IP_DEST_PROT_UNREACHABLE = ( 1100 0 + 4)
Public Const IP_DEST_PORT_UNREACHABLE = ( 1100 0 + 5)
Public Const IP_NO_RESOURCES = ( 1100 0 + 6)
Public Const IP_BAD_OPTION = ( 1100 0 + 7)
Public Const IP_HW_ERROR = ( 1100 0 + 8)
Public Const IP_PACKET_TOO_BIG = ( 1100 0 + 9)
Public Const IP_REQ_TIMED_OUT = ( 1100 0 + 10)
Public Const IP_BAD_REQ = ( 1100 0 + 11)
Public Const IP_BAD_ROUTE = ( 1100 0 + 12)
Public Const IP_TTL_EXPIRED_TRANSIT = ( 1100 0 + 13)
Public Const IP_TTL_EXPIRED_REASSEM = ( 1100 0 + 14)
Public Const IP_PARAM_PROBLEM = ( 1100 0 + 15)
Public Const IP_SOURCE_QUENCH = ( 1100 0 + 16)
Public Const IP_OPTION_TOO_BIG = ( 1100 0 + 17)
Public Const IP_BAD_DESTINATION = ( 1100 0 + 18)
Public Const IP_ADDR_DELETED = ( 1100 0 + 19)
Public Const IP_SPEC_MTU_CHANGE = ( 1100 0 + 20)
Public Const IP_MTU_CHANGE = ( 1100 0 + 21)
Public Const IP_UNLOAD = ( 1100 0 + 22)
Public Const IP_ADDR_ADDED = ( 1100 0 + 23)
Public Const IP_GENERAL_FAILURE = ( 1100 0 + 50)
Public Const MAX_IP_STATUS =  1100 0 + 50
Public Const IP_PENDING = ( 1100 0 + 255)
Public Const PING_TIMEOUT = 200
Public Const WS_VERSION_REQD = &H101
Public Const WS_VERSION_MAJOR = WS_VERSION_REQD \ & H100  And &HFF&
Public Const WS_VERSION_MINOR = WS_VERSION_REQD And &HFF&
Public Const MIN_SOCKETS_REQD = 1
Public Const SOCKET_ERROR = -1

Public Const MAX_WSADescription = 256
Public Const MAX_WSASYSStatus = 128

Public Type ICMP_OPTIONS
    Ttl             As Byte
    Tos             As Byte
    Flags           As Byte
    OptionsSize     As Byte
    OptionsData     As Long
End Type

Dim ICMPOPT As ICMP_OPTIONS

Public Type ICMP_ECHO_REPLY
    Address         As Long
    status          As Long
    RoundTripTime   As Long
    DataSize        As Integer
    Reserved        As Integer
    DataPointer     As Long
    Options         As ICMP_OPTIONS
    Data            As String * 250
End Type

Public Type HOSTENT
    hName As Long
    hAliases As Long
    hAddrType As Integer
    hLen As Integer
    hAddrList As Long
End Type

Public Type WSADATA
    wVersion As Integer
    wHighVersion As Integer
    szDescription(0 To MAX_WSADescription) As Byte
    szSystemStatus(0 To MAX_WSASYSStatus) As Byte
    wMaxSockets As Integer
    wMaxUDPDG As Integer
    dwVendorInfo As Long
End Type


Public Declare Function IcmpCreateFile Lib "icmp.dll" () As Long

Public Declare Function IcmpCloseHandle Lib "icmp.dll" _
   (ByVal IcmpHandle As Long) As Long

Public Declare Function IcmpSendEcho Lib "icmp.dll" _
   (ByVal IcmpHandle As Long, _
    ByVal DestinationAddress As Long, _
    ByVal RequestData As String, _
    ByVal RequestSize As Integer, _
    ByVal RequestOptions As Long, _
    ReplyBuffer As ICMP_ECHO_REPLY, _
    ByVal ReplySize As Long, _
    ByVal Timeout As Long) As Long

Public Declare Function WSAGetLastError Lib "WSOCK32.DLL" () As Long

Public Declare Function WSAStartup Lib "WSOCK32.DLL" _
   (ByVal wVersionRequired As Long, _
    lpWSADATA As WSADATA) As Long

Public Declare Function WSACleanup Lib "WSOCK32.DLL" () As Long

Public Declare Function gethostname Lib "WSOCK32.DLL" _
   (ByVal szHost As String, _
    ByVal dwHostLen As Long) As Long

Public Declare Function gethostbyname Lib "WSOCK32.DLL" _
   (ByVal szHost As String) As Long

Public Declare Sub RtlMoveMemory Lib "kernel32" _
   (hpvDest As Any, _
    ByVal hpvSource As Long, _
    ByVal cbCopy As Long)


Public Function GetStatusCode(status As Long) As String

   Dim msg As String

   Select Case status
      Case IP_SUCCESS:               msg = "ip success"
      Case IP_BUF_TOO_SMALL:         msg = "ip buf too_small"
      Case IP_DEST_NET_UNREACHABLE:  msg = "ip dest net unreachable"
      Case IP_DEST_HOST_UNREACHABLE: msg = "ip dest host unreachable"
      Case IP_DEST_PROT_UNREACHABLE: msg = "ip dest prot unreachable"
      Case IP_DEST_PORT_UNREACHABLE: msg = "ip dest port unreachable"
      Case IP_NO_RESOURCES:          msg = "ip no resources"
      Case IP_BAD_OPTION:            msg = "ip bad option"
      Case IP_HW_ERROR:              msg = "ip hw_error"
      Case IP_PACKET_TOO_BIG:        msg = "ip packet too_big"
      Case IP_REQ_TIMED_OUT:         msg = "ip req timed out"
      Case IP_BAD_REQ:               msg = "ip bad req"
      Case IP_BAD_ROUTE:             msg = "ip bad route"
      Case IP_TTL_EXPIRED_TRANSIT:   msg = "ip ttl expired transit"
      Case IP_TTL_EXPIRED_REASSEM:   msg = "ip ttl expired reassem"
      Case IP_PARAM_PROBLEM:         msg = "ip param_problem"
      Case IP_SOURCE_QUENCH:         msg = "ip source quench"
      Case IP_OPTION_TOO_BIG:        msg = "ip option too_big"
      Case IP_BAD_DESTINATION:       msg = "ip bad destination"
      Case IP_ADDR_DELETED:          msg = "ip addr deleted"
      Case IP_SPEC_MTU_CHANGE:       msg = "ip spec mtu change"
      Case IP_MTU_CHANGE:            msg = "ip mtu_change"
      Case IP_UNLOAD:                msg = "ip unload"
      Case IP_ADDR_ADDED:            msg = "ip addr added"
      Case IP_GENERAL_FAILURE:       msg = "ip general failure"
      Case IP_PENDING:               msg = "ip pending"
      Case PING_TIMEOUT:             msg = "ping timeout"
      Case Else:                     msg = "unknown  msg returned"
   End Select

   GetStatusCode = CStr(status) & "   [ " & msg & " ]"

End Function


Public Function HiByte(ByVal wParam As Integer)

    HiByte = wParam \ & H100  And &HFF&

End Function


Public Function LoByte(ByVal wParam As Integer)

    LoByte = wParam And &HFF&

End Function


Public Function Ping(szAddress As String, ECHO As ICMP_ECHO_REPLY) As Long

   Dim hPort As Long
   Dim dwAddress As Long
   Dim sDataToSend As String
   Dim iOpt As Long

   sDataToSend = "Echo This"
   dwAddress = AddressStringToLong(szAddress)

   Call SocketsInitialize
   hPort = IcmpCreateFile()

   If IcmpSendEcho(hPort, _
                   dwAddress, _
                   sDataToSend, _
                   Len(sDataToSend), _
                   0, _
                   ECHO, _
                   Len(ECHO), _
                   PING_TIMEOUT) Then

        'the ping succeeded,
        '.Status will be 0
        '.RoundTripTime is the time in ms for
        '               the ping to complete,
        '.Data is the data returned (NULL terminated)
        '.Address is the Ip address that actually replied
        '.DataSize is the size of the string in .Data
         Ping = ECHO.RoundTripTime
   Else: Ping = ECHO.status * -1
   End If

   Call IcmpCloseHandle(hPort)
   Call SocketsCleanup

End Function


Function AddressStringToLong(ByVal tmp As String) As Long

   Dim i As Integer
   Dim parts(1 To 4) As String

   i = 0

  'we have to extract each part of the
  '123.456.789.123 string, delimited by
  'a period
   While InStr(tmp, ".") > 0
      i = i + 1
      parts(i) = Mid(tmp, 1, InStr(tmp, ".") - 1)
      tmp = Mid(tmp, InStr(tmp, ".") + 1)
   Wend

   i = i + 1
   parts(i) = tmp

   If i <> 4 Then
      AddressStringToLong = 0
      Exit Function
   End If

  'build the long value out of the
  'hex of the extracted strings
   AddressStringToLong = Val("&H" & Right("00" & Hex(parts(4)), 2) & _
                         Right("00" & Hex(parts(3)), 2) & _
                         Right("00" & Hex(parts(2)), 2) & _
                         Right("00" & Hex(parts(1)), 2))

End Function


Public Function SocketsCleanup() As Boolean

    Dim X As Long

    X = WSACleanup()

    If X <> 0 Then
        MsgBox "Windows Sockets error " & Trim$(Str$(X)) & _
               " occurred in Cleanup.", vbExclamation
        SocketsCleanup = False
    Else
        SocketsCleanup = True
    End If

End Function


Public Function SocketsInitialize() As Boolean

    Dim WSAD As WSADATA
    Dim X As Integer
    Dim szLoByte As String, szHiByte As String, szBuf As String

    X = WSAStartup(WS_VERSION_REQD, WSAD)

    If X <> 0 Then
        MsgBox "Windows Sockets for 32 bit Windows " & _
               "environments is not successfully responding."
        SocketsInitialize = False
        Exit Function
    End If

    If LoByte(WSAD.wVersion) < WS_VERSION_MAJOR Or _
       (LoByte(WSAD.wVersion) = WS_VERSION_MAJOR And _
        HiByte(WSAD.wVersion) < WS_VERSION_MINOR) Then

        szHiByte = Trim$(Str$(HiByte(WSAD.wVersion)))
        szLoByte = Trim$(Str$(LoByte(WSAD.wVersion)))
        szBuf = "Windows Sockets Version " & szLoByte & "." & szHiByte
        szBuf = szBuf & " is not supported by Windows " & _
                          "Sockets for 32 bit Windows environments."
        MsgBox szBuf, vbExclamation
        SocketsInitialize = False
        Exit Function

    End If

    If WSAD.wMaxSockets < MIN_SOCKETS_REQD Then
        szBuf = "This application requires a minimum of " & _
                 Trim$(Str$(MIN_SOCKETS_REQD)) & " supported sockets."
        MsgBox szBuf, vbExclamation
        SocketsInitialize = False
        Exit Function
    End If

    SocketsInitialize = True

End Function

[Jbajin]

Ok... How do I know when a computer has failed. All you have is 4 text boxes.. That is the biggest part of this deal. I really don't need to know the speed and what not. I just need to know if it failed of not.

[gwdash]

This code returned ip success for an invalid ip address

[ttingen]

Joe,

I found this code on vbcode.com. In the description it states that "At each interval, PingMon will cycle through the IP address list and place each IP in the SUCCESS list box or the FAILURE listbox." That looks like the functionality you were looking for. I haven't tried it so I can't guarantee its success or failure.

http://www.vbcode.com/asp/showzip.as....zip&theID=932

Hope this helps.

[Jbajin]

The problem I am having is that the program won't resolve the computer name. Is there something I am missing?

[ttingen]

That sounds more like a dns issue rather than the program. DNS should resolve the computer names.

[ttingen]

So what happened? I'm curious.

[Jbajin]

it takes the computer name from the list. Then spits out the Code 110018 which is IP_BAD_DESTINATION.. I go to a Command prompt and it works fine. But if I use the program then it gives me an error.

[ttingen]

That is definitely a program error. I'm sorry it didn't work. I wouldn't be surprised if you didn't want to use this next suggestion but I found another applet on planet source code that can also ping and resolve the host name. From the screen shot you would have to modify it a little to give you the functionality that you want (result listbox).

http://www.planetsourcecode.com/vb/s...txtCodeId=4664

[gwdash]

i was able to combine both the given programs to resolve the hostnames into ips and then use the other program with the success or failure

I just added the basPing mod to the other program. Did a quick check to see wether it was an ip or not, and then if it wasn't, resolved it, then fed it to the program!

works like a charm!!!!

[Jbajin]

It worked for me also.. Thanks a lot guys.. Made this project a lot simpliar with all your help. I really do appreciate it.