Grafana dashboards

Infos:

  • Used Zammad version: 3.6
  • Used Zammad installation source: docker
  • Operating system: -
  • Browser + version: -

I saw on the zammad.com page there is an integration with Grafana, which seems really cool.
However i’ve been searching but i couldn’t really find template dashboard’s, which could be used as a starting point. Are there any predefined dashboard’s available or even a couple of usefull queries to start from? Also i wonder if there is some documentation available?
What i currently understand is that you have to connect grafana to the elasticsearch instance and not the database?

Thanks Olaf

Please also read the description:

All statistics about your company at a glance: link your Grafana account with Zammad’s Elasticsearch and always see exactly what’s going on.

So yes, you have to hook up your ES index.
No, there’s no documentation.

Thank you for your reply.
For people looking for a starting point, zammad creates these indexes;
zammad_production_stats_store
zammad_production_knowledge_base_translation
zammad_production_organization
zammad_production_ticket
zammad_production_knowledge_base_category_translation
zammad_production_user
zammad_production_knowledge_base_answer_translation
zammad_production_cti_log

probably the most useful starting point is this configuration;

also keep in mind, grafana currently removed the advanced query editor; https://github.com/grafana/grafana/issues/3163 which makes some more advanced queries difficult to accomplish.

If i’ve found some useful queries i’ll share them here.

2 Likes

@olafbuitelaar Thanks you for your inputs. Looking forward to see what queries you have. Thank you!!

I found that most queries are actually much simpler directly on the database, instead of on ES. Since grafana doesn’t support script queries on ES. The disadvantage is that the state is changed in the database, so you can’t get historical stats, which i believe you could get from ES. Currently i don’t have a cohesive dashboard, and lack a bit of inspiration on, what kind of dashboards would be nice. We also started using zammad since a couple of weeks. So if you have idea’s please post them.
see below some of my trials in a dashboard, it expects 2 datasources, zammad (connecting to ES) and zammad-db (connecting to the postgres database);

places as gist, due to body char limit;

1 Like

@olafbuitelaar Thank you for sharing. Yes I noticed the issues with the historical data and thus the need for using a combination of DB and ES, if not only the use of ES.

I am going work with this for a few days as I have an immediate need for getting Zammad ticket data e.g. agent performance, open/closed, SLA exceeded tickets etc in to place.

I’ll keep you posted on what I find.