Re: [asterisk-users] queue log realtime mysql

2014-11-05 Thread Jonas Kellens

On 04-11-14 11:52, Jonas Kellens wrote:

On 04-11-14 11:50, Ishfaq Malik wrote:


On 4 November 2014 10:40, Jonas Kellens jonas.kell...@telenet.be 
mailto:jonas.kell...@telenet.be wrote:


Hello,

I have 5 Asterisk servers all using mysql realtime to store queue
log information.

There is 1 out of 5 servers which stores the data in 4 columns :
'data1' -- 'data 5'.

All other servers store data in 1 column 'data' with the data
seperated by pipe.

I see no difference in my configuration of extconfig.conf and
logger.conf. Maybe a hidden default value ?

Can someone tell me which setting makes the mysql realtime driver
store data in 1 column or in seperate columns ?

Using Asterisk 1.8.12.2



Kind regards,

Jonas.



Are you using mysql_realtime or odbc with a mysql back end?



Using mysql_realtime, not using odbc.



Hello,

is there any more feedback on this ?

I still haven't found the difference in realtime configuration between 
this 1 server and my 4 other servers.



Kind regards,

Jonas.


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] queue log realtime mysql

2014-11-04 Thread Jonas Kellens

Hello,

I have 5 Asterisk servers all using mysql realtime to store queue log 
information.


There is 1 out of 5 servers which stores the data in 4 columns : 'data1' 
-- 'data 5'.


All other servers store data in 1 column 'data' with the data seperated 
by pipe.


I see no difference in my configuration of extconfig.conf and 
logger.conf. Maybe a hidden default value ?


Can someone tell me which setting makes the mysql realtime driver store 
data in 1 column or in seperate columns ?


Using Asterisk 1.8.12.2



Kind regards,

Jonas.
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue log realtime mysql

2014-11-04 Thread Ishfaq Malik
On 4 November 2014 10:40, Jonas Kellens jonas.kell...@telenet.be wrote:

  Hello,

 I have 5 Asterisk servers all using mysql realtime to store queue log
 information.

 There is 1 out of 5 servers which stores the data in 4 columns : 'data1'
 -- 'data 5'.

 All other servers store data in 1 column 'data' with the data seperated by
 pipe.

 I see no difference in my configuration of extconfig.conf and logger.conf.
 Maybe a hidden default value ?

 Can someone tell me which setting makes the mysql realtime driver store
 data in 1 column or in seperate columns ?

 Using Asterisk 1.8.12.2



 Kind regards,

 Jonas.



Are you using mysql_realtime or odbc with a mysql back end?


-- 

Ishfaq Malik
Department: VOIP Support
Company: Packnet Limited
t: +44 (0)845 004 4994
f: +44 (0)161 660 9825
e: i...@pack-net.co.uk
w: http://www.pack-net.co.uk

Registered Address: PACKNET LIMITED, Duplex 2, Ducie House
37 Ducie Street
Manchester, M1 2JW
COMPANY REG NO. 04920552
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue log realtime mysql

2014-11-04 Thread Jonas Kellens

On 04-11-14 11:50, Ishfaq Malik wrote:


On 4 November 2014 10:40, Jonas Kellens jonas.kell...@telenet.be 
mailto:jonas.kell...@telenet.be wrote:


Hello,

I have 5 Asterisk servers all using mysql realtime to store queue
log information.

There is 1 out of 5 servers which stores the data in 4 columns :
'data1' -- 'data 5'.

All other servers store data in 1 column 'data' with the data
seperated by pipe.

I see no difference in my configuration of extconfig.conf and
logger.conf. Maybe a hidden default value ?

Can someone tell me which setting makes the mysql realtime driver
store data in 1 column or in seperate columns ?

Using Asterisk 1.8.12.2



Kind regards,

Jonas.



Are you using mysql_realtime or odbc with a mysql back end?



Using mysql_realtime, not using odbc.


Kind regards,

Jonas
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] Queue Log in Mysql

2011-06-20 Thread Henrique Fernandes
Sorry, to not answer before!

Thanks a lot, as sun as i am able i will test this setup!

[]'sf.rique


