Problem

The default setting when creating a scheduled report, is to save the report. Often this setting is not disabled when creating scheduled reports and this can lead to a large number of saved reports, piling up on the "Reports - Reports - Recent and saved" page. The page becomes very slow to load and hard to navigate.

Resolution

The Leeds update brought a measure of internal housekeeping to the Recent and saved reports page. Saved reports are now automatically deleted after 6 months - however, that is still a large time frame and the amount of reports can still grow large.

Saved reports can be deleted but going through a large list and delete every individual one is time consuming, especially since the page needs a reload after each delete action.

Deleting the saved reports on the command line is possible as well. Here is a short guide for cleaning up the recent and saved reports list.

Note: If you are not comfortable using the command line, please contact Smoothwall support for assistance with this.

All the saved reports are stored in /var/reports. They each have a folder named like this:

report##########_Title of report_Random_ID

If all the saved reports need to be deleted, simply run this command:

# rm -Rf /var/reports/report*

That will delete all the saved reports and clean up the recent and saved reports page. If only reports older than a certain date needs to be deleted, run this command first:

# ls -lsh /var/reports/report*

Which will list all the reports and the dates they were created. The number after the "report" part of the name are sequential so the deletion can be done like this:

# rm -Rf /var/reports/report15*

Which will delete all reports with a name beginning with report15. Work through the numbers until you have deleted the reports that are no longer needed.