HERE is the script that you can add to cron. Don’t forget to update the file with your influx creds and provisioned upload/download.
mkdir /root/scripts wget https://leffler.tech/uploads/2021/09/28/speedtest2influx.sh -O /root/scripts/speedtest2influx.sh echo '0 * * * * root /root/scripts/speedtest2influx.sh' >> /etc/cronab HERE is the json for the dashboard
nano /etc/telegraf/telegraf.d/input-hdhr.conf
[[inputs.exec]] commands = ["curl http://<IP-OF-DEVICE>/status.json"] timeout = "5s" data_format = "json" name_override = "HDHomeRun" tag_keys = ["Resource"] [inputs.exec.tags] device="<IP-OF-DEVICE>" HERE is the json for the dashboard
This might get updated, might not.
Here is a basic cheatsheet for InfluxDB I’ve learned from playing with the TIG stack
How to find the hosts in the series. You run the below command and just go through the list to find the host you want to delete. You can delete with what you know the host is, but his is nice because it will insure there wasn’t a typo
WHERE "host" = 'DESKTOP-NAME'
Here is how you actually drop the data from the DB that way it’s not displayed in Grafana anymore