Hi, I have successfully connected Grafana with a MSSQL database using the Grafana-Simple-SQL-Datasource proxy.
I have created a single stat dashboard with KPI’s from our helpdesk system.
However I would now like to create some graphs as well.
One example query is:
select COUNT (*) from dbo.HELPDESK where GRUPP_ID IN (1,2,4,6,7,8,15,16) AND STATUSID = 20
This query shows all cases with the wanted status and groups. I can see that the query successfully pulls the current value with the current value is not graphed over time.
I get the message Data points outside time range (Can be caused by timezone mismatch or missing time filter in query).
In the future I would like to have start and end time as variables to the graph can be changed on request.