On Fri, Jun 17, 2011 at 4:50 AM, Ishfaq Malik i...@pack-net.co.uk wrote:

 On Thu, 2011-06-16 at 19:12 -0300, Henrique Fernandes wrote:
  It is possible to log queue in mysql without turning on realtime
  asterisk?
 
  Thanks!
 
  []'sf.rique
  --
 Hi

 Yes, you can pick and choose which things you want to use your DB by
 defining them in your extconfig.conf

 so, in extconfig.conf you would need to add
 queue_log=mysql,your-db-name,queue_log

 in res_config_mysql.conf (1.8) or res_mysql.conf (1.4,1.6)
 you would have to put in the connection details for your database

 If you are using 1.8 your table create statement would be
 CREATE TABLE `queue_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `time` char(26) default NULL,
  `callid` varchar(32) NOT NULL default '',
  `queuename` varchar(32) NOT NULL default '',
  `agent` varchar(32) NOT NULL default '',
  `event` varchar(32) NOT NULL default '',
  `data` varchar(100) NOT NULL default '',
  `data1` VARCHAR(100),
  `data2` VARCHAR(100),
  `data3` VARCHAR(100),
  `data4` VARCHAR(100),
  `data5` VARCHAR(100),
  PRIMARY KEY (`id`)
 )ENGINE=InnoDB ;

 Ish

 --
 Ishfaq Malik
 Software Developer
 PackNet Ltd

 Office:   0161 660 3062


 --
 _
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] Queue Log in Mysql

2011-06-17 Thread Ishfaq Malik
On Thu, 2011-06-16 at 19:12 -0300, Henrique Fernandes wrote:
 It is possible to log queue in mysql without turning on realtime
 asterisk?
 
 Thanks!
 
 []'sf.rique 
 --
Hi

Yes, you can pick and choose which things you want to use your DB by
defining them in your extconfig.conf

so, in extconfig.conf you would need to add
queue_log=mysql,your-db-name,queue_log

in res_config_mysql.conf (1.8) or res_mysql.conf (1.4,1.6)
you would have to put in the connection details for your database

If you are using 1.8 your table create statement would be
CREATE TABLE `queue_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `time` char(26) default NULL,
  `callid` varchar(32) NOT NULL default '',
  `queuename` varchar(32) NOT NULL default '',
  `agent` varchar(32) NOT NULL default '',
  `event` varchar(32) NOT NULL default '',
  `data` varchar(100) NOT NULL default '',
  `data1` VARCHAR(100),
  `data2` VARCHAR(100),
  `data3` VARCHAR(100),
  `data4` VARCHAR(100),
  `data5` VARCHAR(100),
  PRIMARY KEY (`id`)
)ENGINE=InnoDB ;

Ish

-- 
Ishfaq Malik
Software Developer
PackNet Ltd

Office:   0161 660 3062


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[asterisk-users] Queue Log in Mysql

2011-06-16 Thread Henrique Fernandes
It is possible to log queue in mysql without turning on realtime asterisk?

Thanks!

[]'sf.rique
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] Queue log in MySQL DB

2011-06-08 Thread Jonas Kellens

Hello list,

I have configured extconfig.conf to save queue log into my MySQL-DB.

I notice however that there is still logging too in 
/var/log/asterisk/queue_log.


How can I disable queue logging into text files ?



Kind regards,
Jonas.
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] Queue log in MySQL DB

2011-06-08 Thread Satish Barot
Set queue_log = no in logger.conf. By default it is set to 'yes'.

[SATISH]

On Wed, Jun 8, 2011 at 12:30 PM, Jonas Kellens jonas.kell...@telenet.bewrote:

  Hello list,

 I have configured extconfig.conf to save queue log into my MySQL-DB.

 I notice however that there is still logging too in
 /var/log/asterisk/queue_log.

 How can I disable queue logging into text files ?



 Kind regards,
 Jonas.

 --
 _
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] Queue log in MySQL DB

2011-06-08 Thread Jonas Kellens

On 06/08/2011 09:10 AM, Satish Barot wrote:


Set queue_log = no in logger.conf. By default it is set to 'yes'.

[SATISH]


Will there then still be queue logging at all ?


Kind regards,
Jonas.

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
  http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] Queue log in MySQL DB

2011-06-08 Thread Satish Barot
Give it a shot and check! :)
Yes you will have your Queue log records in table.
[SATISH]

On Wed, Jun 8, 2011 at 12:46 PM, Jonas Kellens jonas.kell...@telenet.bewrote:

 On 06/08/2011 09:10 AM, Satish Barot wrote:


 Set queue_log = no in logger.conf. By default it is set to 'yes'.

 [SATISH]


 Will there then still be queue logging at all ?



 Kind regards,
 Jonas.

 --
 _
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 New to Asterisk? Join us for a live introductory webinar every Thurs:
  http://www.asterisk.org/hello

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] Queue log on MySQL realtime

2009-03-02 Thread Miguel Molina
Hi all,

I'm experimenting with the MySQL realtime logging of queue log, using 
backports for 1.4. When I configure the logging of queue log as 
realtime, the previous way to save it onto the plain text file stops 
working. Is there a way to make it work both ways, just like the CDR 
works, where you can have several backends and still save the CDR on a 
plain text file? This could be useful to have a backup in case of a 
MySQL malfunction, loss of connection or something. For examples, the 
plain CDR file has been useful to me on some undesired data loss situations.

TIA.

-- 
Ing. Miguel Molina
Grupo de Tecnología
Millenium Phone Center
PBX: (+57 1)6500800 ext. 1201
Fax: (+57 1)6500816
Móvil: (+57)3138873587 


___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[asterisk-users] queue log parser

2009-01-05 Thread David fire
hi
i am integrating asterisk whit an open source CRM or maybe i am integrating
an open source crm whit asterisk any way
the CRM is vtiger, (www.vtiger.com)
i need an opensource queue log parser to put inside the crm agent statics.
i need any parser i can port it to php or to java
if you don't know any parser maybe you can send me a link or a pdf whit info
on how to parse the log.
Thanks
David

-- 
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
()_()signature to help him gain world domination.
___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue log parser

