Have a look at the ticket_history table. I found out that queries are much easier to make up with this as a basis - and tend to be faster because I don't have to put a select over multiple tables. Also it let's you have a much more detailed view on the actions taken. Greetz, Daniel -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Arnold Ligtvoet Sent: Montag, 14. April 2008 10:00 To: User questions and discussions about OTRS.org Subject: RE: [otrs] User stats Hi,
Hi, Arnold! What exactly do you mean by the "agent activity for period"?
I'm trying to see how busy agents have been. I'd like to see how many tickets an agent handled during a specific period. So in essence a report that shows ticket states per agent over a specific period. Like: Period April 2008 Agent 1 -> closed successful = 15 -> closed unsuccessful = 1 -> open = 12 Agent 2 -> closed successful = 123 And so on Arnold. _______________________________________________ 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 Support or consulting for your OTRS system? =http://www.otrs.com/