louislam / uptime-kuma

A fancy self-hosted monitoring tool
https://uptime.kuma.pet
MIT License
59.59k stars 5.32k forks source link

Export monitor data (ping, downtimes, etc) #1093

Open ternium1 opened 2 years ago

ternium1 commented 2 years ago

⚠️ Please verify that this feature request has NOT been suggested before.

🏷️ Feature Request Type

Other

🔖 Feature description

Export monitor data as JSON, text file, or excel (csv) (to plot in excel?).

✔️ Solution

In the dashboard, A button to export the data that opens a modal that lets you export the data as you want (file type, etc.) like shown in the picture (sorry my UI is in French) image image (with a space between the buttons, it would be better)

❓ Alternatives

No response

📝 Additional Context

No response

rezzorix commented 2 years ago

Very much love to have this.

With a 20second interval opening the 1week monitor chart gets the browser / VM pretty much down to its knee 😆

xeruf commented 2 years ago

Yes, and it could even be integrated with something like https://vega.github.io/vega-lite to produce custom charts - in some cases an offline report is expected

xeruf commented 2 years ago

I guess exporting directly from the kuma.db residing at /var/lib/docker/volumes/uptime-kuma/_data/kuma.db should not be too hard. Filter the heartbeat table according to the monitor_id from the monitor table and then convert it somehow...

xeruf commented 2 years ago

I am currently in the process of writing a script to visualize the data of the db into a strip plot: https://vega.github.io/vega-lite/examples/tick_strip.html I will push it to a public repo once it's a little more polished :)

clavimarmotel commented 2 years ago

Any news on this feature ? It is the exact holy grail of missing parts to turn this into the perfect solution :) .

rezzorix commented 2 years ago

Check here: https://github.com/louislam/uptime-kuma/wiki/Prometheus-Integration