12-04-2008
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
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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 Replies)
Discussion started by: trostycp
2 Replies
2. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: djp
2 Replies
3. Linux
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... (8 Replies)
Discussion started by: Bashingaway
8 Replies
4. Shell Programming and Scripting
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 Replies)
Discussion started by: Jahn
5 Replies
5. Shell Programming and Scripting
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.... (2 Replies)
Discussion started by: sanjugab
2 Replies
6. AIX
(5 Replies)
Discussion started by: Vishal_dba
5 Replies
7. IP Networking
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... (1 Reply)
Discussion started by: Lost in Cyberia
1 Replies
8. Shell Programming and Scripting
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... (6 Replies)
Discussion started by: sabster
6 Replies
9. UNIX for Beginners Questions & Answers
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... (9 Replies)
Discussion started by: Xubuntu56
9 Replies
LEARN ABOUT DEBIAN
mrtg-ping-probe
MRTG-PING-PROBE(1) General Commands Manual MRTG-PING-PROBE(1)
NAME
mrtg-ping-probe - ping probe module for Multi Router Traffic Grapher
DESCRIPTION
mrtg-ping-probe is a ping probe module for MRTG 2.x. It is used to monitor the round trip time and packet loss to networked devices. MRTG
uses the output of mrtg-ping-probe to generate graphs visualizing minimum and maximum round trip times or packet loss.
mrtg-ping-probe is not run directly, but is called by MRTG as a helper when it needs to determine ping time to a host.
Act responsibly: do not use mrtg-ping-probe to ping devices without the owner's permission. Just imagine if 10,000 people decided to ping
your hosts! mrtg-ping-probe is meant to be used within your network to get round trip time performance figures for your network.
OPTIONS
To use mrtg-ping-probe you need to configure MRTG to call it from within the definition of a target host. This is done in the MRTG config
file, which is usually /etc/mrtg.conf.
Here's an example snippet: change the target name and IP address to suit your needs.
Target[your.target.ping]: `/usr/bin/mrtg-ping-probe 123.456.789.123`
SetEnv[your.target.ping]: MRTG_INT_IP="123.456.789.123" MRTG_INT_DESCR="ping"
MaxBytes[your.target.ping]: 100
AbsMax[your.target.ping]: 200
Options[your.target.ping]: gauge, growright
YLegend[your.target.ping]: ping time (ms)
ShortLegend[your.target.ping]: ms
Legend1[your.target.ping]: Maximum Round Trip Time in ms
Legend2[your.target.ping]: Minimum Round Trip Time in ms
Legend3[your.target.ping]: Maximal 5 Minute Maximum Round Trip Time in ms
Legend4[your.target.ping]: Maximal 5 Minute Minimum Round Trip Time in ms
LegendI[your.target.ping]: Max:
LegendO[your.target.ping]: Min:
Pay close attention to the backticks in the first line which tell MRTG to execute the nominated external program. Note also that you need
to use the "gauge" option, since the results of subsequent ping probes are independant values and not an incrementing counter.
SEE ALSO
mrtg(1).
The latest release of mrtg-ping-probe can be found on the web at http://pwo.de/projects/mrtg/
AUTHOR
This manual page was written by Jonathan Oxer <jon@debian.org>, for the Debian project (but may be used by others).
April 14, 2003 MRTG-PING-PROBE(1)