Grafana 筆記

handling NULL values in Query-based variable

 PostgreSQL query 變數空值處理

WHERE "my_field" IN (${my_variable})

當變數出現空值時

Templating
Template variables could not be initialized: pq: syntax error at or near ")"

變數格式改用pipe

WHERE "my_field" ~ ('${my_variable:pipe}')

解決~

key/value pairs as template variables on grafana

寫法

SELECT hostname AS __text, id AS __value FROM host

https://grafana.com/docs/grafana/latest/datasources/postgres/

LDAP - Active Directory server setup

公司環境再設定綁定不希望設定檔上出現帳密

調整設定如下:

[註:]內部Ldap 查詢功能會不能使用

bind_dn = "CORP\\%s" # or "%s@corp.local"
search_filter = "(sAMAccountName=%s)"
search_base_dns = ["dc=corp,dc=local"]

# 註解group mappings
# [[servers.group_mappings]]

https://grafana.com/docs/grafana/latest/auth/ldap/