Hello again,
I need a query to build with the start/stop time from the grafana page.
The query below works:
SELECT value as value,TimeStampSeconds as time FROM OPENQUERY
(HISTORIAN, 'SET starttime=now-1d/d, endtime=now/d, samplingmode=Calculated CalculationMode = average, IntervalMilliseconds = 900000
SELECT * FROM ihRawData where tagname like SERVER010Utilties ')
This query not ( with $__timeFrom() and $__timeTo()
SELECT value as value,TimeStampSeconds as time FROM OPENQUERY
(HISTORIAN, 'SET starttime= $__timeFrom(), endtime=$__timeTo(), samplingmode=Calculated CalculationMode = average, IntervalMilliseconds = 900000
SELECT * FROM ihRawData where tagname like SERVER010Utilties ')
running error Status: 500. Message: db query error: sql: expected 18 arguments, got 0
without the () after the time no error but no data
So what i’am i missing here, do i need to transform the date and time ?
In de DB the data looks like this
Found something that works but not as aspected, only if i add -1d/d to the timefrom i get some data.
