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:
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:
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.
Hi @bojan
Thank you. I have made a suggestion on your feedback site.
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.
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
@Refica You can use Check All or the SQL code that @eNaycH mentioned. In the end the same action will be executed.
@josklever and @eNaycH Thank you for your answers.
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.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.