Znuny and ((OTRS)) Community Edition

Buenas tardes, estoy tratando de sacar los tickets escalados de toda mi base de datos pero no hay forma. No me cuadran los tickets que salen con la realidad. La consulta que estoy haciendo es la siguiente: /*prueba poniendo mas ticket*/ SELECT T.title AS Ticket, T.customer_id AS Cliente, E.name AS S...

Hello! I have not solved a problem for some time, I can not show through mysql the tickets that have been scaled. I need it to show it in Grafana. The query that I created is the following: SELECT T.title AS Ticket, T.customer_id AS Cliente, E.name AS Servicio, DATE_FORMAT((T.create_time + INTERVAL ...