Forum GLPI-Project

fernandopinto

Member

Registered: 2023-09-20

Posts: 1

Get the duration of a ticket´s moviments?

Hello,

In which table can I Get the duration of a ticket´s moviments?

I tried, but the dates do not appear to be those os the movement record:

SELECT t.date_creation, t.closedate, glpi_logs.date_mod AS 'Nome do grupo' FROM glpi_tickets t
left join glpi_logs on (t.id=glpi_logs.items_id)
WHERE  t.id = 123456