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/

Reply via email to