2009-01-05 Thread Ex Vito
On Mon, Jan 5, 2009 at 10:12 PM, David fire ddf...@gmail.com wrote:

 if you don't know any parser maybe you can send me a link or a pdf whit info
 on how to parse the log.


  ...check queuelog.txt under the doc/ directory on the asterisk source
  distribution (apparently, under 1.6 it is queuelog.tex... no more txt ?!)

  Format for each entry is along the lines of

  timestamp | uniquecallid | queuename | event-data-as-per-queuelog.txt

  ...timestamp is in seconds since the epoch (as obtained with: date +%s).
  Also, check the wiki + TFOT... Both should be more than good enough starting
  points. Of course, this can also be useful:

  http://tinyurl.com/9k8r97

  Good luck, :-)
--
  exvito

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[asterisk-users] queue log in mysql

2009-01-04 Thread David fire
hi
i cant find any how to store the queue log in mysql instead of file.
any one can send me a link or a pdf? in voip info i found how to setup a
realtime queue but not to store the log in mysql.

end beyond the storing where i can find a good queue log parser?
it must be opensource because is to integrate in a CRM system (vtiger) wich
is opensource.
 if it isnt in php there is no problem i can port it.

THANKS
David
-- 
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
()_()signature to help him gain world domination.
___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue log in mysql

2009-01-04 Thread Robert Broyles
With regards to storing queue_log data in mysql, it depends on the 
Asterisk service your running.

1.6.x check out the following:
http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL

1.2.x  OR 1.4.x check out the following patch/solution:
http://www.plack.net/index.php/2007/01/07/asterisk_modification_for_queue_logging

Hope that's what you're looking for. Good luck!


David fire wrote:
 hi
 i cant find any how to store the queue log in mysql instead of file.
 any one can send me a link or a pdf? in voip info i found how to setup a 
 realtime queue but not to store the log in mysql.
 
 end beyond the storing where i can find a good queue log parser?
 it must be opensource because is to integrate in a CRM system (vtiger) 
 wich is opensource.
  if it isnt in php there is no problem i can port it.
 
 THANKS
 David


___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] queue log in mysql

2009-01-04 Thread Tilghman Lesher
On Sunday 04 January 2009 14:42:50 David fire wrote:
 i cant find any how to store the queue log in mysql instead of file.
 any one can send me a link or a pdf? in voip info i found how to setup a
 realtime queue but not to store the log in mysql.

The realtime family (in extconfig.conf) is called queue_log.  The table
must contain the following fields:
time integer
callid char(23)
queuename char(80)
agent char(80)
event char(30)
data char(255)

Storage of realtime data for queue_log is only available for version 1.6.0 and
higher.

-- 
Tilghman

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] queue log in mysql

2009-01-04 Thread David fire
thanks

2009/1/4 Robert Broyles rob...@poornam.com

 With regards to storing queue_log data in mysql, it depends on the
 Asterisk service your running.

 1.6.x check out the following:
 http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL

 1.2.x  OR 1.4.x check out the following patch/solution:

 http://www.plack.net/index.php/2007/01/07/asterisk_modification_for_queue_logging

 Hope that's what you're looking for. Good luck!


 David fire wrote:
  hi
  i cant find any how to store the queue log in mysql instead of file.
  any one can send me a link or a pdf? in voip info i found how to setup a
  realtime queue but not to store the log in mysql.
 
  end beyond the storing where i can find a good queue log parser?
  it must be opensource because is to integrate in a CRM system (vtiger)
  wich is opensource.
   if it isnt in php there is no problem i can port it.
 
  THANKS
  David


 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users




-- 
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
()_()signature to help him gain world domination.
___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue log in mysql

2009-01-04 Thread David fire
2009/1/4 Tilghman Lesher tilgh...@mail.jeffandtilghman.com

 On Sunday 04 January 2009 14:42:50 David fire wrote:
  i cant find any how to store the queue log in mysql instead of file.
  any one can send me a link or a pdf? in voip info i found how to setup a
  realtime queue but not to store the log in mysql.

 The realtime family (in extconfig.conf) is called queue_log.  The table
 must contain the following fields:
 time integer
 callid char(23)
 queuename char(80)
 agent char(80)
 event char(30)
 data char(255)

 Storage of realtime data for queue_log is only available for version 1.6.0
 and
 higher.

 --
 Tilghman

 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Thanks

-- 
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
()_()signature to help him gain world domination.
___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] queue log vs. cdr

2008-03-14 Thread Vieri

--- Atis Lezdins [EMAIL PROTECTED] wrote:

 Hmm, didn't knew that queue_log can be written into
 MySQL..

Asterisk 1.6 beta has that through realtime.

But I'm using a custom import script in earlier
Asterisk versions.

 Is callid in queue_log the same uniqueid?

yes.

 You can do
 something like this:
 
 CREATE TEMPORARY TABLE a TYPE=MEMORY select * from
 queue_log where
 queuename =  '4010' and FROM_UNIXTIME(time) between
 2008030800
 and 20080313145900 group by callid;
 
 CREATE TEMPORARY TABLE b TYPE=MEMORY select * from
 cdr where dst =
 4010 and calldate between 2008030800 and
 20080313145900 group by
 uniqueid;
 
 and then compare:
 
 SELECT * FROM a WHERE callid NOT IN (SELECT uniqueid
 FROM b)
 SELECT * FROM b WHERE uniqueid NOT IN (SELECT callid
 FROM a)

Thanks. It seems that the missing records in the cdr
table are due to the fact that the dst field isn't
4010 as expected but the extension to which the call
was transferred by the agent (dcontext indicates
transfer event).
Strange so I guess I'll have to review the dialplan
closely.



  

Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  
http://tools.search.yahoo.com/newsearch/category.php?category=shopping

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[asterisk-users] queue log vs. cdr

