For any reporting take a look at the ticket_history table. There you find every single action done to a ticket. It's easy to generate plenty of data out of this. Greets, Daniel -----Ursprüngliche Nachricht----- Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Rabindra Pandey Gesendet: Freitag, 27. Februar 2009 16:14 An: User questions and discussions about OTRS. Betreff: [otrs] OTRS Reporting 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 --------------------------------------------------------------------- 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/