Getting reports from Asterisk

Asterisk Asterisk General
1

Hello,

I recently inherited an asterisk system and now my supervisor is asking me to provide him a report about calls made to cellular phone using company´s phones.

It should include:
Date, extension number, cell phone number dialed and call duration.

I must confess I’m very new to asterisk and my knowledge of it is limited to creating and editing extension numbers.

Any help on how to go about and prepare this report is appreciated.

Thanks in advance.

2

Asterisk CDR With MYSQL Backend could help you.

wiki.asterisk.org/wiki/display/ … DR+Backend

3

Thanks ambiorixg12, I ended up doing a select estatement against the asteriskdb with the following query

SELECT ‘Date’,
‘Extention Number’,
‘Dial number’,
'Length of call’
UNION ALL
SELECT
calldate,
src,
dst,
duration
FROM cdr
WHERE calldate like "2014-04-%"
AND disposition = "ANSWERED"
AND dst like ‘09%’ > 0
INTO OUTFILE '/data/calls.txt’
FIELDS TERMINATED BY ‘,’;

My question is: the meassure in the value returned in the duration field is represented in seconds, minutes or hours?

Thanks in advance.

4

seconds

5

Thanks a lot, I was able to get the report I needed.

6

You will get CDR as CSV format in floder /var/log/asterisk/cdr-csv