過去２４時間のASTERISK PBXの通信記録をgmailに送付する
着信履歴をgmailに送付
/usr/bin/mysql -u root -ppassword -e "select calldate AS 日時, clid AS 発信元番号, did AS 着信先番号, disposition AS 着信有無, duration AS 通話時間 from cdr where calldate > date_sub(now(), interval 24 HOUR) and did <> ''" -H asteriskcdrdb | mail -a "From: PBX <ckenko25@gmail.com>" -a "Content-Type: text/html" -s "ASTERISK PBXの電話着信履歴" ckenko25@gmail.com
発信履歴をgmailに送付
/usr/bin/mysql -u root -ppassword -e "select calldate AS 日時, clid AS 発信元番号, dst AS 発信先番号, disposition AS 着信有無, duration AS 通話時間 from cdr where calldate > date_sub(now(), interval 24 HOUR) and did = ''" -H asteriskcdrdb | mail -a "From: PBX <ckenko25@gmail.com>" -a "Content-Type: text/html" -s "ASTERISK PBXの電話発信履歴" ckenko25@gmail.com
昨日のASTERISK PBXの通信記録をgmailに送付する
着信履歴をgmailに送付
/usr/bin/mysql -u root -ppassword -e "select calldate AS 日時, clid AS 発信元番号, dst AS 発信先番号, disposition AS 着信有無, duration AS 通話時間 from cdr where DATE(calldate) = SUBDATE(CURDATE(), 1) AND did <> ''" -H asteriskcdrdb | mail -a "From: PBX <ckenko25@gmail.com>" -a "Content-Type: text/html" -s "ASTERISK PBX 昨日の電話着信履歴" ckenko25@gmail.com
発信履歴をgmailに送付
/usr/bin/mysql -u root -ppassword -e "select calldate AS 日時, clid AS 発信元番号, dst AS 発信先番号, disposition AS 着信有無, duration AS 通話時間 from cdr where DATE(calldate) = SUBDATE(CURDATE(), 1) AND did = ''" -H asteriskcdrdb | mail -a "From: PBX <ckenko25@gmail.com>" -a "Content-Type: text/html" -s "ASTERISK PBX 昨日の電話発信履歴" ckenko25@gmail.com
本日のASTERISK PBXの通信記録をgmailに送付する
着信履歴をgmailに送付
/usr/bin/mysql -u root -ppassword -e "select calldate AS 日時, clid AS 発信元番号, dst AS 発信先番号, disposition AS 着信有無, duration AS 通話時間 from cdr where DATE(calldate) = SUBDATE(CURDATE(), 0) AND did <> ''" -H asteriskcdrdb | mail -a "From: PBX <ckenko25@gmail.com>" -a "Content-Type: text/html" -s "ASTERISK PBX 昨日の電話着信履歴" ckenko25@gmail.com
発信履歴をgmailに送付
/usr/bin/mysql -u root -ppassword -e "select calldate AS 日時, clid AS 発信元番号, dst AS 発信先番号, disposition AS 着信有無, duration AS 通話時間 from cdr where DATE(calldate) = SUBDATE(CURDATE(), 0) AND did = ''" -H asteriskcdrdb | mail -a "From: PBX <ckenko25@gmail.com>" -a "Content-Type: text/html" -s "ASTERISK PBX 昨日の電話発信履歴" ckenko25@gmail.com
コメント