grafana-toolbox / grafana-wtf

Grep through all Grafana entities in the spirit of git-wtf.
GNU Affero General Public License v3.0
149 stars 14 forks source link

Statistics reports for data sources and panels #18

Open jangaraj opened 2 years ago

jangaraj commented 2 years ago

I would like to see datasource stat, which answer my question:

What is the most popular datasource type?

Datasources types stat - total 15:
  cloudwatch         10
  influxdb            5

Which datasource is unused in any dashboard; how many dashboards/panels/variables use = datasource popularity? It can replace

Datasource usage stat:
  name              dashboards  panels variables
  datasource-1      4           20         0
  ...
  datasource-15     0            0         0

And similar stats also for panels:

Panel stat:
 type                              total               dashboards
  graph                              354                      121
  text                                58                       20
  singlestat                         134                       30
  blackmirror1-singlestat-math-panel  20                        5
  row                                 50                       10
  table                              201                      156

Thank you.

amotl commented 2 years ago

That is a sweet idea!

amotl commented 1 year ago

Dear Jan,

with GH-65, we added SQL querying capabilities to the dashboard edit history data, based on DuckDB. I believe it could help implementing your suggestions, when also applying it to the main dashboard- and datasource-data.

With kind regards, Andreas.