ASTERISK PBXの通信記録をgmailに送付

過去24時間の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 " -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 " -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 " -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 " -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 " -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 " -a "Content-Type: text/html" -s "ASTERISK PBX 昨日の電話発信履歴" ckenko25@gmail.com
関連広告記事
スポンサーリンク

シェアする

  • このエントリーをはてなブックマークに追加

フォローする

スポンサーリンク