
Hi, i write some post in my blog about OTRS, including a PHP script for make one report with statics by agent and total of tickets new, open, and pending, i think amazing and is a great help for my company with 200 tickets/day and 5 agents. Only two problems: 1) I write in spanish :-( (my english is not good enough). 2) I make this script for my own use, then, the script need a lot of work to make this usefull for everyone. If any body can help to make a "clean" on code and SQL querys, or translate to english, I will be greatefull. The script make this report: =Statics for 2009-03-24= Total of Input tickets 178 Corporate 27 SOHO 103 Others 48 Total of open tickets 13 Corporate 5 SOHO 5 Others 3 =Name of Agent 1= Tickets answered 17 First and Last respond 08:40:45 - 16:57:13 Tickets without response 7 Tickets without client response 35 =Name of Agent 2= Tickets answered 27 First and Last respond 08:30:25 - 17:30:03 Tickets without response 2 Tickets without client response 43 The all post (in spanish) about otrs are here: http://kuboit.com/tag/otrs -- Gustavo Azambuja - Linux User: 275813 http://www.twitter.com/gazambuja