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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Milan Koudelka - Internet Mall Sent: Monday, June 30, 2008 10:57 AM To: otrs@otrs.org 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