Stats - Number of calls / emails before closure

Hi,
You could write an SQL query. All the info you're asking is stored in the
article table. Each entry has the ticket_id (related to the ticket table
where you find the real ticket number - tn), the article_type_id (related to
the article_type table where you find the type of updates), who made it
(a_from), what subject (a_subject), what was wrote (a_body) and when
(create_time)
Take a look at the database schema
ftp://ftp.otrs.org/pub/otrs/misc/otrs-2.4-database.png so you get a better
picture of how all info is stored and related
Leonardo Certuche
On Wed, Feb 3, 2010 at 9:05 PM, Prince Chavez
Hi all,
How can we track the number of updates (notes, phonecalls, emails) on a ticket before it was marked closed?
Thanks in advance! -- Prince Chavez Customer Relations Manager TonerBoss.com 714-482-0377 x 6524 ------------------------------ This message is intended solely for the use of the original addressee(s) and may contain information that is privileged and confidential. Any unauthorized dissemination of this communication is strictly prohibited. If you are not the intended recipient, you are notified that any dissemination of this communication is prohibited.
--------------------------------------------------------------------- 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/
participants (2)
-
Leonardo Certuche
-
Prince Chavez