Re: [otrs] STATS - Ticket closed with SLA Violation

2010-08-30 Thread Leonardo Certuche
We developed it as part of our IT&Libre solution, available in spanish and english as added value to the customers that hire our ITSM consultant services. If you're interested in taking a look at it, please let us know. Leonardo Certuche www.itconsultores.com.co Medellín,

Re: [otrs] STATS - Ticket closed with SLA Violation

2010-08-30 Thread Ruslan
You develop it for own purposes or we can check it and m.b. buy rgis sytem? On 30 авг, 18:24, Leonardo Certuche wrote: > Hello there, > > I'd love to know how but true to be told, we're deploying our own reporter > web-based and with OTRS integrated authentication in which a full set of > report

Re: [otrs] STATS - Ticket closed with SLA Violation

2010-08-30 Thread Leonardo Certuche
Hello there, I'd love to know how but true to be told, we're deploying our own reporter web-based and with OTRS integrated authentication in which a full set of reports based on ITIL PKIs are shown Leonardo Certuche www.itconsultores.com.co Medellín, Colombia On 30 August 2010 03:16, Ruslan w

Re: [otrs] STATS - Ticket closed with SLA Violation

2010-08-30 Thread Ruslan
One more question - How did u getting stats using this new table "sla_times" ? On 27 авг, 18:45, Leonardo Certuche wrote: > Hello Ruslan, > > I'm glad you like it :D > > As you can see it's a workaround tropical-style. If you get the chance to > improve it or to come with a better approach, could

Re: [otrs] STATS - Ticket closed with SLA Violation

2010-08-27 Thread Leonardo Certuche
Hello Ruslan, I'm glad you like it :D As you can see it's a workaround tropical-style. If you get the chance to improve it or to come with a better approach, could you please share it with us? Thanks! Leonardo Certuche www.itconsultores.com.co Medellín, Colombia On 27 August 2010 07:04, Rusl

Re: [otrs] STATS - Ticket closed with SLA Violation

2010-08-27 Thread Ruslan
Praise you Leonardo!!! ))) And nice trick BTW ) I was trying to - rewrite module ) On 25 авг, 23:30, Leonardo Certuche wrote: > Hello, > > I'm also sad of OTRS behavior regarding SLAs. In order to save somewhere > else SLA times before they get reset, we're using the following SQL table > and

Re: [otrs] STATS - Ticket closed with SLA Violation

2010-08-25 Thread Leonardo Certuche
Hello, I'm also sad of OTRS behavior regarding SLAs. In order to save somewhere else SLA times before they get reset, we're using the following SQL table and trigger. I hope it helps and if anyone has as better approach (or if newer version won't reset those times) please let us know here. CREATE

[otrs] STATS - Ticket closed with SLA Violation

2010-08-25 Thread Ruslan
hi every one. I'm trying to create Stat-report with list of tickets closed with SLA violation. But when ticket is closed, it seems that sustem reset "escalation time" - ... I think it's wrong action. Any way - i need to analyze SLA violation in any time period. Anyone have any suggestion?