Forum GLPI-Project

tunierp

Member

Registered: 2024-12-05

Posts: 12

Table storing the user who added a solution to a ticket

Hello,

I would like to know which table in the GLPI 10.0.17 database stores the information about the user who adds a solution to a ticket.

My goal is to select the number of tickets resolved per day by each technician.
I noticed that the glpi_users_tickets table only contains ticket actors: Requester, Observer, and Technician, but no information about the person who added the solution.

The "Technician" field in GLPI does not indicate that this user is the one who added the solution. Therefore, I need another way to retrieve this information.

Thank you in advance for your help!

ITPM

Member

Registered: 2022-06-20

Posts: 16

Re: Table storing the user who added a solution to a ticket

Hello, check table "<prefix>_itilsolutions" and column "users_id"

Last edited by ITPM (2025-03-12 16:34:17)

tunierp

Member

Registered: 2024-12-05

Posts: 12

Re: Table storing the user who added a solution to a ticket

Oh thank you @ITPM , this is helpful.