Extracting Latency, Loss and Jitter from PING responses. Post: 302264638

Sponsored Content

Top Forums Shell Programming and Scripting Extracting Latency, Loss and Jitter from PING responses. Post 302264638 by tony.kandaya on Thursday 4th of December 2008 12:36:08 PM

12-04-2008

Registered User

Thanks for all your help guys, here is what I have done so far

1 - a check-hosts script that uses a host-list.txt to ping konwn hosts

./check-hosts (script that pings hosts and generates the ping-results.txt)
rm -f ping-results.txt
cat hosts-list.txt |\
while read line
do
echo . >> ping-results.txt
date >> ping-results.txt
ping -c 5 -q $line >> ping-results.txt
echo $line
done

2 - host-list.txt

Host11
Host12
Host13
Host14

3 - I have modified the awk script (named extract-sla) from Zaxxon's response to read like this

awk '
/^PING / {h=$2}
/packet loss/ {pl=$6}
/min\/avg\/max/ {
split($4,a,"/")
printf("%s %s %s %s\n", h, a[2], a[4], pl )
}
' ping-results.txt

4 - Here is the new output from the results (which I can store into a file)

Host11 56.817 8.520 0%
Host12 55.031 8.485 0%
Host13 72.351 40.053 0%
Host14 32.590 9.705 0%

** Is there a way to get rid of the % sign since we already know it's a percentage.

5 - I would like to input these numbers into a database with a mysql command (the database and tables are already created)

Hostxx a b c

mysql -h 10.255.1.11 -u ping --password='ping' -D host_SLA -e "UPDATE device_list SET latency=a, jitter=b, loss=c WHERE host='Hostxx'";

Thanks for all your responses

tony.kandaya

View Public Profile for tony.kandaya

Find all posts by tony.kandaya

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

ping to machine and count responses

if i wanted to ping all the machines in a given directory (/etc/hosts) and return a total count of responses how would i go about scripting that? complete newbie...so be gentle if ; then //$1 = /etc/hosts cd "$1" //this puts me into the directory i need...but how do i send ...

2. Shell Programming and Scripting

How to automate responses

I would have searched for this but I couldn't really think of what to use for the search text... I've got a situation where I need to automate responses to an executable when running it from a script so that it can be made into a job the operators don't have to interact with. When I run it...

3. Linux

How do I capture responses from the chat command?

Unfortunately googling the word 'chat' gives you zebedee billion responses that relate to everything and few of them refer to the linux chat command. I've read the man page and found a couple of examples but can't see how to do this. I want to query the modem for it's manufacturer, product id...

4. Shell Programming and Scripting

Using AWK to Calculate Correct Responses

Hello, I am trying to count how many times a subject makes a correct switch or a correct stay response in a simple task. I have data on which condition they were in (here, labeled "IMAGINE" and "RECALL"), as well as whether they made a left or right button response, and whether the outcome was...

5. Shell Programming and Scripting

Extracting avg latency value from ping output

Hello Everyone, Below is the output of the ping from a router. Please help with a script which extract the Avg value from the o/p (Avg here = 4, as depicted below) and put the value into a new file. Will appreciate your help dearly Router#ping 36.36.36.36 Type escape sequence to abort....

6. AIX

Packet loss coming with big packet size ping

7. IP Networking

DNS: Dig returns different responses...

Hey everyone, Okay, so I've been having some fun with the dig command, and wanted to dig my old school. Two questions came up from this. So I: dig @8.8.8.8 +recurse njcu.edu ANY and the result is about 8 records, including the SOA record. One of them is this weird TXT record, and the other is...

8. Shell Programming and Scripting

Searching a file - and assigning responses to variables (or something)

So first: Sorry if the title is confusing... I have a script I'm writing with a file with several names in it (some other info - but it's not really pertinent...) - I want to be allow the user to delete certain records, but I ran into a problem I'm not sure how to go about fixing. If I were...

9. UNIX for Beginners Questions & Answers

Simple conditional yields too many responses

In this script: #!/bin/bash # bird read -p "Enter name of a bird " REPLY=$REPLY birdname="duck sparrow hawk" for i in $birdname do if ] then echo "Yes, that is a bird." else echo "That is not a bird." fi done I get...

LEARN ABOUT DEBIAN

aecho

AECHO(1)							   Netatalk 2.2 							  AECHO(1)

NAME

       aecho - send AppleTalk Echo Protocol packets to network hosts

SYNOPSIS

       aecho [ -c count ] ( address | nbpname )

DESCRIPTION

       aecho repeatedly sends an Apple Echo Protocol (AEP) packet to the host specified by the given AppleTalk address or nbpname and reports
       whether a reply was received. Requests are sent at the rate of one per second.

       address is parsed by atalk_aton(3).  nbpname is parsed by nbp_name(3). The nbp type defaults to `Workstation'.

       When aecho is terminated, it reports the number of packets sent, the number of responses received, and the percentage of packets lost. If
       any responses were received, the minimum, average, and maximum round trip times are reported.

EXAMPLE

       Check to see if a particular host is up and responding to AEP packets:

	   example% aecho bloodsport
	   11 bytes from 8195.13: aep_seq=0. time=10. ms
	   11 bytes from 8195.13: aep_seq=1. time=10. ms
	   11 bytes from 8195.13: aep_seq=2. time=10. ms
	   11 bytes from 8195.13: aep_seq=3. time=10. ms
	   11 bytes from 8195.13: aep_seq=4. time=10. ms
	   11 bytes from 8195.13: aep_seq=5. time=9. ms
	   ^C
	   ----8195.13 AEP Statistics----
	   6 packets sent, 6 packets received, 0% packet loss
	   round-trip (ms)  min/avg/max = 9/9/10

OPTIONS

       -c count
	   Stop after count packets.

SEE ALSO

       ping(1), atalk_aton(3), nbp_name(3), aep(4), atalkd(8).

Netatalk 2.2							    17 Dec 1991 							  AECHO(1)