Hi,<br><br>You could write an SQL query. All the info you&#39;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)<br>

<br>Take a look at the database schema <a href="ftp://ftp.otrs.org/pub/otrs/misc/otrs-2.4-database.png">ftp://ftp.otrs.org/pub/otrs/misc/otrs-2.4-database.png</a> so you get a better picture of how all info is stored and related<br>

<br clear="all">Leonardo Certuche<br>
<br><br><div class="gmail_quote">On Wed, Feb 3, 2010 at 9:05 PM, Prince Chavez <span dir="ltr">&lt;<a href="mailto:prince.chavez@tonerboss.com">prince.chavez@tonerboss.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">





<div bgcolor="#ffffff" text="#000000">
Hi all,<br>
<br>
How can we track the number of updates (notes, phonecalls, emails) on a
ticket before it was marked closed?<br>
<br>
Thanks in advance!<br><font color="#888888">
<div>-- <br>
<div style="width: 420px; font-family: &#39;Tahoma&#39;,sans-serif;"> <span style="font-size: 20px; font-weight: 600; color: steelblue;">Prince
Chavez</span><br>
<div style="color: gray; font-size: 10px;"> Customer Relations Manager <br>
TonerBoss.com<br>
714-482-0377 x 6524
<hr> 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. </div>
</div>
</div>
</font></div>

<br>---------------------------------------------------------------------<br>
OTRS mailing list: otrs - Webpage: <a href="http://otrs.org/" target="_blank">http://otrs.org/</a><br>
Archive: <a href="http://lists.otrs.org/pipermail/otrs" target="_blank">http://lists.otrs.org/pipermail/otrs</a><br>
To unsubscribe: <a href="http://lists.otrs.org/cgi-bin/listinfo/otrs" target="_blank">http://lists.otrs.org/cgi-bin/listinfo/otrs</a><br>
<br>
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!<br>
<a href="http://www.otrs.com/en/support/enterprise-subscription/" target="_blank">http://www.otrs.com/en/support/enterprise-subscription/</a><br></blockquote></div><br>