Actually, I came up with a work around. I created an App with a shell script that runs the “networkquality” command and writes it to a file. The output is not as utilitarian as a spreadsheet but it does provide the network data I’m looking for.
I have a recurring calendar event set up to execute the app periodically throughout the day since there is no hourly recurring schedule option( only day, week, month, year). Less than ideal and a maintenance nightmare.
What I would love me to do is schedule this command using Terminal. I currently use a scheduled restart command
”sudo pmset repeat restart S 01:00:00” to restart the z Mac every Sat AM and would like to do something similar for the “NetworkQuality.app” I created in Automator. I think this might use launchd but I’m no programmer.
here’s an example of the report produced by the app.
cd /Users/Scott/Desktop
networkquality -v >> Networkquality.txt
[2K==== SUMMARY ====
Uplink capacity: 28.652 Mbps (Accuracy: High)
Downlink capacity: 833.474 Mbps (Accuracy: High)
Responsiveness: Low (153 RPM) (Accuracy: High)
Idle Latency: 35.458 milliseconds (Accuracy: High)
Interface: en0
Uplink bytes transferred: 48.593 MB
Downlink bytes transferred: 1.275 GB
Uplink Flow count: 16
Downlink Flow count: 12
Start: 5/21/23, 4:52:42 PM
End: 5/21/23, 4:52:56 PM
OS Version: Version 13.4 (Build 22F66)
[2K==== SUMMARY ====
Uplink capacity: 27.978 Mbps (Accuracy: High)
Downlink capacity: 870.769 Mbps (Accuracy: High)
Responsiveness: Low (146 RPM) (Accuracy: High)
Idle Latency: 31.583 milliseconds (Accuracy: High)
Interface: en0
Uplink bytes transferred: 47.562 MB
Downlink bytes transferred: 1.328 GB
Uplink Flow count: 16
Downlink Flow count: 12
Start: 5/22/23, 6:35:36 AM
End: 5/22/23, 6:35:50 AM
OS Version: Version 13.4 (Build 22F66)