
Hi, We're finally moving from our current email system over to OTRS for customer care emails. I have 2 questions and a gift for the group. 1) Is there a way to close a ticket without putting notes in it? We use another system for our order management, and any notes are usually put in there. It's hard getting my customer care team to do any extra steps than what they are used to with our current email system so an option of turning off the mandatory typing of a note would be nice. 2) Is there a way to setup the maximum number of locked tickets that an agent/user can have open at one time? We have 1-2 agents who like to open up as many tickets as they can, leaving nothing for the other members. Thanks in advanced for any help with these questions - thanks also to the many members of the mailing list who are extremely helpful. More thanks to the OTRS dev. Team for such a great product. If it wasn't for OTRS, I would not be learning about MySQL and queries! As for the gift to the group. Here are 4 mysql queries that we've created in house - If we had this type of stuff built into the system's stat area, it would be a better system. I plan on looking at the code to see how I would implement that, but this might be beneficial to the rest of the group who might need this. We have this built into a text file now that a cron job picks up on a daily basis and emails it out to the recipients that I specify in the cron job. If any one is interested in getting the cron job, please let me know. Count of open tickets: select count(*) "# of tickets in backlog" from ticket Count of tickets received yesterday: select count(*) "# of new tickets received yesterday" from ticket WHERE create_time > date_add(NOW(),INTERVAL -1 DAY) Count of tickets closed successfully yesterday: select count(*) "# of tickets closed yesterday" from ticket where ticket_state_id = 2 and change_time > date_add(now(),INTERVAL -1 DAY) Count of tickets closed successfully yesterday by agent: select user_id "Agent",count(*) "# of Tickets closed yesterday" from ticket where ticket_state_id = 2 and change_time > date_add(now(),INTERVAL -1 DAY) group by user_id Count of new tickets received yesterday by queue: select queue_id "Queue", count(*) "# of new tickets received yesterday by subject" from ticket WHERE create_time > date_add(NOW(),INTERVAL -1 DAY) group by queue_id