Re: [otrs] Use of templates

9 Apr 2016

      der sieht dann so aus: ResponseTemplate (1/306824/307048)

Ich hatte mal eine SQL Abfrage dafür gebaut:

   select
         count(sr.name),
         sr.name
   from ticket_history as th, standard_response as sr
   where
         th.name like 'ResponseTemplate%' and
         sr.id = LEFT(TRIM(LEADING 'ResponseTemplate ('
FROMth.name),LOCATE('/',TRIM(LEADING 'ResponseTemplate (' FROM
th.name))-1)
         and DATE_SUB(CURDATE(),INTERVAL 60 DAY) <= th.create_time
   group by
         sr.name
   order by
         sr.id;

In neueren OTRS Versionen ist die Tabelle standard_response umbenannt
worden in standard_template

Cheers

Jens

2016-04-09 9:18 GMT+02:00 Jens Bothe :
...
Hi,
Yes there IS an history entry showing the number of usages
Jens Bothe
Sent from mobile/cell
Am 09.04.2016 um 08:38 schrieb Florian Edlhuber :
Hi Ralf,
08.04.2016 14:58 - Ralf Hildebrandt schrieb:
...
We're having a lot of templates for answers and the like.
Is there any way of finding out how often a template was actively used
by the agents?
In OTRS 3 there was a Add On from OTRS AG available. It was a add on
for the stats. But for the Version 5 I don't know this function or a
add on available.
regards
Florian
---------------------------------------------------------------------
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