Phone Ticket Stats

michaelh81 · Post by **michaelh81** » 18 Sep 2013, 16:14

Hi all,

I'm using OTRS 3.2.9 on a Windows SQL backend.

My question is, how do I create a stat report to show those tickets created via Tickets\New Phone Ticket?

I understand how to create stats etc, but they doesn't seem to be a specific field to restrict to show only those created via the phone method? Has anyone else managed to work this out? Or will I have to resolve to extracting via SQL?

Regards,

Michael

michaelh81 · Post by **michaelh81** » 19 Sep 2013, 17:26

Gone through all the tables in SQL and there doesn't seem to be a flag to say if the ticket is email or phone type - would have thought this is standard but it appears not....

Post by **crythias** » 20 Sep 2013, 13:22

It may be indicated in the first article of the ticket.

michaelh81 · Post by **michaelh81** » 20 Sep 2013, 13:37

Yes - type 5. How do I query this with the built in stats tool?

Post by **crythias** » 20 Sep 2013, 14:42

you cannot without programming

michaelh81 · Post by **michaelh81** » 20 Sep 2013, 14:44

Yes - I thought so. I have created a solution via MS Reporting Services.

Thanks for the info.

Znuny Open Source Ticketsystem

Phone Ticket Stats

Phone Ticket Stats

Re: Phone Ticket Stats

Re: Phone Ticket Stats

Re: Phone Ticket Stats

Re: Phone Ticket Stats

Re: Phone Ticket Stats