Hi, Just to second that, it would be a great advantage to have that kind of reporting functionality available within the system! Kind Regards, Emma

...

...

Ilya Kornev 18 November 2009 18:29 >>> Michiel, thank you for the prompt reply. It'd be great to see feature like this in future versions of OTRS.

Regards, Ilya -----Original Message----- From: Michiel Beijen To: Ilya Kornev , "User questions and discussions about OTRS." Date: Wed, 18 Nov 2009 16:53:41 +0100 Subject: Re: [otrs] calculating time

Hi Ilya,

The only way to achieve this would be to parse the ticket history. This is viable, but not convenient.

We are planning on having an updated SLA section which caters for these kind of scenarios; to make it easier to retrieve this kind of data from the system.

((enjoy)) - Michiel Beijen R&D

OTRS AG Norsk-Data-Str 1. 61352 Bad Homburg Deutschland

T: +31 (0) 6457 42418 F: +49 (0) 9421 56818-18 I: http://www.otrs.com/

Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial register: 10751, Tax ID: 003 240 97505 Chairman of the Board: Burchard Steinbild, Managing Board: André Mindermann (CEO), Martin Edenhofer

CU@ IIR Service Desk Forum in Mainz

(Germany)<http://www.otrs.com/en/news-and-press/news-details/article/translate-to-engl... 13th-iir-service-desk-forum-2009/?tx_ttnews%5BbackPid%5D=51&cHash=ef91fa143e>and

get to know more about OTRS at booth no. 12 from Nov 24-25, 2009!

On Wed, Nov 18, 2009 at 2:57 PM, Ilya Kornev wrote:

...

Hello.

We need to get the following kind of stats: how much time a ticket spent in state X how much time a ticket spent in state Y.

For example: 1) A customer sends a request 2) 1 hour later an agent asks him/her to provide additional info 3) 4 hours after that the customer sends additional info 4) An hour after that the problem is solved , ticket is closed.

The report should contain (among other things like ticket #, queue, owner etc.) something like that:

State Y (awaiting us) - 2 hours State X (awaiting customer) - 4 hours

Is there any possibility to do this?

Cheers, Ilya Kornev

...

OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ ===================================================================== MSX International | Global Provider of Outsourced Integrated Business Solutions @ www.msxi-euro.com This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Warning: Although MSX International has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. We do not accept or send attachments of the type exe, vbs, scr or bat due to the increased virus risk they contain. These types of attachments will be stripped from the message. ===================================================================== Company Registration Numbers: UK, Ireland, Finland, Norway & Denmark - 1949542 Germany & Switzerland - HRB 29505 Germany Techservices - HRB 55978 Sweden - 516402-6832 Sweden AB - 556616-3431 Belgium - N.N.: 0851 412 550 Netherlands - 30210212 Austria - FN 287492H Spain - Italy - 12764340159 France - 444 713 986 00032 Ireland Technical Training Academy - 808746972 Czechia - C 119617