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/