Re: [otrs] User stats
Arnold Ligtvoet wrote: 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/ Well, it's a very usefull stat. Would you mind post in maillist a final sql to do this? -- ___ 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/
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/
RE: [otrs] User stats
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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/ ___ 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/
Re: [otrs] User stats
Arnold Ligtvoet wrote: Hi, I'm trying to work out a query that will output the agent activity for a period. I've come up with this query: SELECT DISTINCT ticket.id, ticket.tn, count(ticket.id) as NO,system_user.first_name, system_user.last_name, ticket_state.name FROM ticket JOIN ticket_state ON ticket_state.id=ticket_state_id JOIN system_user ON system_user.id=user_id WHERE ticket.create_time LIKE '%2008-04%' AND ticket_state_id 1 AND ticket.change_by = ticket.user_id GROUP BY user_id,ticket_state.name; When I set it to create_time in the WHERE clause, the numbers look like they are possible, however I'm seeing only tickets that were started in the period that the query runs for and I'd like to see final ticket states. I've tried changing create_time to change_time however this gives me unusual high numbers of tickets. Arnold. BTW: is everybody getting reposts from the mailing list? I see my own posts come back and back? ___ 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/ Hi, Arnold! What exactly do you mean by the "agent activity for period"? -- ___ 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/