search

neuralfraud / grafana-prtg

A PRTG Datasource plugin for Grafana
180 stars 75 forks source link

Query only the last value of a channel #144

Open xqlz0 opened 4 years ago

xqlz0 commented 4 years ago

First, thank's a lot @neuralfraud for this plugin and the work you're puting again on it.

My question is the following: Would it be possible to set the query to only request the latest pooled value instead of an array depending on the timerange?

The reason for that request is that I’m trying to set up a map with the globalnoc-networkmap-panel to show the reachability of around 200+ elements (so basically tracking Ping).

In PRTG all the sensors are pooled every minute, but on Grafana if a timeframe less than "now-45m" is selected, no data is displayed.

When going over 50+ elements with that timeframe, Grafana just become totally unresponsive.

I understand that the plugin might not be designed to have such a load, but that's the only workaround I see. If anyone have suggestion, don’t hesitate.

*The setup is PRTG 19.3.52.3502+, Grafana 6.5.and the latest version of the plugin

forever765 commented 4 years ago

I also found the same problem. When using Gauge and Bar Gauge panel, if more than 10 channels are queried, it will put a lot of pressure on the PRTG Core Server. In extreme cases, it will even cause PRTG to crash.

xqlz0 commented 4 years ago

The problem come from the amount of data pooled in timeseries when just want to see the current status or last pooled value of sensors. A RAW query to table.json with content=sensors&columns=device,status_raw&filter_tags=@tag(switch)&filter_name=@sub(ping) return exactly the reachability of devices in a few seconds, but then that data cannot be interpreted by the visualization part of Grafana.