OTRS Reporting on Phone, Web and Email Tickets

Moderator: crythias

Locked
retro2707
Znuny advanced
Posts: 131
Joined: 16 Apr 2014, 17:06
Znuny Version: 6.0.12

OTRS Reporting on Phone, Web and Email Tickets

Post by retro2707 »

Hi,

Maybe im just missing something but I cant find a way to report on how many tickets come in by Phone, Web and Email. Is this possible and if so, how do I go about setting it up please?

Brendan
Setup:
OTRS 6.0.12
Hosted on CentOS 7.4/ MySQL - MariaDB (5.5.60)
retro2707
Znuny advanced
Posts: 131
Joined: 16 Apr 2014, 17:06
Znuny Version: 6.0.12

Re: OTRS Reporting on Phone, Web and Email Tickets

Post by retro2707 »

Anything on this? Sounds like a fairly standard request to see where the tickets are coming from.

Thanks a lot!
Setup:
OTRS 6.0.12
Hosted on CentOS 7.4/ MySQL - MariaDB (5.5.60)
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: OTRS Reporting on Phone, Web and Email Tickets

Post by reneeb »

There is no standard report for this, but you can use the SQL box in the admin area... AFAIR there are already some threads in this forum that provide a SQL query for that.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
retro2707
Znuny advanced
Posts: 131
Joined: 16 Apr 2014, 17:06
Znuny Version: 6.0.12

Re: OTRS Reporting on Phone, Web and Email Tickets

Post by retro2707 »

Perfect, thanks reneeb! Will see what I can find.
Setup:
OTRS 6.0.12
Hosted on CentOS 7.4/ MySQL - MariaDB (5.5.60)
Locked