How to Download CDR Report using Command in FreePBX v15

FreePBX Applications / Modules
#1

Do we have any Command line Utility to download the CDR Report using Command in FreePBX v15 ?
I want to automate the process of downloading CDR Report.
Any pointers

#2

There is no FreePBX 16.

Are you from the future? Who wins the Super Bowl?

#3

My bad its FreePBX v15

#4

Please guide me if there is any way by which I can download the CDR report from the Command prompt.

#5

The data you want will be ‘tab delimited’ but withIn

mysql asteriskcdrdb -B -e "select * from cdr"

You need to add your particular filters to get exactly what you want. There are plenty of resources in ‘the internet’ as to howto

#6

I want to download CDR report for every Monday from 11:00 am to 11:00 am for CallerID “911” in the form of CSV or any other readable format and send email with attachment.

I am not from database background and new to FreePBX.
Can you please help me with it

#7

Then you should hire someone to handle things.

This seems a bit important to be leaving to random forum postings.

#8

I wanted it to be tuned to a specific date and callerID and destination can be everything for that timestamp and date. CDR Report in tabular format

Please help

#9

Don’t cross post

2 Likes
#10

My apologies

#11

Did you try my suggestion in the other thread?

#12

I did and updated the thread with the challenge I am facing

#13

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.