2008-03-13 Thread Vieri
Hi,

Surely, I must be overlooking something. If I run the
following SQL queries I don't get the same number of
rows. Is this coherent?

mysql select * from queue_log where queuename =
'4010' and FROM_UNIXTIME(time) between 2008030800
and 20080313145900 group by callid;

357 rows in set (0.01 sec)

mysql select * from cdr where dst = 4010 and calldate
between 2008030800 and 20080313145900 group by
uniqueid;

219 rows in set (0.19 sec)

Thanks!



  

Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  
http://tools.search.yahoo.com/newsearch/category.php?category=shopping

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] queue log vs. cdr

2008-03-13 Thread Atis Lezdins
On 3/13/08, Vieri [EMAIL PROTECTED] wrote:
 Hi,

  Surely, I must be overlooking something. If I run the
  following SQL queries I don't get the same number of
  rows. Is this coherent?

  mysql select * from queue_log where queuename =
  '4010' and FROM_UNIXTIME(time) between 2008030800
  and 20080313145900 group by callid;

  357 rows in set (0.01 sec)

  mysql select * from cdr where dst = 4010 and calldate
  between 2008030800 and 20080313145900 group by
  uniqueid;

  219 rows in set (0.19 sec)

  Thanks!


Hmm, didn't knew that queue_log can be written into MySQL.. that's
something useful for me :)

Is callid in queue_log the same uniqueid? You can do something like this:

CREATE TEMPORARY TABLE a TYPE=MEMORY select * from queue_log where
queuename =  '4010' and FROM_UNIXTIME(time) between 2008030800
and 20080313145900 group by callid;

CREATE TEMPORARY TABLE b TYPE=MEMORY select * from cdr where dst =
4010 and calldate between 2008030800 and 20080313145900 group by
uniqueid;

and then compare:

SELECT * FROM a WHERE callid NOT IN (SELECT uniqueid FROM b)
SELECT * FROM b WHERE uniqueid NOT IN (SELECT callid FROM a)

Regards,
Atis



-- 
Atis Lezdins,
VoIP Project Manager / Developer,
[EMAIL PROTECTED]
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] queue log vs. cdr

2008-03-13 Thread Rob Hillis
Yes it is.

The reason you get more entries in queue_log is that there are several
queue_log events per call - most commonly you get an ENTERQUEUE,
CONNECT and COMPLETECALLER/AGENT for each call.

Vieri wrote:
 Hi,

 Surely, I must be overlooking something. If I run the
 following SQL queries I don't get the same number of
 rows. Is this coherent?

 mysql select * from queue_log where queuename =
 '4010' and FROM_UNIXTIME(time) between 2008030800
 and 20080313145900 group by callid;

 357 rows in set (0.01 sec)

 mysql select * from cdr where dst = 4010 and calldate
 between 2008030800 and 20080313145900 group by
 uniqueid;

 219 rows in set (0.19 sec)

 Thanks!



   
 
 Looking for last minute shopping deals?  
 Find them fast with Yahoo! Search.  
 http://tools.search.yahoo.com/newsearch/category.php?category=shopping

 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
   

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[asterisk-users] Queue log analyser / report

2007-01-11 Thread Andre Courchesne - Consultant

Hi,

 ANyone knows of a fully GPL/OpenSource queue report/analyser project ?

 Asterisk-stat uses Postgres and that's a no go for us + it's not open

 QueueMetrics is not Open at all.

 Any suggestion welcome.

Andre
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Queue - Log if caller disconnects

2006-06-30 Thread Michael Konietzny

Hello List,

i'm wondering if there is any way to get a AGI executed if a caller
disconnects while he is INSIDE the queue application. If so, i would 
like to log the call as missed.


Hope someone can help.

Greetings,
Michael


___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


RE: [Asterisk-Users] Queue - Log if caller disconnects

2006-06-30 Thread Idris AVCI
Asterisk logs very detailed information in /var/log/asterisk/queue_log
file including abandoned calls. You can import this log to mysql with a
simple perl script running periodically.

