Printable View
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
Code:'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
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.
This code returned ip success for an invalid ip address
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.
The problem I am having is that the program won't resolve the computer name. Is there something I am missing?
That sounds more like a dns issue rather than the program. DNS should resolve the computer names.
So what happened? I'm curious.
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.
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
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!!!!:cool:
It worked for me also.. Thanks a lot guys.. Made this project a lot simpliar with all your help. I really do appreciate it.