OsTicket SLA

 Select Distinct ost_ticket.ticket_id As NumeroTicket, ost_user.name As Cliente, ost_ticket.ip_address As IP, ost_department.name As Depto, ost_staff.username As Ingeniero, ost_ticket.source As Origen, ost_ticket.created As FechaCreacion, ost_ticket.duedate As DueDate, ost_ticket.closed As ClosedDate, ost_ticket.status_id As STATUS, ost_help_topic.topic From ost_ticket Join ost_staff On ost_staff.staff_id = ost_ticket.staff_id Join ost_department On ost_ticket.dept_id = ost_department.id Join ost_user_email On ost_ticket.user_id = ost_user_email.user_id Join ost_user On ost_user_email.id = ost_user.id Inner Join ost_help_topic On ost_ticket.topic_id = ost_help_topic.topic_id

where ost_ticket.closed between '2020-09-01' and '2020-09-30';

Select Distinct ost_ticket.ticket_id As NumeroTicket, ost_user.name As Cliente,

 ost_ticket.ip_address As IP, ost_department.name As Depto, ost_staff.username As Ingeniero,

 ost_ticket.source As Origen, ost_ticket.created As FechaCreacion, ost_ticket.est_duedate as HoraSLAVencido,

 ost_ticket.closed As FechaCierre, ost_ticket_status.name As Estatus, ost_help_topic.topic As TemadeAyuda, 

 (ost_ticket.closed- ost_ticket.created )/(60) as TiempoCierreMS

 /*Date_Format(ost_ticket.created,'%d/%m/%y %T') - date_format(ost_ticket.closed,'%d/%m/%y %T') as Cerrado*/

 From ost_ticket 

 Join ost_staff On ost_staff.staff_id = ost_ticket.staff_id 

 Join ost_department On ost_ticket.dept_id = ost_department.id 

 Join ost_user_email On ost_ticket.user_id = ost_user_email.user_id 

 Join ost_user On ost_user_email.id = ost_user.id 

 join ost_ticket_status on ost_ticket.status_id = ost_ticket_status.id

 Inner Join ost_help_topic On ost_ticket.topic_id = ost_help_topic.topic_id

where ost_ticket.created between '2020-06-01' and '2020-08-30';