I have written a perl script that does a time until resolution and tracks the number of days a ticket remains open. It could be a great starting point for you to modify and create a report that you are looking for.

Keith

Rabindra Pandey wrote:

<div class="moz-text-flowed" style="font-family: -moz-fixed">Hi,

I am fairly new to otrs world. I want to create a report of all tickets that have been untouched for last 3 days. Untouched is defined as a ticket which have no activity during last 3 days. Any mail sent from OTRS by system is not accounted as activity.

I want create report by writing mysql script and my otrs version is 1.2.3

Any help or guidance will be greatly appreciated.

Thanks

</div>

---------------------------------------------------------------------
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/