mirror of
https://github.com/grafana/grafana.git
synced 2025-08-02 15:52:29 +08:00
25 lines
589 B
SQL
25 lines
589 B
SQL
SELECT
|
|
{{ .Ident "namespace" }},
|
|
{{ .Ident "group" }},
|
|
{{ .Ident "resource" }},
|
|
COUNT(*),
|
|
MAX({{ .Ident "resource_version" }})
|
|
FROM {{ .Ident "resource" }}
|
|
WHERE 1 = 1
|
|
{{ if .Namespace }}
|
|
AND {{ .Ident "namespace" }} = {{ .Arg .Namespace }}
|
|
{{ end}}
|
|
{{ if .Group }}
|
|
AND {{ .Ident "group" }} = {{ .Arg .Group }}
|
|
{{ end}}
|
|
{{ if .Resource }}
|
|
AND {{ .Ident "resource" }} = {{ .Arg .Resource }}
|
|
{{ end}}
|
|
{{ if .Folder }}
|
|
AND {{ .Ident "folder" }} = {{ .Arg .Folder }}
|
|
{{ end}}
|
|
GROUP BY
|
|
{{ .Ident "namespace" }},
|
|
{{ .Ident "group" }},
|
|
{{ .Ident "resource" }}
|
|
; |