Subqueue Reports

[eschurke]

I setup qloaderd and asterisk to record a DID as sub-queue and have verified in the database that the info is there.  How do I configure the report though – or the queue for the report?

 

[QueueMetrics]

Did you enable subqueue-rewriting in the qloader script?
Can you post an example of the logs that are recorded for a call?

[eschurke]

Yes we did.  All the entries in qlog_opencalls look like this:

Row ID    partition         call id                  queue      subqueue     
79466       P001  1251317461.24029         993     1111111111

last verb                    lastTst          lastUpd
COMPLETEAGENT  1251317467  2009-08-26 16:11:07

 

Where 1111111111 is the DID number and 993 is the queue number

[QueueMetrics]

Cna yuou post an example of a call from the queue_log table?

[eschurke]

P001   1251836793   1251836607.146249   993.1111111111   SIP/401
COMPLETEAGENT   8   178   1           1

Here you go, thanks!

[QueueMetrics]

Go create a queue which definition is "993.1111111111" and with a name of your choice.
Then you can create a queue like "993.*" tpo report on all subqueues of 993 (BUT they must first exist as individual items).

[eschurke]

I've tried creating a queue named 1111111111 with queue member 993.1111111111 where I've also searched the queue_log db and know there are entries for 993.1111111111 but it always shows 0 calls.  Even when I run a report on last 90 days I get 0 calls.

[QueueMetrics]

are you sure you are accessing the right partition? look on the Licence page.

[eschurke]

Got it!  OK, I didn't have Queuemetrics setup to use the partition.

Thanks!

[QueueMetrics]