0

Add a date_mod column to the glpi_tickets_users table

precision1998 1 year ago updated 1 year ago 0

Add a date_mod column to the glpi_tickets_users table so there is a source other than glpi_logs to retrieve a ticket assignment timestamp for a specific user from. Currently you  have to join 3 additional tables to yield an average time-to-solve per user. This could be alleviated by storing the assignment date in the glpi_tickets_users entries.