0

Add a date_mod column to the glpi_tickets_users table

precision1998 2 years ago updated 2 years 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.