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
z,
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 "agen
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:
Peri
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_sta
