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
begin:vcard
fn:Willem Gerber
n:Gerber;Willem
email;internet:[EMAIL PROTECTED]
note;quoted-printable:Destiny Electronic Commerce (Pty) Ltd.=0D=0A=
=0D=0A=
www.e-destiny.co.za=0D=0A=
=0D=0A=
011 695 5500 phone=0D=0A=
086 660 2933 fax
x-mozilla-html:TRUE
version:2.1
end:vcard
_______________________________________________
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/
