Statistice about moves

Hi all, I would like to produce statistics about the ticket flow. I.e. I would like to know how many tickets move from Queue1 to Queue2, things like that. Looking around in the OTRS database I find information in table "ticket_history" under the "ticket_history_id " "18" (Ticket moved to Queue 'Queue1'). Good, so I know where it is now but I do know where it was before, my task would be greatly simplified if the text would be changed to something like: Ticket moved from 'Queue1' to 'Queue2'. I think this is easily achived in OTRS. What are the chances to get this into the official otrs CVS ? thanks for the help and above all thanks for OTRS. Paul ---------------------------------------------------------------------------------------------------------------------- Electronic information is not secure, therefore the Entreprise des Postes et Telecommunications accepts no responsibility whatsoever for the contents of this message, which is intended for the addressee only. Its contents and any attached files are strictly confidential. If you have received this message in error, please telephone the following number 4765-1.

On Tuesday, April 06, 2004 10:13 AM
Paul Rhein
Good, so I know where it is now but I do know where it was before, my task would be greatly simplified if the text would be changed to something like: Ticket moved from 'Queue1' to 'Queue2'.
I think this is easily achived in OTRS. What are the chances to get this into the official otrs CVS ?
Very little. I'll explain, why. The ticket history gives a complete oversight of what steps and the ticket has underrun and which actions were taken. So, the information you're seeking is already there, you just have to keep track of it. If we would save the wanted information the way you want it, we would denormalize the database, as we would store redundant data, which is to be avoided at most costs. At last, a queue name can be up to 200 characters long. Two queue name were 400, then. You get it. Regards, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
participants (2)
-
Paul Rhein
-
Robert Kehl