Grafana dashboards

Technical assistance
1

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

2

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.

3

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;

image
image1167×393 21.1 KB

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.

3 Likes
4

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

5

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;

2 Likes
6

@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.

7

there seems to be some traction on the issue; Elasticsearch: Reintroduce raw query editor · Issue #3163 · grafana/grafana · GitHub
if there are idea’s for ES queries in grafana, it might be interesting to attend.

8

it looks like a new repo emerged; GitHub - zammad/grafana-dashboards: This repository contains sample Dashboards for Zammad to help you with a quick start. the screenshots look impressive, hopefully the documentation and some samples will be added there as well

9

(⊙_⊙;)

Soon™ yes.
I’m currently under heavy load which doesn’t fasten up the process, sorry for the wait and tease.

image
image1841×890 231 KB

2 Likes
10

cool thanks! if the community can do anything please share…

11

Extending my day to 48 hours would be quite a help! :nerd_face:
Right now there’s not much one can help me on this particular part, but thanks for the offer!

1 Like
12

Wild sample dashboards just happened to spawn within the grafana repo.
Same applies for documentation related things: Reporting Tools (Third party) — Zammad documentation

3 Likes
13

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.