Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - msharpe

Pages: [1]
1
Problems / Re: Custom report error with time range
« on: July 21, 2009, 23:35:08 »
Many thanks
Regards
Mal

2
Problems / Custom report error with time range
« on: July 21, 2009, 01:09:30 »
Hi I am currently using Loway QueueMetrics - 1.5.3 and when we run a custom report where we want to say show calls between 1600 and 1800 hrs for any date range longer than 1 day it shows the calls within times for first day and then goes to all calls for other days. Regards Mal

3
QueueMetrics news / Re: QueueMetrics 1.4.4 released today
« on: May 20, 2008, 03:41:20 »
Hi have upgraded all went fine however now we seem to have issue with licence saying not enough agents when try to run reports. We are licenced for 20 agents. I notice if I go to storage info and press info the number of agents is large as it seems to add an agent for each outbound call as we are using outbound. I have shown a little below. The first twelve records are real agents. The ones below that are where it is adding a agent record with each outbound call. This has been happening for a long while but now with new version it errors when trying to run report if greater than couple of days.

Regards
Mal

101 55   2008-03-10 03:35    2008-05-19 05:04  70,0 days 
102 22   2007-11-30 11:27    2008-05-12 05:19  164,3 days 
103 36   2008-03-08 03:20    2008-05-19 05:55  72,3 days 
104 55   2008-03-10 03:00    2008-05-19 05:00  70,0 days 
105 55   2008-03-10 03:28    2008-05-19 05:58  70,4 days 
106 14   2008-04-22 04:16    2008-05-16 05:01  24,3 days 
6811 2   2008-05-11 05:33    2008-05-11 05:33  0,0 days 
701 1   2007-12-10 12:29    2007-12-10 12:29  0,0 days 
801 48   2007-12-20 12:27    2008-03-07 03:03  78,1 days 
802 37   2007-12-20 12:41    2008-03-06 03:54  77,0 days 
803 61   2007-12-20 12:09    2008-03-07 03:02  78,0 days 
804 66   2007-12-20 12:55    2008-03-06 03:41  76,7 days 
Agent/ 359   2007-12-28 12:23    2008-05-19 05:53  142,9 days 
Agent/011563000 3   2007-12-22 12:04    2007-12-22 12:04  0,0 days 
Agent/0242332420 2   2008-03-29 03:40    2008-03-29 03:52  0,0 days 
Agent/0242974571 3   2008-05-06 05:06    2008-05-06 05:07  0,0 days 
Agent/0243428774 6   2007-12-20 12:49    2007-12-21 12:44  1,2 days 
Agent/0243449500 3   2008-05-08 05:49    2008-05-08 05:50  0,0 days 
Agent/0243561254 3   2008-03-17 03:36    2008-03-17 03:38  0,0 days 
Agent/0244030348 3   2008-04-24 04:10    2008-04-24 04:11  0,0 days 
Agent/0247330899 3   2008-05-02 05:46    2008-05-02 05:47  0,0 days 
Agent/0247393210 3   2008-05-06 05:03    2008-05-06 05:06  0,0 days 
Agent/0249304240 3   2008-04-11 04:26    2008-04-11 04:00  0,0 days 
Agent/0260596182 3   2008-03-17 03:54    2008-03-17 03:55  0,0 days 
Agent/0262956669 3   2008-04-10 04:49    2008-04-10 04:57  0,0 days 
Agent/0265504116 3   2008-05-01 05:39    2008-05-01 05:41  0,0 days 

4
Many thanks I will give it a go
Regards
Mal

5
Hi. I have all working very well except for one small issue. We use Hotdesks so different agent logs on to the same extn at different times of day. To do theis agent numbers do not match the extn. ie extn 6811 might have agent 701, 702, 703 use it during the day.
This works perfect for inbound calls.
However on outbound the queuedial tells it to
exten => _XXX.,3,SetVar(MY_AGENT=${CALLERIDNUM})

This logs the call with

