Delete old Sucuri reports

[Refica]

Is there a way to bulk delete old Sucuri reports? I have reports dated back in 2021 - 2023 which I don’t need.

It has been discussed in this thread:

Delete old Sucuri security reports

I run the Sucuri security scans on all my sites every week. The reports accumulate over time. I can delete reports manually from the security reports screen on each child site. Is there a setting for the MainWP Sucuri extension that will permit me to set a purge after date for the reports? If not an extension, can you offer a filter or code snippet that I can use to perform this task on a regular basis? Thanks, Matt

[bojan (Bojan Katusic)]

Hey @Refica

Unfortunately, there haven’t been any changes regarding this functionality since that topic.

It is not possible to delete old Sucuri reports in bulk.

Please feel free to make a suggestion about this on our feedback site. That way, others can vote for it, letting us know which features our users want the most.

[Refica]

Hi @bojan

Thank you. I have made a suggestion on your feedback site.

[eNaycH (Nigel Hellewell)]

Hi,

The report data is in the XX_mainwp_sucuri_report table. Date is stored in the timescan field (in Unix format) so you can play with the FROM_UNIXTIME function to covert it to a readable date and perhaps run the SQL manually annually. The data doesn’t take up that much space in the database, but I can see it could be annoying on the Dashboard.

Example: DELETE from XX_mainwp_sucuri_report where left(FROM_UNIXTIME(a.timescan),4)=2021;

Try SELECT * before the DELETE to check you own data.

[Refica]

Hi Nigel,

Thank you for your suggestion.

If I use phpMyAdmin and want to delete the old reports, can this be done by just marking the checkboxes and hitting delete? Or is the way you described it the correct way to do it?

Please see screenshot: php-my-admin

[josklever]

@Refica You can use Check All or the SQL code that @eNaycH mentioned. In the end the same action will be executed.

[Refica]

@josklever and @eNaycH Thank you for your answers.

[eNaycH (Nigel Hellewell)]

I have always checked the SQL SELECT statement first to ensure that the selected dataset is the one I wish to delete, then change the SQL Statement to DELETE.

Looking at the screenshot – is that direct from the table? In which case how do you know that the ‘timescan’ values actually mean in DD-MM-YYYY format?

In theory, if you have selected the data, using the SQL SELECT statement then the results offer checkboxes to delete, try one and see if it works. But it will be much longer that way, the last time I ran the script to delete 426 records it took under 2 seconds.