Vicidial incoming Call Report create an all calls report in a nice table with the phone number, date and time of call, term reason, seconds per call, and agent on the call using this code Create call_report.php in /srv/www/htdocs <?php $url1=$_SERVER['REQUEST_URI']; header("Refresh: 40; URL=$url1"); echo "<h1>Calls Past 7 Days</h1>"; echo "<h5>*Refreshes every 40s</h5>"; $servername="localhost"; $username="cron"; $password="1234"; $dbname="asterisk"; $conn=new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $query="select phone_number, call_date, status, term_reason, length_in_sec, user from vicidial_log where call_date > timestampadd(day, -7, now()) ;"; ...