Discussion on "Query and Visualise AVEVA Historian on Grafana Dashboard"

Bill Liu · 2021-09-18T23:20:14.324Z

This post will outline the procedure to set up Grafana to query tags from an AVEVA Historian using Microsoft SQL Server connector and plot them on a chart. Users can select available tags from a list. The reader is assumed to have prior knowledge of ...

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?

Bill, great tutorial. I've managed to get the trend to work but I'm having an issue with the taglist. I get an error after copying your code verbatim (upper right hand corner copy option). I'm using Wonderware 2014 R2 SP1 P2 and Grafana 8.4.5 i'm getting "db query error: mssql: Incorrect syntax near ')'. "

Hi Olivier, thanks for your comment. I would find the exact query that Grafana sends to MSSQL. You can either do it in Grafana using the "Query Inspector", or get the query history from MSSQL server. This might be an issue with Grafana templating.

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

Search Hashnode

Query and Visualise AVEVA Historian on Grafana Dashboard

Responses(2)