Customizing some of the reports - Where are all the data in the database?

[torontob]

Hello,

I am looking to make a customized graph from the data. I am looking at QM database and all I see is the queue_log table that holds some Asterisk related data.

1- I want to know what each row means and where can I get information like the duration of the call, caller number, how long it rang until it was picked up, who was the slowest to pick up, etc....(I know these reports are available on QM but we have an internal system that take advantage of the data)

2- Was the call for extension 334 waiting for so long to be answered? What do below signify? what is 0 and 1000 in data1? What is heartbeat?

Code: [Select]

"partition";"time_id";"call_id";"queue";"agent";"verb";"data1";"data2";"data3";"data4";"serverid";"unique_row_count"
"P001";"1285843585";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843567";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843566";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843565";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843564";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843563";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843562";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843561";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843560";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843559";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843557";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843556";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843555";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843568";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843569";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843570";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843584";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"1000";"";"";"";"";"1"
"P001";"1285843582";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843581";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843580";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843579";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843578";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843577";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843576";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843575";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843574";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843573";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843572";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843554";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843553";"1285843434.1";"498";"Local/334@from-internal/n";"RINGNOANSWER";"0";"";"";"";"";"1"
"P001";"1285843516";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285829100";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285828199";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285827298";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285826397";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285825496";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285824595";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285823694";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285822793";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285821892";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"
"P001";"1285820991";"NONE";"NONE";"NONE";"HEARTBEAT";NULL;"";"";"";"";"1"

Thanks

[QueueMetrics]

You cannot access the database to find QM data - but you can query QM for its data in a machine-friendly way. See here: http://queuemetrics.com/manuals/QM_XML-RPC_manual-chunked/


It took so long because agent 334 was not answering the phone

[torontob]

Thanks but what does 1000 mean in data2?

Can you explain what data1, data2 and other field are in that queue_log table?

[QueueMetrics]

They are just different parameters - they depend on the environment they are in.

[torontob]

So, they are not consistent. Sometimes they could be a unique ID and the other time a caller ID?

A- What about 1000 that shows up after few rings?
B- And what does "heartbeat" mean?

Thanks

[QueueMetrics]

I can answer (B) -  Heartbeats are records that the qloader sends when there is no other data, so QM knows that a connection is still present.