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 <jens.oliver.bo...@gmail.com>:
> 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 <florian.edlhu...@gmx.de>:
>
> 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
>
>
---------------------------------------------------------------------
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
