Phone Logs

[tevans]

Is there away to export completed phone logs to excel and it be actually readable?

I pull the CDR/User logs for a specific number every month and have to send them to a supervisor in our county.

The issue is that every time I export the list is is so messed up I spend hours getting all the info back into some sort of order.

Can any help me on this?

[Carlo Poggiarelli]

Hi,

You can run a sql through cli selecting all fields you need and putting the result on a text file which can be imported on an spreadsheet.

Eg.

run sql car select datetimeOrigination,duration,finalcalledpartynumber from tbl_billing_data where callingpartynumber ='XXXX' 

Please let me know if it helps

Regards

Carlo