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 <prince.cha...@tonerboss.com>wrote: > 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/ >
--------------------------------------------------------------------- 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/
