The CS_PingChecker spreadsheet allows a list of hosts to be pinged sequentially and the results compared from host to host.

The control buttons on the left hand side perform the following function:

Button

Functionality

Read

Pings the Hosts in Column D and outputs the results to column E. Each new time read is selected then the next available column to the right will be timestamped and the millisecond response time will be populated in that column.

Clear Results

Deletes the results from column E and higher

Populate a list of hosts in column D, the hosts can be listed by either FQDN, hostname or IP Address. (e.g. server1.sourcedom.com or server1 or 10.1.2.3).

Select the read button to start pinging and the current results will be populated in column E.

Result

 

IP Address

The object has been pinged successfully (IP Address recorded)

Not found

The hosts name to IP address cannot be resolved

Error

There is an error pinging the host

A second set of results will be populated in a timestamped column in the first available column to the right.

TimeStamp

 

Millisecond Response

The object has been pinged successfully (Milliseconds recorded)

Not found

The hosts name to IP address cannot be resolved

Error

There is an error pinging the host

This spreadsheet will allow the ping results of many hosts to be recorded and compared and the result of those pings to be compared at different times.