[asterisk-users] How to see initiall dialled extension in CDR records ?

[Albert]

Hi guys,

I have following problem. For statistical reasons I need to know what 
was initiall number dialled by customer. I have 2 premium numbers, for 
which customers are billed differently per minute. But in my CDR table i 
can see only last dialled extension from voice menu. In this example it 
shows me that customer (077XXXXXXX) was billed 293 seconds but i am not 
seeing which number he dialed. Only what i can see is last destination 
he choosed from voice menu which was '1'.

What shall I do to see which number was dialled initially?

ps. Original numer was X-ed.

       calldate       |    clid    |    src     | dst |      
dcontext      |        channel         | dstchannel |  lastapp   
|              lastdata              | duration | billsec | disposition 
| amaflags | accountcode |   uniqueid    | userfield
---------------------+------------+------------+-----+--------------------+------------------------+------------+------------+------------------------------------+----------+---------+-------------+----------+-------------+---------------+-----------
  2011-12-12 15:11:26 | 077XXXXXXX | 077XXXXXXX | 1   | 
stories-en-options | DAHDI/i1/077XXXXXXX-13 |            | Playback   | 
custom/l_stories/en/en_bible |      293 |     293 | ANSWERED    |        
3 |             | 1323691886.91 |

Below is part on my extensioans file and voice menu structure

[incoming-calls-from-e1-span1]
exten => 902000111,1,Verbose(Call is comming .... ${EXTEN})
exten => 902000111,n,Goto(voiceservices_menu,2666,1)

exten => 902000222,1,Verbose(Call is comming .... ${EXTEN})
exten => 902000222,n,GotoIfTime(08:00-22:59,mon-sun,*,*?supportmenu,2555,1)
exten => 902000222,n,Playback(custom/l_line/callcenter-closed)
exten => 902000222,n,Goto(voiceservices_menu,2666,1)

[voiceservices_menu]
exten => 2666,1,Set(EXT=${EXTEN})
exten => 2666,n,Verbose(EXT -> ${EXT})
exten => 2666,n,Goto(voiceservices_options,s,1)

[voiceservices_options]
exten => s,1,Background(custom/l_stories/swelcome)
exten => s,n,WaitExten(15)  ;wait 10 sec

exten => 1,1,Verbose(Customer pressed key 1)
exten => 1,n,Goto(storiesmenu-lu,${EXT},1) ;if customer choosed 1 jump 
to LU lang

exten => 2,1,Verbose(Customer pressed key 2)
exten => 2,n,Goto(storiesmenu-en,${EXT},1) ;if customer choosed 1 jump 
to EN lang

exten => i,1,Playback(invalid)
exten => i,n,Goto(voiceservices_menu,${EXT},1)

exten => t,1,Playback(vm-goodbye)
exten => t,n,Goto(voiceservices_menu,${EXT},1)


[storiesmenu-lu]
exten => 2666,1,Verbose(Entering Luganda menu of stories)
exten => 2666,n,Verbose(EXT = ${EXT})
exten => 2666,n,Goto(storiesmenu-lu-options,s,1)


[storiesmenu-lu-options]
exten => s,1,Background(custom/l_stories/lu_service_menu)
exten => s,n,Verbose(EXT = ${EXT})
exten => s,n,WaitExten(10)  ;wait 10 sec

; if customer pressed '1'
exten => 1,1,Goto(stories-lu,${EXT},1)

; if customer pressed '2'
exten => 2,1,Playback(custom/l_stories/lu/lu_bible1)
exten => 2,n,Wait(2)
exten => 2,n,Playback(custom/l_stories/lu/lu_bible2)
exten => 2,n,Wait(2)
exten => 2,n,Playback(custom/l_stories/lu/lu_bible3)
exten => 2,n,Wait(2)
exten => 2,n,Playback(custom/l_stories/lu/lu_bible4)
exten => 2,n,Wait(2)
exten => 2,n,Playback(custom/l_stories/lu/lu_bible5)
exten => 2,n,Wait(2)
exten => 2,n,Goto(storiesmenu-lu,${EXT},1)



Thanks for your feedback!

Regards,
Albert

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20111212/2350288c/attachment-0001.htm>