How find queue that Resolved a ticket?

Moderator: crythias

Post Reply
OTRS newbie
Posts: 1
Joined: 06 Oct 2017, 19:50
OTRS Version?: 3.2.0
Real Name: Thomas

How find queue that Resolved a ticket?

Post by Thommino » 06 Oct 2017, 22:38

I need to execute a query to find the last queue that set the ticket into status Resolved, Pending, Incomplete, Rejected.

User avatar
OTRS wizard
Posts: 156
Joined: 26 Nov 2014, 20:34
OTRS Version?: 5.0.17
Real Name: Samuel Casimiro
Company: CD

Re: How find queue that Resolved a ticket?

Post by nedmaj » 26 Oct 2017, 18:21


Have a look at ticket history table. I think the event you are looking for is StateUpdate.

OTRS 5.0.17 | OTRS::ITSM 5.0.17
OS: CentOS 6.5 | Database: Oracle 12.1
Reporting: Pentaho | DW Database: PostgreSQL
User database and auth module: LDAP (Active Directory)
Mail server: Microsoft Exchange | Sendmail module: Sendmail
3rd party packages: Yes | SSL: Yes
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000

Post Reply