Annotation Query Fails

Grafana MSSQL
,
1

So i tryed to use the graph in Grafana with my MSSQL Data Source
SELECT TOP (1000) [oems_company_history_guid]
,[oems_company_history_ou_guid]
,[oems_company_history_begin]
,[oems_company_history_end]
FROM [Exmaple].[dbo].[oems_company_history]

and i always get the error , Wrong Syntax near “<” … Can someone help me?

2

Can you see the Generated SQL?

I just created a simple table with the same name as yours and the query worked:

image
image1528×864 94.3 KB

But a query without a where clause is not a good idea. You should be using the Grafana time range to limit the query.

If you want to visualize it in a graph then you have to format the result correctly to get time series data.

Here is an example query that returns time series data (a time column, a name column and a value column). It uses macros like $__timeFilter() to make it easier to write the query.

SELECT
  $__timeGroup(createdAt,'$summarize') as time,
  avg(value) as value,
  'started' as metric
FROM 
  grafana_metric
WHERE
  $__timeFilter(createdAt) AND
  measurement = 'payment.started'
GROUP BY $__timeGroup(createdAt,'$summarize')
ORDER BY 1
3

Ok and how would that query look like if i would u se

 Select nn.ComputerID, client.ComputerName , count(*) as Anzahl 
From oems_client_nn_software as nn
Left Join oems_client as client on client.ComputerID = nn.ComputerID
 GROUP BY  nn.ComputerID, client.ComputerName

?? couldu show a example with that?

4

For time series data, you need a date time column. Do you have one?

If you don’t have a time column then there is not much point in trying to visualize a trend over time - which is what the graph panel does.

5

well i wanted to use the pie chart to show for example , how many diffrent software are installed on one Client , but i cant use pie chart because he wants a colum namend " time " is there no other way?