Grafana Logs Panel + MSSQL

Grafana MSSQL
1

What kind of data Grafana Log Panel expects from data source? Documentation does not say a word about it. /docs/grafana/next/visualizations/logs-panel/

Gauge / Graph query stucture does not work, other fields does not work for me too

SELECT
  le.Date as time,
  123 as value,
  'xxx' as metric
FROM [LogEntry] le
WHERE
  $__timeFilter(le.Date)
ORDER BY
  le.Date ASC

I expect it to work with something like query below, at least displaying date and text should be trivial.

SELECT
      le.Date as time,
      'anything' as text
    FROM [LogEntry] le
    WHERE
      $__timeFilter(le.Date)
    ORDER BY
      le.Date ASC
2

Hi there!

I had the same problem and I did the following:

SELECT
	j.created_on as time,
	j.notes
FROM issues i
inner join journals j on j.journalized_id=i.id
WHERE (LENGTH(j.notes) >= 3) and i.id = 133673
order by j.id desc
limit 1

Used “Format as Table”.

Hope you be succeded!

3

also if you have level column in db, it would be also useful, if it will be included as 3rd column in result, like:
select time, message, level from log_records