I have installed grafana and using influxdb to monitor my unifi network.
The issue I have is, one of the graphs within the template that I have downloaded has no data. I have tried to look at it and see why but I cannot figure out what it is trying to extract. Below is the query.
The panel is trying to show Data Transfer by Category.
SELECT non_negative_derivative(sum(“rx_bytes”), 1s) AS “Bytes Rx”, non_negative_derivative(sum(“tx_bytes”), 1s) AS “Bytes Tx” FROM “sitedpi” WHERE (“site_name” =~ /^$site$/) AND $timeFilter GROUP BY time($__interval), “category”
Looking at the query I think that the issue is the table name “sitedpi”. If I run the command SHOW MEASUREMENTS; I do not see a table called “sitedpi”, but I have no clue what table to put in its place to get data to be presented to the graph.
Below is the results of the SHOW MEASUREMENTS;
Show Measurements;
name: measurements
name
clients
subsystems
uap
uap_radios
uap_vaps
usg
usg_networks
usg_wan_ports
usw
usw_ports
Any help would be much appreciated
Thanks
Lawrence