Stats - measuring time of emails

Moderator: crythias

Locked
YdJMDS
Znuny newbie
Posts: 1
Joined: 10 Jul 2014, 15:50
Znuny Version: 3.1.8
Real Name: Yvonne de Jager
Company: Mediscor

Stats - measuring time of emails

Post by YdJMDS »

Hi

I need to create a report where I measure the time it took from when a email was received until it was locked by a user and then when it was closed.

I ran all the available report to see if there is some fields that I can use to create my own report, but the solution time/accounting time is blank.

Thanks
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Stats - measuring time of emails

Post by crythias »

YdJMDS wrote:it was locked by a user
irrelevant. You can fake this just by using the postmaster filter or generic agent and lock it.
YdJMDS wrote:the solution time/accounting time is blank.
accounting time is self reported.

In theory, you want to look at ticket_history for state changes according to your needs. There are queries in the forums on this.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Stats - measuring time of emails

Post by jojo »

the ticket list report gives you the timestamps
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked