Youll need to run a sql query on the database. This is what we do select tn, title, owner, customer_id, FROM_UNIXTIME(escalation_solution_time) time_completed,create_time, floor((escalation_solution_time-create_time_unix)/86400) as days, (floor((escalation_solution_time-create_time_unix)/3600)-(floor((escalation_solution_time-create_time_unix)/86400)*24)) as hours, (floor((escalation_solution_time-create_time_unix)/60 )-(floor((escalation_solution_time-create_time_unix)/3600)*60)) as minutes, ( (escalation_solution_time-create_time_unix)-(floor((escalation_solution_time-create_time_unix)/60)*60)) as seconds from ticketsview where queuename = 'loyalty' and state = 'Closed successful' and datediff(FROM_UNIXTIME(escalation_solution_time), now()) >= -30 Obviously change the quename to which one you want to check aswell as change the -30 too -7 that would show you the tickets closed in the past 7 days. Regards Willem Gerber BCWINFO wrote:
This is for my boss!
;-)
I tried Search but I couldn't do that.
Any suggestions?
Diego ------------------------------------------------------------------------
_______________________________________________ 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/
-- Avoid the Gates of Hell. Use Linux -- unknown source