1210461473|asterisk-2599-1210461473.31|q-777|NONE|ENTERQUEUE|-|0405001763
1210461473|asterisk-2599-1210461473.31|q-777|Agent/6811|CONNECT|0|
1210461481|asterisk-2599-1210461473.31|q-777|Agent/6811|CONNECT|8|
1210461487|asterisk-2599-1210461473.31|q-777|Agent/6811|COMPLETEAGENT|8|6
1210461487|asterisk-2599-1210461473.31|q-777||COMPLETECALLER|0|6

As can be seen Agent is extn number as is calleridnum.

This shows the call correctly in Real Time Monitor as Calls being Processed.
However it also Logs in the extn so under
Real time Monitor - Agents Logged In  you will see a new entry for Agent 6811.
This also means reports so under extn for outbounds when they could be different agents.


Is it possible to amend this so that instead of agent = calleridnum
we pck up the agent logged on to that extn and use that.

Hope you can help
Regards
Mal

6
Many Many thanks
That works wonderfully.
You have made my day. Hope you have a great week.
Regards
Mal

7
Hi Many thanks for code. Please find trace.
Regards
Mal

A party Hangs up first

voip1*CLI>
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on 'SIP/6811-08da0f38' in

macro 'dialout-trunk'
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on 'SIP/6811-08da0f38'
    -- Executing Macro("SIP/6811-08da0f38", "hangupcall|") in new stack
    -- Executing ResetCDR("SIP/6811-08da0f38", "w") in new stack
    -- Hungup 'Zap/1-1'
    -- Executing NoCDR("SIP/6811-08da0f38", "") in new stack
    -- Executing GotoIf("SIP/6811-08da0f38", "1?skiprg") in new stack
    -- Goto (macro-hangupcall,s,6)
    -- Executing GotoIf("SIP/6811-08da0f38", "1?skipblkvm") in new stack
    -- Goto (macro-hangupcall,s,9)
    -- Executing GotoIf("SIP/6811-08da0f38", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,11)
    -- Executing Hangup("SIP/6811-08da0f38", "") in new stack
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/6811-08da0f38' in

macro 'hangupcall'
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/6811-08da0f38'
  == End MixMonitor Recording SIP/6811-08da0f38
    -- AGI Script queueDial.agi completed, returning 0
    -- Executing NoOp("Local/7770405001763@isdndial-c1c8,2", " "Trapped -> lowercase h" ")

in new stack
  == End MixMonitor Recording Local/7770405001763@isdndial-c1c8,2
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on 'SIP/6811-08da0f38' in

macro 'dialout-trunk'
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on 'SIP/6811-08da0f38'
    -- Executing Macro("SIP/6811-08da0f38", "hangupcall|") in new stack
    -- Executing ResetCDR("SIP/6811-08da0f38", "w") in new stack
    -- Hungup 'Zap/1-1'
    -- Executing NoCDR("SIP/6811-08da0f38", "") in new stack
    -- Executing GotoIf("SIP/6811-08da0f38", "1?skiprg") in new stack
    -- Goto (macro-hangupcall,s,6)
    -- Executing GotoIf("SIP/6811-08da0f38", "1?skipblkvm") in new stack
    -- Goto (macro-hangupcall,s,9)
    -- Executing GotoIf("SIP/6811-08da0f38", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,11)
    -- Executing Hangup("SIP/6811-08da0f38", "") in new stack
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/6811-08da0f38' in

macro 'hangupcall'
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/6811-08da0f38'
  == End MixMonitor Recording SIP/6811-08da0f38
    -- AGI Script queueDial.agi completed, returning 0
    -- Executing NoOp("Local/7770405001763@isdndial-c1c8,2", " "Trapped -> lowercase h" ")

in new stack
  == End MixMonitor Recording Local/7770405001763@isdndial-c1c8,2
    -- Channel 0/1, span 1 received AOC-E charging 0 units
    -- Channel 0/1, span 1 received AOC-E charging 0 units
voip1*CLI>



***************************************************************************

B Party Hangs up first

