QueueMetrics forum

QueueMetrics => QueueMetrics installation => Topic started by: torontob on November 29, 2010, 17:41:40

Title: Customizing some of the reports - Where are all the data in the database?
Post by: torontob on November 29, 2010, 17:41:40: 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
Title: Re: Customizing some of the reports - Where are all the data in the database?
Post by: QueueMetrics on November 30, 2010, 11:37:09: 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 :)
Title: Re: Customizing some of the reports - Where are all the data in the database?
Post by: torontob on November 30, 2010, 16:46:36: Thanks but what does 1000 mean in data2?

Can you explain what data1, data2 and other field are in that queue_log table?
Title: Re: Customizing some of the reports - Where are all the data in the database?
Post by: QueueMetrics on December 01, 2010, 10:56:39: They are just different parameters - they depend on the environment they are in.
Title: Re: Customizing some of the reports - Where are all the data in the database?
Post by: torontob on December 03, 2010, 02:03:30: 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
Title: Re: Customizing some of the reports - Where are all the data in the database?
Post by: QueueMetrics on December 07, 2010, 15:01:27: 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.