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
rds-ping
RDS-PING(1) BSD General Commands Manual RDS-PING(1)
NAME
rds-ping -- test reachability of remote node over RDS
SYNOPSIS
rds-ping [-c count] [-i interval] [-I local_addr] remote_addr
DESCRIPTION
rds-ping is used to test whether a remote node is reachable over RDS. Its interface is designed to operate pretty much the standard ping(8)
utility, even though the way it works is pretty different.
rds-ping opens several RDS sockets and sends packets to port 0 on the indicated host. This is a special port number to which no socket is
bound; instead, the kernel processes incoming packets and responds to them.
OPTIONS
The following options are available for use on the command line:
-c count
Causes rds-ping to exit after sending (and receiving) the specified number of packets.
-I address
By default, rds-ping will pick the local source address for the RDS socket based on routing information for the destination address
(i.e. if packets to the given destination would be routed through interface ib0, then it will use the IP address of ib0 as source
address). Using the -I option, you can override this choice.
-i timeout
By default, rds-ping will wait for one second between sending packets. Use this option to specified a different interval. The timeout
value is given in seconds, and can be a floating point number. Optionally, append msec or usec to specify a timeout in milliseconds
or microseconds, respectively.
Specifying a timeout considerably smaller than the packet round-trip time will produce unexpected results.
AUTHORS
rds-ping was written by Olaf Kirch <olaf.kirch@oracle.com>.
SEE ALSO
rds(7), rds-info(1), rds-stress(1).
BSD
Apr 22, 2008 BSD