Removing old records from CDR

[jfinstrom (James Finstrom)]

Limit Call logs for 90 Days

Without saving credentials and using the magic of internals… prunecdr.php #!/bin/env/php <?php include '/etc/freepbx.conf'; if($argc < 2) { echo "Usage: $argv[0] <months>\n"; exit(1); } /** A Small cheat to get the cdr database without seperately storing credentials or parsing anything */ $cdrdb = FreePBX::Cdr()->cdrdb; $query = sprintf("DELETE FROM cdr WHERE calldate < DATE_SUB(NOW(), INTERVAL %s MONTH);", $argv[1]); $cdrdb->query($query); ^^^ Make executable ^^^ Cron 0 0 * * * …