agents traceability

Moderator: crythias

Post Reply
Ortensia
Znuny newbie
Posts: 8
Joined: 28 Aug 2017, 09:44
Znuny Version: 5 free

agents traceability

Post by Ortensia »

Hi,
how can i extract the agents lislt, of all the agents that are assigned to a specific ticket, during the ticket's life?
And which is the name of the database table for the agents?

Thanks
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: agents traceability

Post by RStraub »

Hey there,

you'd probably have to parse all history entries that were made to the ticket.

According to the db-schema, agent data is kept in the table "users":
https://raw.githubusercontent.com/OTRS/ ... iagram.png
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Post Reply