-Original Message-
From: Michael Konietzny [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 30, 2006 11:44 AM
To: asterisk-users@lists.digium.com
Subject: [Asterisk-Users] Queue - Log if caller disconnects

Hello List,

i'm wondering if there is any way to get a AGI executed if a caller
disconnects while he is INSIDE the queue application. If so, i would 
like to log the call as missed.

Hope someone can help.

Greetings,
 Michael


___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Queue - Log if caller disconnects

2006-06-30 Thread Jordan Novak








I am having the same problem with my IAX clients. I posted
some issues that are causing my remote IAX agents to be disconnected due to
errors in setting up the IAX stream. I have found that calls will abandon when
a dynamic agent is logged into a down phone, the agent obviously cant
logout if they cant call the switch back. The caller seems to be disconnected
when being transferred to an agent that is logged into a down phone. I am using
least recent routing. I had thought that asterisk at very worst would try to
transfer to the agent, see the phone down, timeout on rings or not ring at all,
and then log the agent out. I am definitely missing something or mis-reading my
instructions. Please post your resolution and I will do the same.



Jordan Novak

Communications Technician








___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Queue Log Analyser Build into IPS 0.123

2005-07-17 Thread Thorben Jensen
IPSwitchBoard Version 0.123 - 17 July 2005

* Queue Analysis has been added to IPSwitchBoard.

In order to properly manage ACD queues, it is important to be able to keep 
track of details of call setups and teardowns in much greater detail than 
traditional call detail records provide. In order to support this, extensive 
and detailed tracing of every queued call is stored in the queue log, 
located (by default) in /var/log/asterisk/queue_log. A Queue Log Analyser 
has now been build into IPSwitchBoard. Start IPSwitchBoard and the log file 
is retrieved automatically from Asterisk and there's a lot of reports you 
can enjoy:

1. Answered/unanswered Calls by Date, Hour or Weekday
2. Service Level by Date, Hour or Weekday
3. Agent calls - who received all those calls
4. Unanswered call - detail report with caller ID

If you need any other reports, please drop me an e-mail on [EMAIL PROTECTED]

FREE Download: http://ipswitchboard.thorben.dk



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Queue Log Analyser Build into IPS

2005-07-17 Thread Thorben Jensen
IPSwitchBoard Version 0.123 - 17 July 2005

* Queue Analysis has been added to IPSwitchBoard.
In order to properly manage ACD queues, it is important to be able to keep
track of details of call setups and teardowns in much greater detail than
traditional call detail records provide. In order to support this, extensive
and detailed tracing of every queued call is stored in the queue log,
located (by default) in /var/log/asterisk/queue_log. A Queue Log Analyser
has now been build into IPSwitchBoard. Start IPSwitchBoard and the log file
is retrieved automatically from Asterisk and there's a lot of reports you
can enjoy:

1. Answered/unanswered Calls by Date, Hour or Weekday
2. Service Level by Date, Hour or Weekday
3. Agent calls - who received all those calls
4. Unanswered call - detail report with caller ID

If you need any other reports, please drop me an e-mail on [EMAIL PROTECTED]

FREE Download: http://ipswitchboard.thorben.dk



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Queue Log

2005-07-17 Thread Adam Goryachev
  I'm am writing a small php program to pull some info out of our  
  Asterisk's queue_log.  I'm having trouble figuring out what some of  
  the parameters mean.
  Here's an example:
 
  1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||Ray Balbin 25  
  (716)250-3405
 

1st field is current date/time in unixtime format
2nd field is channels unique-id which is unixtime of when call first
arrived, a . and the PID of the asterisk process which accepted the call
(or something like that).
3rd field is the queue name
I'm not sure what the 4th field is... value of NONE doesn't tell me
much :)

Regards,
Adam

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Queue Log

2005-07-15 Thread William Lloyd

I'm looking for a similar script.  Care to share?

-bill

On 7-Jun-05, at 10:43 AM, Hugo Begglo wrote:


Hello everyone,
This is is my first email to this group.

I'm am writing a small php program to pull some info out of our  
Asterisk's queue_log.  I'm having trouble figuring out what some of  
the parameters mean.

Here's an example:

1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||Ray Balbin 25  
(716)250-3405


I found a doc that tells me about everything from ENTERQUEUE and  
on but nothing on the 4 fields before it.

Can anyone she some light on this ?

Hugo


___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Queue Log

2005-06-09 Thread Hugo Begglo

Thank Brian !

That gave us the last piece we needed.

Regards,
Hugo

Brian Roy wrote:


On 6/7/05, Johann [EMAIL PROTECTED] wrote:
 


Hugo,

   


1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||Ray Balbin 25
(716)250-3405
 



 


2nd column is not really sure...maybe the duration?
   



Asterisk UniqueID of the call. 


-Brian
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


 


___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Queue Log

2005-06-08 Thread Hugo Begglo

Thanks Johann.  - that helps out .

Johann wrote:


Hugo,

1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||Ray Balbin 25 
(716)250-3405



