Thirdlane – Monitor cdr – Reseller report

connect_error) {
        die("Connection asterisk failed: " . $conn->connect_error);
}

$sql  = "select userfield, count(*) as total ";
$sql .= "from cdr ";
$sql .= "where dst like '011%' and ";
$sql .= "calldate >= NOW() - INTERVAL 5 MINUTE ";
$sql .= "group by userfield ";
$sql .= "having total > " . $max_count;


print $sql . "\n";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
                print "tenant: " . $row["userfield"]. "total: " . $row["total"] . "\n";
                send_mail($row["userfield"], $row["total"]);
        }

}

$conn->close();
function send_mail($tenant, $total) {

        $to      = 'support@wuyifan.com';
        $subject = 'Urgent: pbx potential hacked tenant = ' . $tenant;
        $message = 'over ' . $total . " international calls in last 5 mins";
        $headers = 'From: no-reply@prodosec.com' . "\r\n";

        mail($to, $subject, $message, $headers);

}

?>

check number of international calls in last 5 mins, if over max value, send a warning email

Reseller report

#!/bin/bash
user=root
password=hide
database=pbxconf

filename=/home/hide/tenant_report.csv

rm -f "$filename"
mysql --user="$user" --password="$password" --database="$database"<