VoIP

CDR Commands

cd /var/lib/asterisk/bin/
cat > cdr.txt
mysql -u root asteriskcdrdb -e delete `src`,`duration`,`dst`FROM`cdr`WHERE`duration` >= 0;
mysql -u root asteriskceldb -e delete `src`,`duration`,`dst`FROM`cel`WHERE`duration` >= 0;
mysql -u root asteriskcdrdb -e ‘select 'clid','dst','duration' from cdr date(calldate)=subdate(curdate(),1)' | mail -s “Yesterday Calls” -r (Sender Email id) (Reciepnt Email ID)
mysql -u root asteriskcdrdb -e 'delete from cdr where date(calldate)=subdate(curdate(),15)'
exit 0

(press ctrl+c to exit)

mv cdr.sh cdr.txt
chmod 775 cdr.sh

too check the command type
./cdr.sh

crontab -u asterisk -e

or

cd /var/spool/cron
sudo nano asterisk

0 0 * * * /var/lib/asterisk/bin/cdr.sh

CDR Commands gets over here yippee