1st column is unixtime stamp for the current date
2nd column is not really sure...maybe the duration?
3rd column is the queue name
4th column is their agent number (or NONE if there isn't one)

--johann
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users



___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Queue Log

2005-06-08 Thread Brian Roy
On 6/7/05, Johann [EMAIL PROTECTED] wrote:
 Hugo,
 
  1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||Ray Balbin 25
  (716)250-3405

 2nd column is not really sure...maybe the duration?

Asterisk UniqueID of the call. 

-Brian
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Queue Log

2005-06-07 Thread Hugo Begglo

Hello everyone,
This is is my first email to this group.

I'm am writing a small php program to pull some info out of our 
Asterisk's queue_log.  I'm having trouble figuring out what some of the 
parameters mean.

Here's an example:

1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||Ray Balbin 25 
(716)250-3405


I found a doc that tells me about everything from ENTERQUEUE and on 
but nothing on the 4 fields before it. 


Can anyone she some light on this ?

Hugo


___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Queue Log

2005-06-07 Thread Johann

Hugo,

1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||Ray Balbin 25 
(716)250-3405


1st column is unixtime stamp for the current date
2nd column is not really sure...maybe the duration?
3rd column is the queue name
4th column is their agent number (or NONE if there isn't one)

--johann
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] queue log analyser?

2005-03-18 Thread Roy Sigurd Karlsbakk
any chance of seeing some code soon?
On Jan 20, 2005, at 12:17, Ben Merrills wrote:
I've not released the source yet, I asked last week on the mailing 
list for people to send me over some example queue_logs, because so 
far I've only been able to test the software against my own.

I have however made a lot of changes to it since last I posted about 
it.

Template engine has been improved
Allows for recursion of a directory of templates
Allows for different output directories (so you can do a daily, weekly 
and monthly all from the same set of templates say)

And quite a few other bits
As soon as I get some sample data that people don't mind the results 
being posted for then I can show it off a bit more. Hope to get some 
sample data soon,

Cheers,
Ben
-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of João 
Amaro
Sent: 20 January 2005 11:08
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] queue log analyser?

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ben Merrills wrote:
| There's a few (open source/free) ones in development. I myself am
| developing one of them.
|
| Ben
|
Hi.
Why not join all the project in just one ?
Actually which queue log analyzers projects are beeing developed ?
Check the mail from Ben Merrills sent to the list 14-10-2004 15:10.
I don't know if he releases the source code, but, from the screenshots
it seems to be a good one.
Jo?o Amaro
- -- Begin Mail
| I've been doing some work on a queue log analyser for a while now,
| getting the basics in place, an example of which you can find at
| the URL below. However, just wondering what information people
| think is most useful in a log analyser?
|
| At present it includes the following features:
|
| # Time periods - specify a period of days from the log which you
| want to generate statistics for (e.g. only the last 14 days) #
| Templating - allows the stats to be inserted into any html/text
| template using specific tags to insert stats. This means you could
| create a number of templates and execute the analyser against them
| to give different information on different pages (quite flexible).
| # Specify start and end dates - similar to the first feature,
| except you can specify a tight period from your log, not just the
| last x number of days # Channels/Agents to names - simple text file
| allows you to specify a name, agent number and a channel - e.g.
| Ben, Agent/1, Sip/ben. This is then used in the output # instead
| of raw data # JPG graphs - includes a custom class to generate line
| graphs of information (e.g. hourly call volumes etc)
|
| What I want to know though is, what output people would like. At
| the moment there is an overview of all queues, which includes:
|
| Total Calls, total connected calls, total abandoned calls, calls
| abandoned within x seconds, calls exited with key press, Average
| hold time, max hold time, average talk time
|
| Agent overview includes: Calls taken, Average talk time
|
| Graph of call volume per hour of the day Graph of call volume per
| day (over the period specified)
|
| Runs under windows (.NET or mono required) or any other OS that
| support .NET/mono (Linux, Mac, BSD etc)
|
| http://muad.xdev.net/Projects/qig/sample.html
|
|
| Not really done anything like this before, so as much input as
| possible would be appreciated.
|
| Cheers,
|
| Ben
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFB75EfJUm/Bor63CERAv/UAKCwiYZ96RLqX0m7Ks9eL1f7iG4IDQCcCWvK
gafg+vLAgQpjl75Hp5y8tug=
=PwR8
-END PGP SIGNATURE-
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] queue log analyser?

2005-03-05 Thread Roy Sigurd Karlsbakk
I've not released the source yet, I asked last week on the mailing 
list for people to send me over some example queue_logs, because so 
far I've only been able to test the software against my own.

I have however made a lot of changes to it since last I posted about 
it.
How is the progress on this? Could I have a look, please?
roy
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] queue log analyser?

2005-01-26 Thread Roy Sigurd Karlsbakk
hi
could I have a look at this?
I really need it, urgently, so please..
roy
On Jan 20, 2005, at 12:17, Ben Merrills wrote:
I've not released the source yet, I asked last week on the mailing 
list for people to send me over some example queue_logs, because so 
far I've only been able to test the software against my own.

I have however made a lot of changes to it since last I posted about 
it.

Template engine has been improved
Allows for recursion of a directory of templates
Allows for different output directories (so you can do a daily, weekly 
and monthly all from the same set of templates say)

And quite a few other bits
As soon as I get some sample data that people don't mind the results 
being posted for then I can show it off a bit more. Hope to get some 
sample data soon,

Cheers,
Ben
-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of João 
Amaro
Sent: 20 January 2005 11:08
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] queue log analyser?

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ben Merrills wrote:
| There's a few (open source/free) ones in development. I myself am
| developing one of them.
|
| Ben
|
Hi.
Why not join all the project in just one ?
Actually which queue log analyzers projects are beeing developed ?
Check the mail from Ben Merrills sent to the list 14-10-2004 15:10.
I don't know if he releases the source code, but, from the screenshots
it seems to be a good one.
Jo?o Amaro
- -- Begin Mail
| I've been doing some work on a queue log analyser for a while now,
| getting the basics in place, an example of which you can find at
| the URL below. However, just wondering what information people
| think is most useful in a log analyser?
|
| At present it includes the following features:
|
| # Time periods - specify a period of days from the log which you
| want to generate statistics for (e.g. only the last 14 days) #
| Templating - allows the stats to be inserted into any html/text
| template using specific tags to insert stats. This means you could
| create a number of templates and execute the analyser against them
| to give different information on different pages (quite flexible).
| # Specify start and end dates - similar to the first feature,
| except you can specify a tight period from your log, not just the
| last x number of days # Channels/Agents to names - simple text file
| allows you to specify a name, agent number and a channel - e.g.
| Ben, Agent/1, Sip/ben. This is then used in the output # instead
| of raw data # JPG graphs - includes a custom class to generate line
| graphs of information (e.g. hourly call volumes etc)
|
| What I want to know though is, what output people would like. At
| the moment there is an overview of all queues, which includes:
|
| Total Calls, total connected calls, total abandoned calls, calls
| abandoned within x seconds, calls exited with key press, Average
| hold time, max hold time, average talk time
|
| Agent overview includes: Calls taken, Average talk time
|
| Graph of call volume per hour of the day Graph of call volume per
| day (over the period specified)
|
| Runs under windows (.NET or mono required) or any other OS that
| support .NET/mono (Linux, Mac, BSD etc)
|
| http://muad.xdev.net/Projects/qig/sample.html
|
|
| Not really done anything like this before, so as much input as
| possible would be appreciated.
|
| Cheers,
|
| Ben
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFB75EfJUm/Bor63CERAv/UAKCwiYZ96RLqX0m7Ks9eL1f7iG4IDQCcCWvK
gafg+vLAgQpjl75Hp5y8tug=
=PwR8
-END PGP SIGNATURE-
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] queue log analyser?

