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.