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