connmon connmon - Internet connection monitoring

[maghuro]

Assuming I haven't screwed up the logic:

Weekly: Data is averaged over hour long periods for the last 7 days
Monthly: Data is averaged over 3 hour long periods for the last 30 days

I'm asking only because I usually have 30-40ms ping, and on monthly I can see averages of 50 ms

 

[Jack Yaz]

I'm asking only because I usually have 30-40ms ping, and on monthly I can see averages of 50 ms

You can download the CSV output now to check where it gets the numbers from. To verify the 30 days averages you would need to pull off the "raw" values, and then manipulate as required in Excel or something

 

[maghuro]

You can download the CSV output now to check where it gets the numbers from. To verify the 30 days averages you would need to pull off the "raw" values, and then manipulate as required in Excel or something

I'll do it and after that give feedback

 

[Jack Yaz]

As soon as I change to raw, the page becomes almost irresponsive, but yeah I get values!

That's the downside to raw - lots of data points to plot. ChartJS 3 (currently in alpha) promises a big boost in performance, but there are a lot of breaking changes. I'll investigate migrating once it is stable and documentation is available.

 

[CaptainSTX]

You can download the CSV output now to check where it gets the numbers from. To verify the 30 days averages you would need to pull off the "raw" values, and then manipulate as required in Excel or something

I selected the option to download CSV file and it did so as a ZIP file which is fine.

I then opened the CSV file in Excel which is fine except I can't find a date/time function in Excel (2007 edition ) that will translate the column labeled time into a useful value. What function are you using and in which version of Excel to convert value for Time to a more standard date time?

Data was pulled from CSV file called Ping Daily


Metric Time Value

Ping 1586633131 16.291
Ping 1586633431 17.754
Ping 1586633730 15.336
Ping 1586634031 15.495
Ping 1586634331 15.824
Ping 1586634631 15.323
Ping 1586634931 16.201
Ping 1586635232 15.492
Ping 1586635531 15.435
Ping 1586635831 15.539
Ping 1586636131 15.213
Ping 1586636431 16.198

 

[Jack Yaz]

I selected the option to download CSV file and it did so as a ZIP file which is fine.

I then opened the CSV file in Excel which is fine except I can't find a date/time function in Excel (2007 edition ) that will translate the column labeled time into a useful value. What function are you using and in which version of Excel to convert value for Time to a more standard date time?

Data was pulled from CSV file called Ping Daily


Metric Time Value

Ping 1586633131 16.291
Ping 1586633431 17.754
Ping 1586633730 15.336
Ping 1586634031 15.495
Ping 1586634331 15.824
Ping 1586634631 15.323
Ping 1586634931 16.201
Ping 1586635232 15.492
Ping 1586635531 15.435
Ping 1586635831 15.539
Ping 1586636131 15.213
Ping 1586636431 16.198

https://exceljet.net/formula/convert-unix-time-stamp-to-excel-date
It's a unix timestamp

 

[CaptainSTX]

Thanks. Worked perfectly. I knew Excel counts from Jan 1900 wasn't aware when unix time started.

I now need to adjust for time zone and DST

Ping 16.148 4/12/20 7:00 PM
Ping 15.906 4/12/20 7:05 PM
Ping 15.707 4/12/20 7:10 PM
Ping 15.495 4/12/20 7:15 PM

Average 15.667


Std Dev 0.812
UPDATE:
To have the time shown in your local time zone you need to modify the unix value in seconds by the offset of your local time zone in seconds. In my case I needed to subtract 14,400 seconds from the value in the CVS file.

 

[maghuro]

spdMerlin, ntpMerlin...
Why not svcMerlin and conMerlin?

 

[L&LD]

In time, if needed.

 

[L&LD]

To be, or not to be. (Jack Yaz'd, that is).

 

[LimJK]

spdMerlin, ntpMerlin...
Why not svcMerlin and conMerlin?

How about monMerlin? "mon" as per monitoring

 

[QuikSilver]

I vote to leave it as it is. No need to rename something that has been for almost year or so. Oh and btw, Happy upcoming 1st birthday (April 17, 2019) to this script!

 

[Stephen Harrington]

https://exceljet.net/formula/convert-unix-time-stamp-to-excel-date
It's a unix timestamp

@Jack Yaz please is there any chance you could output the .CSV files with the "human readable" date/times (corrected for timezone) like you already do for the GUI display?
I think it would be much appreciated by the majority of us rather than having to fiddle with Excel on the Unix Timestamps each time we output a CSV
(Likewise for the upcoming spdMerlin 2.40 if it is doable)

 

[Jack Yaz]

@Jack Yaz please is there any chance you could output the .CSV files with the "human readable" date/times (corrected for timezone) like you already do for the GUI display?
I think it would be much appreciated by the majority of us rather than having to fiddle with Excel on the Unix Timestamps each time we output a CSV
(Likewise for the upcoming spdMerlin 2.40 if it is doable)

Right now the zip just bundles the existing csvs. I can look to modify the timestamps for the csvs, but this will add processing time (hopefully minimal if I can implement what I'd like to) but it will slow down every speedtest/csv generation run.

Good news, a simple awk command should work

 

[Stephen Harrington]

Right now the zip just bundles the existing csvs. I can look to modify the timestamps for the csvs, but this will add processing time (hopefully minimal if I can implement what I'd like to) but it will slow down every speedtest/csv generation run.

Good news, a simple awk command should work

Ok, sorry to give you more work, hope it works out and you can also port the "fix" to do similar on spdMerlin

 

[Jack Yaz]

Ok, sorry to give you more work, hope it works out and you can also port the "fix" to do similar on spdMerlin

I'll likely make it a toggle option, I'll try and thrash it out this morning, but covering the helpdesk for work today (bank holiday, so hopefully quieter!). I'm sure there'll still be the odd customer who chooses to verbally abuse us though

 

[Stephen Harrington]

I'll likely make it a toggle option, I'll try and thrash it out this morning

Thanks! Toggle option at CLI fine by me.
Hope you don't get abused TOO much!

 

[Jack Yaz]

v2.4.1 is now available!
Changelog:

NEW: Add option to toggle time format in CSV exports between Unix and non-Unix time

 

[Stephen Harrington]

NEW: Add option to toggle time format in CSV exports between Unix and non-Unix time

Thanks Jack, appreciate it!
Any chance of getting the date/time in ISO format (like you display it in the spdMerlin GUI), for us weird countries like Australia that don't use US-style dates?

2020-04-13 18:42:18    94.06    37.94
2020-04-13 18:12:18    93.9    37.9
2020-04-13 17:42:19    93.45    37.96

 

[Jack Yaz]

Thanks Jack, appreciate it!
Any chance of getting the date/time in ISO format (like you display it in the spdMerlin GUI), for us weird countries like Australia that don't use US-style dates?

2020-04-13 18:42:18    94.06    37.94
2020-04-13 18:12:18    93.9    37.9
2020-04-13 17:42:19    93.45    37.96

God you really don't ask for much do you! Haha.

Currently it should be printed as

"%Y-%m-%d %H:%M:%S"

yyyy-mm-dd is the only acceptable standard for dates, IMHO

US date format is mm/dd/yyyy
UK format is dd/mm/yyyy