*NOTE* This process will remove ALL generated reports from the Syslog-ng Store Box (SSB), please backup any reports that are desired not to be deleted before continuing with the steps below:
1.) Log into the core-shell of the Syslog-ng Store Box (SSB) via the console.
2.) Delete reports currently stored on the SSB.
2a. Reports older than ... (eg. 90days)
find /opt/ssb/var/reports -name *.pdf -ctime +90 -delete
2b. All reports
find /opt/ssb/var/reports -name *.pdf -delete
3.) Proceed only if 'Reports older than ...' option was selected, otherwise continue with step 4.
Get the current time's UNIX timestamp on the retention day. (Now - 90 days)
date +%s --date -90days
4.) Next, launch sqlite3 on the report.db to remove the reports from showing in the WebUI. To do so please run the following command:
SELECT * FROM reports;
6.) Next, run the following command to remove entries of previous reports on the SSB.
6a. Reports older than ... (eg. 90days)
Replace TIMESTAMP with the result of Step 3.
DELETE FROM reports where session_end < TIMESTAMP;
6b. All reports
DELETE FROM reports;
8.) Next, restart the makeworld service to ensure the reports.db is re-analyzed by the SSB.
systemctl restart makeworld