by rohitrmenon » Sun Mar 13, 2011 3:13 pm
is this what u are looking for ?
2011-03-13 15:23:19|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300044199.18',channel='IAX2/2489360208-530',server_ip='xxx.xxx.xxx.xxx',caller_id_number='2489361070',caller_id_name='SOUTHFIELD_MI',extension='12489360208',call_date='2011-03-13 15:23:19',did_id='1',did_route='EXTEN';|
2011-03-13 15:23:19|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300044199.18',channel='IAX2/2489360208-530',server_ip='xxx.xxx.xxx.xxx',caller_id_number='2489361070',caller_id_name='SOUTHFIELD_MI',extension='12489360208',call_date='2011-03-13 15:23:19',did_id='1',did_route='EXTEN';|
2011-03-13 15:23:19|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300044199.18', channel='IAX2/2489360208-530', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='2489361070', start_time='2011-03-13 15:23:19', start_epoch='1300044199';|
2011-03-13 15:23:19|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 15:45:05|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300045505.4',channel='IAX2/2489360208-4943',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:45:05',did_id='1',did_route='EXTEN';|
2011-03-13 15:45:05|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300045505.4',channel='IAX2/2489360208-4943',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:45:05',did_id='1',did_route='EXTEN';|
2011-03-13 15:45:05|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300045505.4', channel='IAX2/2489360208-4943', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 15:45:05', start_epoch='1300045505';|
2011-03-13 15:45:05|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 15:45:41|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300045541.5',channel='IAX2/2489360208-3801',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:45:41',did_id='1',did_route='EXTEN';|
2011-03-13 15:45:41|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300045541.5',channel='IAX2/2489360208-3801',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:45:41',did_id='1',did_route='EXTEN';|
2011-03-13 15:45:41|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300045541.5', channel='IAX2/2489360208-3801', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 15:45:41', start_epoch='1300045541';|
2011-03-13 15:45:41|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 15:48:07|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300045687.6',channel='IAX2/2489360208-358',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:48:07',did_id='1',did_route='EXTEN';|
2011-03-13 15:48:07|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300045687.6',channel='IAX2/2489360208-358',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:48:07',did_id='1',did_route='EXTEN';|
2011-03-13 15:48:07|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300045687.6', channel='IAX2/2489360208-358', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 15:48:07', start_epoch='1300045687';|
2011-03-13 15:48:07|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 15:50:25|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300045825.7',channel='IAX2/2489360208-390',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:50:25',did_id='1',did_route='EXTEN';|
2011-03-13 15:50:25|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300045825.7',channel='IAX2/2489360208-390',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:50:25',did_id='1',did_route='EXTEN';|
2011-03-13 15:50:25|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300045825.7', channel='IAX2/2489360208-390', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 15:50:25', start_epoch='1300045825';|
2011-03-13 15:50:25|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 15:52:27|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300045947.11',channel='IAX2/2489360208-3195',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:52:27',did_id='1',did_route='EXTEN';|
2011-03-13 15:52:27|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300045947.11',channel='IAX2/2489360208-3195',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:52:27',did_id='1',did_route='EXTEN';|
2011-03-13 15:52:27|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300045947.11', channel='IAX2/2489360208-3195', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 15:52:27', start_epoch='1300045947';|
2011-03-13 15:52:27|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 15:53:26|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300046006.12',channel='IAX2/2489360208-3936',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:53:26',did_id='1',did_route='EXTEN';|
2011-03-13 15:53:26|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300046006.12',channel='IAX2/2489360208-3936',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:53:26',did_id='1',did_route='EXTEN';|
2011-03-13 15:53:26|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300046006.12', channel='IAX2/2489360208-3936', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 15:53:26', start_epoch='1300046006';|
2011-03-13 15:53:26|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 15:55:00|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300046100.13',channel='IAX2/2489360208-922',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:55:00',did_id='1',did_route='EXTEN';|
2011-03-13 15:55:00|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300046100.13',channel='IAX2/2489360208-922',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 15:55:00',did_id='1',did_route='EXTEN';|
2011-03-13 15:55:00|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300046100.13', channel='IAX2/2489360208-922', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 15:55:00', start_epoch='1300046100';|
2011-03-13 15:55:00|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 16:02:18|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300046538.14',channel='IAX2/2489360208-1596',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 16:02:18',did_id='1',did_route='EXTEN';|
2011-03-13 16:02:18|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300046538.14',channel='IAX2/2489360208-1596',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 16:02:18',did_id='1',did_route='EXTEN';|
2011-03-13 16:02:18|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300046538.14', channel='IAX2/2489360208-1596', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 16:02:18', start_epoch='1300046538';|
2011-03-13 16:02:18|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
2011-03-13 16:02:24|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1300046544.15',channel='IAX2/2489360208-384',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 16:02:24',did_id='1',did_route='EXTEN';|
2011-03-13 16:02:24|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1300046544.15',channel='IAX2/2489360208-384',server_ip='xxx.xxx.xxx.xxx',caller_id_number='5109967199',caller_id_name='SANDHU_PRO_AUTO',extension='12489360208',call_date='2011-03-13 16:02:24',did_id='1',did_route='EXTEN';|
2011-03-13 16:02:24|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1300046544.15', channel='IAX2/2489360208-384', channel_group='DID_INBOUND', server_ip='xxx.xxx.xxx.xxx', type='IAX2', extension='12489360208', number_dialed='12489360208', caller_code='5109967199', start_time='2011-03-13 16:02:24', start_epoch='1300046544';|
2011-03-13 16:02:24|agi-DID_route.agi|exiting the DID app, transferring call to 9998811112 @ default
agi-DID_route.agi:
#[trunkinbound]
# ;inbound DID catch-all:
#exten => _X.,1,AGI(agi-DID_route.agi)
#