voip1*CLI>
    -- Saved useragent "IP SIP Phone/2.2.22" for peer 6805
    -- Saved useragent "IP SIP Phone/2.2.22" for peer 6805
    -- Channel 0/1, span 1 got hangup request, cause 16
    -- Channel 0/1, span 1 received AOC-E charging 0 units
    -- Channel 0/1, span 1 got hangup request, cause 16
    -- Channel 0/1, span 1 received AOC-E charging 0 units
    -- Hungup 'Zap/1-1'
    -- Hungup 'Zap/1-1'
    -- AGI Script queueDial.agi completed, returning 0
    -- Executing Congestion("Local/7770405001763@isdndial-7dc5,2", "") in new stack
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on 'SIP/6811-08da0f38' in

macro 'dialout-trunk'
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on 'SIP/6811-08da0f38'
    -- Executing Macro("SIP/6811-08da0f38", "hangupcall|") in new stack
    -- Executing ResetCDR("SIP/6811-08da0f38", "w") in new stack
  == Spawn extension (isdndial, 7770405001763, 7) exited non-zero on

'Local/7770405001763@isdndial-7dc5,2'
    -- Executing NoOp("Local/7770405001763@isdndial-7dc5,2", " "Trapped -> lowercase h" ")

in new stack
  == End MixMonitor Recording Local/7770405001763@isdndial-7dc5,2
    -- AGI Script queueDial.agi completed, returning 0
    -- Executing Congestion("Local/7770405001763@isdndial-7dc5,2", "") in new stack
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on 'SIP/6811-08da0f38' in

macro 'dialout-trunk'
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on 'SIP/6811-08da0f38'
    -- Executing Macro("SIP/6811-08da0f38", "hangupcall|") in new stack
    -- Executing ResetCDR("SIP/6811-08da0f38", "w") in new stack
  == Spawn extension (isdndial, 7770405001763, 7) exited non-zero on

'Local/7770405001763@isdndial-7dc5,2'
    -- Executing NoOp("Local/7770405001763@isdndial-7dc5,2", " "Trapped -> lowercase h" ")

in new stack
  == End MixMonitor Recording Local/7770405001763@isdndial-7dc5,2
    -- Executing NoCDR("SIP/6811-08da0f38", "") in new stack
    -- Executing GotoIf("SIP/6811-08da0f38", "1?skiprg") in new stack
    -- Goto (macro-hangupcall,s,6)
    -- Executing GotoIf("SIP/6811-08da0f38", "1?skipblkvm") in new stack
    -- Goto (macro-hangupcall,s,9)
    -- Executing GotoIf("SIP/6811-08da0f38", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,11)
    -- Executing Hangup("SIP/6811-08da0f38", "") in new stack
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/6811-08da0f38' in

macro 'hangupcall'
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/6811-08da0f38'
  == End MixMonitor Recording SIP/6811-08da0f38
    -- Executing NoCDR("SIP/6811-08da0f38", "") in new stack
    -- Executing GotoIf("SIP/6811-08da0f38", "1?skiprg") in new stack
    -- Goto (macro-hangupcall,s,6)
    -- Executing GotoIf("SIP/6811-08da0f38", "1?skipblkvm") in new stack
    -- Goto (macro-hangupcall,s,9)
    -- Executing GotoIf("SIP/6811-08da0f38", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,11)
    -- Executing Hangup("SIP/6811-08da0f38", "") in new stack
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/6811-08da0f38' in

macro 'hangupcall'
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on 'SIP/6811-08da0f38'
  == End MixMonitor Recording SIP/6811-08da0f38
voip1*CLI>

*****************************************


8
Hi thanks for your help. I am really sorry as I am not a expert on this, but I must say I have no idea what you mean. Could you be kind enough to give me an example.  We are a company and have paid for licences so would really like to fix this. I have tried re-install on 3 test machines and still same issue. Regards

9
Hi Not sure what you mean by  "h target in your dialplan". Can you explain for me, will be greatly appreciated. Regards Mal

10
Please find and thanks for feeback.

