Skip to content

Latest commit

 

History

History
29 lines (17 loc) · 791 Bytes

README.md

File metadata and controls

29 lines (17 loc) · 791 Bytes

Otrs (github.com/OTRS) To Elastic/Kibana export

Use Cases: Key Performance Indicator (KPI) Tracker

Tracked Events: "EmailCustomer", "SendAnswer", "FollowUp"

  1. Standard Evens History: EmailCustomer -> SendAnswer -> FollowUp -> SendAnswer -> ...

  2. also possible Evens History: SendAnswer -> SendAnswer -> FollowUp -> FollowUp -> ...

Install

# start elastic and grafana:
/Downloads/elasticsearch-5.4.1$ bin/elasticsearch
/Downloads/grafana-4.3.2$ bin/grafana-server

# make ssh tunel to mysql like
ssh -v -L 3366:localhost:3306 use@server

# import grafana.json

OTRS Ticket Domain Model

https://github.com/OTRS/otrs/blob/master/development/diagrams/Database/OTRSDatabaseDiagram.png