相続、親が弱ってきたら銀行の預金は親の面倒を見ているものが全て解約して管理すべきである、銀行は解約させない!!

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

Asterisk
スポンサーリンク

過去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 <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
Asterisk
スポンサーリンク
シェアする
ふじやんをフォローする
スポンサーリンク
なんでもDIY

コメント