A Party Hangs up first


    -- Executing AGI("SIP/105-09f40e00", "fixlocalprefix") in new stack
    -- Launched AGI Script /var/lib/asterisk/agi-bin/fixlocalprefix
  == Begin MixMonitor Recording SIP/105-09f40e00
       >  fixlocalprefix: Using pattern 777+XXXXXXXX
  ==  fixlocalprefix: Dialpattern 777+XXXXXXXX matched. 94674000 -> 77794674000
    -- AGI Script fixlocalprefix completed, returning 0
    -- Executing Set("SIP/105-09f40e00", "OUTNUM=77794674000") in new stack
    -- Executing Set("SIP/105-09f40e00", "custom=AMP") in new stack
    -- Executing GotoIf("SIP/105-09f40e00", "1?gocall") in new stack
    -- Goto (macro-dialout-trunk,s,17)
    -- Executing Macro("SIP/105-09f40e00", "dialout-trunk-predial-hook|") in new

stack
    -- Executing GotoIf("SIP/105-09f40e00", "0?bypass|1") in new stack
    -- Executing GotoIf("SIP/105-09f40e00", "1?customtrunk") in new stack
    -- Goto (macro-dialout-trunk,s,22)
    -- Executing Set("SIP/105-09f40e00", "pre_num=AMP:Local/") in new stack
    -- Executing Set("SIP/105-09f40e00", "the_num=OUTNUM") in new stack
    -- Executing Set("SIP/105-09f40e00", "post_num=@queuedial/n") in new stack
    -- Executing GotoIf("SIP/105-09f40e00", "1?outnum:skipoutnum") in new stack
    -- Goto (macro-dialout-trunk,s,26)
    -- Executing Set("SIP/105-09f40e00", "the_num=77794674000") in new stack
    -- Executing Dial("SIP/105-09f40e00", "Local/77794674000@queuedial/n|300|") in

new stack
    -- Called 77794674000@queuedial/n
    -- Executing SetVar("Local/77794674000@queuedial-a680,2", "MY_QUE=777") in new

stack
    -- Executing SetVar("Local/77794674000@queuedial-a680,2", "MY_NUM=94674000") in

new stack
    -- Executing SetVar("Local/77794674000@queuedial-a680,2", "MY_AGENT=105") in