2005-01-20 Thread João Amaro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ben Merrills wrote:
| There's a few (open source/free) ones in development. I myself am
| developing one of them.
|
| Ben
|
Hi.
Why not join all the project in just one ?
Actually which queue log analyzers projects are beeing developed ?
Check the mail from Ben Merrills sent to the list 14-10-2004 15:10.
I don't know if he releases the source code, but, from the screenshots
it seems to be a good one.
Jo?o Amaro
- -- Begin Mail
| I've been doing some work on a queue log analyser for a while now,
| getting the basics in place, an example of which you can find at
| the URL below. However, just wondering what information people
| think is most useful in a log analyser?
|
| At present it includes the following features:
|
| # Time periods - specify a period of days from the log which you
| want to generate statistics for (e.g. only the last 14 days) #
| Templating - allows the stats to be inserted into any html/text
| template using specific tags to insert stats. This means you could
| create a number of templates and execute the analyser against them
| to give different information on different pages (quite flexible).
| # Specify start and end dates - similar to the first feature,
| except you can specify a tight period from your log, not just the
| last x number of days # Channels/Agents to names - simple text file
| allows you to specify a name, agent number and a channel - e.g.
| Ben, Agent/1, Sip/ben. This is then used in the output # instead
| of raw data # JPG graphs - includes a custom class to generate line
| graphs of information (e.g. hourly call volumes etc)
|
| What I want to know though is, what output people would like. At
| the moment there is an overview of all queues, which includes:
|
| Total Calls, total connected calls, total abandoned calls, calls
| abandoned within x seconds, calls exited with key press, Average
| hold time, max hold time, average talk time
|
| Agent overview includes: Calls taken, Average talk time
|
| Graph of call volume per hour of the day Graph of call volume per
| day (over the period specified)
|
| Runs under windows (.NET or mono required) or any other OS that
| support .NET/mono (Linux, Mac, BSD etc)
|
| http://muad.xdev.net/Projects/qig/sample.html
|
|
| Not really done anything like this before, so as much input as
| possible would be appreciated.
|
| Cheers,
|
| Ben
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFB75EfJUm/Bor63CERAv/UAKCwiYZ96RLqX0m7Ks9eL1f7iG4IDQCcCWvK
gafg+vLAgQpjl75Hp5y8tug=
=PwR8
-END PGP SIGNATURE-
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


RE: [Asterisk-Users] queue log analyser?

2005-01-20 Thread Ben Merrills
I've not released the source yet, I asked last week on the mailing list for 
people to send me over some example queue_logs, because so far I've only been 
able to test the software against my own.

I have however made a lot of changes to it since last I posted about it. 

Template engine has been improved
Allows for recursion of a directory of templates
Allows for different output directories (so you can do a daily, weekly and 
monthly all from the same set of templates say)

And quite a few other bits

As soon as I get some sample data that people don't mind the results being 
posted for then I can show it off a bit more. Hope to get some sample data soon,

Cheers,

Ben

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of João Amaro
Sent: 20 January 2005 11:08
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] queue log analyser?

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Ben Merrills wrote:

| There's a few (open source/free) ones in development. I myself am
| developing one of them.
|
| Ben
|
Hi.

Why not join all the project in just one ?
Actually which queue log analyzers projects are beeing developed ?


Check the mail from Ben Merrills sent to the list 14-10-2004 15:10.
I don't know if he releases the source code, but, from the screenshots
it seems to be a good one.

Jo?o Amaro


- -- Begin Mail

