On 04/15/2014 08:36 PM, Gerald Young wrote:
MySQL Workbench or phpMyAdmin would be helpful tools for you.
The schema isn't terribly obscure.
For instance, the table named ticket holds ticket data.
Do you know how to write sql queries? (I need a base of understanding --
whether you need
On 04/17/2014 07:30 AM, Gerald Young wrote:
sum(case when t.ticket_lock_id = 1 then 1 else 0 end) as unlocked
select q.name queue, sum(case when t.ticket_lock_id = 1 then 1 else 0 end) as
unlocked, sum(case when t.ticket_lock_id = 2 then 1 else 0 end) as locked from
ticket t left join queue
how many tickets per agent, per queue
SELECT u.login user, sum(case when q.id = 2 then 1 else 0 end) as Raw,
sum(case when q.id = 3 then 1 else 0 end) as Junk, sum(case when q.id = 4
then 1 else 0 end) as Misc FROM `ticket` t left join users u on u.id =
t.user_id left join queue q on q.id =
I suppose you might want to count states per queue, right?
sum(case when q.id = 2 and t.state_id=1 then 1 else 0 end) as RawNew
sum(case when q.id = 2 and t.state_id=4 then 1 else 0 end) as RawOpen
You can do something similar with ticket_state_type instead for types
instead of explicit states.
sorry for the multi-post ... t.ticket_lock_id (underscore, not dash/minus)
On Thu, Apr 17, 2014 at 9:18 AM, Gerald Young cryth...@gmail.com wrote:
I suppose you might want to count states per queue, right?
sum(case when q.id = 2 and t.state_id=1 then 1 else 0 end) as RawNew
sum(case when
I know the basic of doing queries, but I have people on my team that can do
them for me. I just need to know where to find data.
I know phpmyadmin.
2014-04-15 21:36 GMT-03:00 Gerald Young cryth...@gmail.com:
MySQL Workbench or phpMyAdmin would be helpful tools for you.
The schema isn't
Am 16.04.2014 02:36, schrieb Gerald Young:
...
select q.name http://q.name queue, count(t.id http://t.id) number
from ticket t left join queue q on q.id http://q.id=t.queue_id left
join ticket_state ts on ts.id http://ts.id = t.ticket_state_id group
by q.name http://q.name
number of
Hi there,
Once I don't have a graphic dashboard plugin, I'd like to build some
queries on otrs db (mysql) to show the results in Pentaho.
Problem: I don't know in which table data are.
Desired result: A graphic dahsboard that shows:
- how many tickets are in each queue
- how many tickets are