Grafana日志面板+ MSSQL [英] Grafana Logs Panel + MSSQL

问题描述

Grafana日志面板希望从数据源获得什么样的数据?文档对此一言不发.

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

Gauge / Graph 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

解决方案

It turned out I need to switch "Format as" to "Table". By default it goes with "Time series" value wich is counter intuitive

这篇关于Grafana日志面板+ MSSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！