Hi Milan Try this direct on the mysql prompt:
select su.login, count(*) from ticket as t left join system_user as su on t.user_id = su.id where t.change_time between "2008-04-30 23:59:59" and "2008-05-31 23:59:59" and (t.ticket_state_id = 2 or t.ticket_state_id = 3) group by su.id order by count(*); This will generate a list of all tickets closed (closed + and closed -) in the selected timerange agregated for each agent and sorted. regards, Bruno -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Milan Koudelka - Internet Mall Sent: Monday, June 30, 2008 10:57 AM To: [email protected] Subject: [otrs] report count ticket per person for time period Hello people, I have OTRS 2.2.6 <http://otrs.org/> installed. We want to know how many tickets somebody resolved. We used search with time period for it, but now we are on limit 2000 tickets and I know that it's limit for searching in OTRS. Is there another way how to report count of resolved tickets for time period for each user ? Thank you very much. <http://otrs.org/> -- Milan Koudelka Linux & Network Administrator Internet Mall, a.s. Internet Mall - obchody, které si oblíbíte. http://www.MALL.cz _______________________________________________ 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/
