Hello Grafana whizs.
I’m having a problem where I can’t chart or table any info coming from a PRTG db due to there being an issue with the Time field format (I think). I can see the data values I require but the timestamp is showing as NaN.
Here’s the Inspector Query Output:
Object
request:Object
method:"GET"
url:["http://localhost/api/historicdata.json?xxxxxxx id=2123&sdate=2021-09-20-11-00-33&edate=2021-09-20-12-00-33&avg=0&pctshow=false&pctmode=false&usecaption=1"](http://localhost/api/historicdata.jsonxxxxx
hideFromInspector:false
response:Object
prtg-version:"21.3.70.1629"
treesize:60
histdata:Array[60]
0:Object
datetime:"20/09/2021 11:00:34 AM"
Current:0
True Power:0
Voltage:239
Frequency:500
coverage:"100 %"
I’ve tried edit the Custom.ini file but it doesn’t seem to do anything:
Default system date format used in time range picker and other places where full time is displayed
full_date = DD-MM-YYYY HH:mm:ss a
Edit: Grafana ver is 8.1.3 and PRTG plugin is 4.0.4
Any ideas would be fantastic.
Thanks!