How find queue that Resolved a ticket?

Moderator: crythias

Thommino
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
nedmaj
OTRS wizard
Posts: 153
Joined: 26 Nov 2014, 20:34
OTRS Version?: 5.0.17
Real Name: Samuel Casimiro
Company: CD
Contact:

Re: How find queue that Resolved a ticket?

Postby nedmaj » 26 Oct 2017, 18:21

Hi,

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

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


Return to “General”

Who is online

Users browsing this forum: No registered users and 6 guests