new stack
    -- Executing NoOp("Local/77794674000@queuedial-a680,2", "Ag: 105 N: 94674000 Q:

777") in new stack
    -- Executing MixMonitor("Local/77794674000@queuedial-a680,2",

"Q-777-1209679706.31.wav|b|") in new stack
    -- Executing DeadAGI("Local/77794674000@queuedial-a680,2",

"queueDial.agi|94674000|SIP/MHOUSESYD/94674000|q-777|Agent/105") in new stack
    -- Launched AGI Script /var/lib/asterisk/agi-bin/queueDial.agi
  == Begin MixMonitor Recording Local/77794674000@queuedial-a680,2
    -- AGI Script Executing Application: (dial) Options:

(SIP/MHOUSESYD/94674000||g)
    -- Called MHOUSESYD/94674000
    -- SIP/MHOUSESYD-09fe6058 is making progress passing it to

Local/77794674000@queuedial-a680,2
    -- Local/77794674000@queuedial-a680,1 is making progress passing it to

SIP/105-09f40e00
    -- SIP/MHOUSESYD-09fe6058 is ringing
    -- Local/77794674000@queuedial-a680,1 is ringing
    -- SIP/MHOUSESYD-09fe6058 answered Local/77794674000@queuedial-a680,2
    -- Local/77794674000@queuedial-a680,1 stopped sounds
    -- Local/77794674000@queuedial-a680,1 answered SIP/105-09f40e00
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on

'SIP/105-09f40e00' in macro 'dialout-trunk'
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on

'SIP/105-09f40e00'
    -- Executing Macro("SIP/105-09f40e00", "hangupcall|") in new stack
    -- Executing ResetCDR("SIP/105-09f40e00", "w") in new stack
  == Spawn extension (queuedial, 77794674000, 6) exited non-zero on

'Local/77794674000@queuedial-a680,2'
  == End MixMonitor Recording Local/77794674000@queuedial-a680,2
    -- Executing NoCDR("SIP/105-09f40e00", "") in new stack
    -- Executing GotoIf("SIP/105-09f40e00", "1?skiprg") in new stack
    -- Goto (macro-hangupcall,s,6)
    -- Executing GotoIf("SIP/105-09f40e00", "1?skipblkvm") in new stack
    -- Goto (macro-hangupcall,s,9)
    -- Executing GotoIf("SIP/105-09f40e00", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,11)
    -- Executing Hangup("SIP/105-09f40e00", "") in new stack
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on

'SIP/105-09f40e00' in macro 'hangupcall'
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on

'SIP/105-09f40e00'
  == End MixMonitor Recording SIP/105-09f40e00
sip5*CLI>

************************************************************************
B party hangs up first (Good)



   -- AGI Script queueDial.agi completed, returning 0
    -- Executing Congestion("Local/77794674000@queuedial-4dd2,2", "") in new stack
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on

'SIP/105-09f40e00' in macro 'dialout-trunk'
  == Spawn extension (macro-dialout-trunk, s, 27) exited non-zero on

'SIP/105-09f40e00'
    -- Executing Macro("SIP/105-09f40e00", "hangupcall|") in new stack
    -- Executing ResetCDR("SIP/105-09f40e00", "w") in new stack
  == Spawn extension (queuedial, 77794674000, 7) exited non-zero on

'Local/77794674000@queuedial-4dd2,2'
  == End MixMonitor Recording Local/77794674000@queuedial-4dd2,2
    -- Executing NoCDR("SIP/105-09f40e00", "") in new stack
    -- Executing GotoIf("SIP/105-09f40e00", "1?skiprg") in new stack
    -- Goto (macro-hangupcall,s,6)
    -- Executing GotoIf("SIP/105-09f40e00", "1?skipblkvm") in new stack
    -- Goto (macro-hangupcall,s,9)
    -- Executing GotoIf("SIP/105-09f40e00", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,11)
    -- Executing Hangup("SIP/105-09f40e00", "") in new stack
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on

'SIP/105-09f40e00' in macro 'hangupcall'
  == Spawn extension (macro-hangupcall, s, 11) exited non-zero on

'SIP/105-09f40e00'
  == End MixMonitor Recording SIP/105-09f40e00
sip5*CLI>

***************************************************************
Seems like this line is missing.

-- AGI Script queueDial.agi completed, returning 0
    -- Executing Congestion("Local/77794674000@queuedial-4dd2,2", "") in new stack

***************************************************************
Regards
Mal

11
Running QueueMetrics / Re: Agents don't appear
« on: May 01, 2008, 00:11:25 »
you need to take out the ; in front of agent in agent.conf and should work.
regards
Mal

12
Hi
Have noticed what believe is a bug in outgoing where call record shows as ongoing in queuemetrics.
It seems to work fine as per logs file example you show if the CALLED (B) party hangs up first as shown from log:-

1195784028|1195784028.43|q-777|NONE|ENTERQUEUE|-|0294674000
1195784028|1195784028.43|q-777|Agent/105|CONNECT|0|
1195784033|1195784028.43|q-777|Agent/105|CONNECT|5|
1195784037|1195784028.43|q-777|Agent/105|COMPLETECALLER|5|4

However if A party or Originator hangs up first only shows first 2 rows. 1195784127|1195784127.51|q-777|NONE|ENTERQUEUE|-|0294674000
1195784127|1195784127.51|q-777|Agent/105|CONNECT|0|

This seems to be the opposite to current issues and responses where they are saying if Rmote (B) hangs up first. I have no issue with that. 

Asterisk Version 1.2.22

I have tried suggestions and thread links in "Queuemetrics not recognising Remote Caller hangup and that doesn't change anything.

Regards and hope you can help

Pages: [1]