How find queue that Resolved a ticket?

Moderator: crythias

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?

Postby 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: 147
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?

Postby 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 (Postfix)
3rd party packages: Yes
SSL: Yes
Number of agents: 450
Number of customers: 20000
Number of CIs: 30000

Return to “General”

Who is online

Users browsing this forum: No registered users and 5 guests