5 seconds ping to TSVs

DynV · 11-26-2022, 01:31 AM

I recently had connection issues and used

Code:

date +"%Y-%m-%d"; while true ; do ping -n 1 google.ca | head -n 3; date +"%T" ; sleep 5 ; done

in a console for my short-term documentation. I'd like to do something similar for longer-term, so I'd like it to be output to a file. I'd like for the output to be in "pinger-5secs-YYMMDD.tsv" and for the TSV to contain the columns "Time" & "Reply ms".

I'm thinking for reply ms the above (

Code:

ping -n 1 google.ca | head -n 3

) can be taken and run through a regex for the # right after "ms=", and if there's none insert something to show that, ie the character ' ⃠ '. I foresee the time remaining the same (

Code:

date +"%T"

). Of course since it's a TSV, a tab between the 2.

Thank you kindly for your help

teckk · 11-26-2022, 08:03 AM

Example:

Code:

echo $(date +"%Y-%m-%d") >> pinger-5secs-YYMMDD.tsv

while :; do 
    echo -e "\n$(date +"%T")" >> pinger-5secs-YYMMDD.tsv
    echo $(ping -c1 127.0.0.1) >> pinger-5secs-YYMMDD.tsv
    sleep 5
done

DynV · 11-26-2022, 08:15 AM

Quote:

Originally Posted by teckk

Example:

Code:

echo $(date +"%Y-%m-%d") >> pinger-5secs-YYMMDD.tsv

while :; do 
    echo -e "\n$(date +"%T")" >> pinger-5secs-YYMMDD.tsv
    echo $(ping -c1 127.0.0.1) >> pinger-5secs-YYMMDD.tsv
    sleep 5
done

YYMMDD is to be replaced by the date of the same format. Only the # in "ms=#" is to be kept from the ping. I don't see a tab being used to separate the data in 2 columns.

teckk · 11-26-2022, 09:15 AM

Write it the way that you wish. Show the script that you have written, and where it is having problems. The idea is for you to do it yourself. Not someone write it for you.

Quote:

YYMMDD is to be replaced by the date of the same format.

Code:

a="pinger-5secs-"
b=$(date +"%Y-%m-%d")

echo ""$a""$b".tsv"
pinger-5secs-2022-11-26.tsv

Quote:

I don't see a tab being used to separate the data in 2 columns.

Then make it they way you want it to be.

Code:

a="one"
b="Two"

echo -e ""$a"\t"$b""
one     Two

See:
man echo

pan64 · 11-26-2022, 09:52 AM

Oh, no Useless use of echo

Code:

a="pinger-5secs-"
b=$(date +"%Y-%m-%d")
filename="$a$b.tsv"
while ;: do
    ping -c1 127.0.0.1
    date +"%T"
done > "$filename"

(intentionally non-working example)

TB0ne · 11-26-2022, 10:22 AM

Quote:

Originally Posted by DynV

I recently had connection issues and used

Code:

date +"%Y-%m-%d"; while true ; do ping -n 1 google.ca | head -n 3; date +"%T" ; sleep 5 ; done

in a console for my short-term documentation. I'd like to do something similar for longer-term, so I'd like it to be output to a file. I'd like for the output to be in "pinger-5secs-YYMMDD.tsv" and for the TSV to contain the columns "Time" & "Reply ms".

I'm thinking for reply ms the above (

Code:

ping -n 1 google.ca | head -n 3

) can be taken and run through a regex for the # right after "ms=", and if there's none insert something to show that, ie the character ' ⃠ '. I foresee the time remaining the same (

Code:

date +"%T"

). Of course since it's a TSV, a tab between the 2.

Thank you kindly for your help

You can use an already-existing tool for such things, unless you very specifically NEED a TSV file
https://oss.oetiker.ch/smokeping/

dugan · 11-26-2022, 12:28 PM

Trying pinging by IP as well as by domain name (to see if the problem is DNS), also do a traceroute (to see where the delay actually is).

jefro · 12-03-2022, 08:59 AM

Some or many routers along the path might have been set to delay or deny ping on load. Ping isn't a great tool anymore. Use other tools for displaying the full path and in the IP version you want or need.