| I've been doing some work on a queue log analyser for a while now,
| getting the basics in place, an example of which you can find at
| the URL below. However, just wondering what information people
| think is most useful in a log analyser?
|
| At present it includes the following features:
|
| # Time periods - specify a period of days from the log which you
| want to generate statistics for (e.g. only the last 14 days) #
| Templating - allows the stats to be inserted into any html/text
| template using specific tags to insert stats. This means you could
| create a number of templates and execute the analyser against them
| to give different information on different pages (quite flexible).
| # Specify start and end dates - similar to the first feature,
| except you can specify a tight period from your log, not just the
| last x number of days # Channels/Agents to names - simple text file
| allows you to specify a name, agent number and a channel - e.g.
| Ben, Agent/1, Sip/ben. This is then used in the output # instead
| of raw data # JPG graphs - includes a custom class to generate line
| graphs of information (e.g. hourly call volumes etc)
|
| What I want to know though is, what output people would like. At
| the moment there is an overview of all queues, which includes:
|
| Total Calls, total connected calls, total abandoned calls, calls
| abandoned within x seconds, calls exited with key press, Average
| hold time, max hold time, average talk time
|
| Agent overview includes: Calls taken, Average talk time
|
| Graph of call volume per hour of the day Graph of call volume per
| day (over the period specified)
|
| Runs under windows (.NET or mono required) or any other OS that
| support .NET/mono (Linux, Mac, BSD etc)
|
| http://muad.xdev.net/Projects/qig/sample.html
|
|
| Not really done anything like this before, so as much input as
| possible would be appreciated.
|
| Cheers,
|
| Ben


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFB75EfJUm/Bor63CERAv/UAKCwiYZ96RLqX0m7Ks9eL1f7iG4IDQCcCWvK
gafg+vLAgQpjl75Hp5y8tug=
=PwR8
-END PGP SIGNATURE-

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] queue log analyser?

2005-01-19 Thread Roy Sigurd Karlsbakk
hi
I really want a good queue_log analyser, but I don't want to waste   
EUR 1000 for something like that, so I thought starting a small project  
for it. I started off in php just creating a basic parser for the log,  
and I'll go on extending it. See  
http://karlsbakk.net/asterisk/scripts/queue_log_analyser-0.0.1- 
pre1.php.txt

Does anyone want to join this effort?
roy
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


RE: [Asterisk-Users] queue log analyser?

2005-01-19 Thread Ben Merrills
There's a few (open source/free) ones in development. I myself am
developing one of them.

Ben

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roy Sigurd
Karlsbakk
Sent: 19 January 2005 15:33
To: asterisk-users@lists.digium.com
Subject: [Asterisk-Users] queue log analyser?

hi

I really want a good queue_log analyser, but I don't want to waste   
EUR 1000 for something like that, so I thought starting a small project

for it. I started off in php just creating a basic parser for the log,  
and I'll go on extending it. See  
http://karlsbakk.net/asterisk/scripts/queue_log_analyser-0.0.1- 
pre1.php.txt

Does anyone want to join this effort?

roy

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] queue log analyser?

2005-01-19 Thread Roy Sigurd Karlsbakk
Where can I find this?
På 19. jan. 2005 kl. 16.39 skrev Ben Merrills:
There's a few (open source/free) ones in development. I myself am
developing one of them.
Ben
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roy 
Sigurd
Karlsbakk
Sent: 19 January 2005 15:33
To: asterisk-users@lists.digium.com
Subject: [Asterisk-Users] queue log analyser?

hi
I really want a good queue_log analyser, but I don't want to waste 
EUR 1000 for something like that, so I thought starting a small project
for it. I started off in php just creating a basic parser for the log,
and I'll go on extending it. See
http://karlsbakk.net/asterisk/scripts/queue_log_analyser-0.0.1-
pre1.php.txt
Does anyone want to join this effort?
roy
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Queue Log Parser

2005-01-13 Thread Ben Merrills
I don't know if anyone noticed my post a few months ago on the
asterisk-user mailing list, but I've been writing a queue log parser. I
was wondering if anyone had any queue_logs (the bigger the better) that
I would use as sample data? I would of course be willing to post the
stats up for the people who send me their sample logs.

Post them to me off list, and please tell me if you are willing to have
your data posted (in stat form) for demo purposes.

Ben
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Queue Log Parser

2005-01-13 Thread Matthew Boehm
I am currently working on a bounty to have queue_logs written directly to
database. It will become open source once finished.

-Matthew
- Original Message - 
From: Ben Merrills [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Thursday, January 13, 2005 10:03 AM
Subject: [Asterisk-Users] Queue Log Parser


I don't know if anyone noticed my post a few months ago on the
asterisk-user mailing list, but I've been writing a queue log parser. I
was wondering if anyone had any queue_logs (the bigger the better) that
I would use as sample data? I would of course be willing to post the
stats up for the people who send me their sample logs.

Post them to me off list, and please tell me if you are willing to have
your data posted (in stat form) for demo purposes.

Ben
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Queue Log Parser

2005-01-13 Thread AJ Grinnell
On Thu, 13 Jan 2005 11:10:07 -0600, Matthew Boehm [EMAIL PROTECTED] wrote:
 I am currently working on a bounty to have queue_logs written directly to
 database. It will become open source once finished.
 
 -Matthew
 - Original Message -
 From: Ben Merrills [EMAIL PROTECTED]
 To: Asterisk Users Mailing List - Non-Commercial Discussion
 asterisk-users@lists.digium.com
 Sent: Thursday, January 13, 2005 10:03 AM
 Subject: [Asterisk-Users] Queue Log Parser
 
 I don't know if anyone noticed my post a few months ago on the
 asterisk-user mailing list, but I've been writing a queue log parser. I
 was wondering if anyone had any queue_logs (the bigger the better) that
 I would use as sample data? I would of course be willing to post the
 stats up for the people who send me their sample logs.
 
 Post them to me off list, and please tell me if you are willing to have
 your data posted (in stat form) for demo purposes.
 
 Ben

You will be my hero if you do this!
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users