Bill Liu
DECLARE @TSQL varchar(8000), @DATE_FROM char(19), @DATE_TO char(19)
SELECT @DATE_FROM = REPLACE('2022-04-28T01:07:35Z', 'T', ' ')
SELECT @DATE_TO = REPLACE('2022-04-30T01:07:35Z', 'T', ' ')
SELECT @TSQL = '
SELECT DateTime AS time, K12-1STAT.CPV,K12-2STAT.CPV,K12-3STAT.CPV,K12-4STAT.CPV,K12-5STAT.CPV,K12-6STAT.CPV FROM OPENQUERY(
INSQL, ''
SELECT DateTime, K12-1STAT.CPV,K12-2STAT.CPV,K12-3STAT.CPV,K12-4STAT.CPV,K12-5STAT.CPV,K12-6STAT.CPV
FROM Runtime.dbo.WideHistory
WHERE wwResolution = 120000
AND wwRetrievalMode = "Average"
AND DateTime >= ''''' + @DATE_FROM + '''''
AND DateTime <= ''''' + @DATE_TO + '''''
AND wwTimeZone = ''''UTC''''
ORDER BY
DateTime ASC
'')
'
EXEC (@TSQL)
error: " db query error: mssql: Incorrect syntax near '.'. "
I dont see the '.'. anywhere
Melvict Melbourne
Automation kind of guy
Hi Bill,
I'm interested in how to read data with the Rest API into Grafana. How do I configure the OData Plugin to use NTLM?