[Evergreen-general] [External] Reporter folder cleanup question

[Jason Stephenson]

Jon,

We run something similar to what Blake shared below.

We also run this daily via crontab to remove the files after 90 days:

find /openils/var/data/reports/ -type f -mtime +90 -delete

You'll need to adjust "/openils/var/data" for wherever your reports are 
stored.

HtH,
Jason Stephenson

On 5/28/24 15:29, Blake Graham-Henderson via Evergreen-general wrote:
> Jon,
> 
> Here's the cron line:
> 
> 
> # purge 90 day old reports
> 0 01 * * * psql  < purge_reports.sql >/dev/null 2>&1
> 
> And the contents of purge_reports.sql:
> 
> BEGIN;
> 
> DELETE FROM reporter.schedule WHERE run_time<NOW()-INTERVAL '90 days';
> DELETE  FROM reporter.report WHERE create_time<NOW()-INTERVAL '90 days' 
> AND recur=FALSE AND id NOT IN
> (SELECT r.id FROM reporter.report r INNER JOIN reporter.schedule s ON 
> r.id=s.report);
> 
> COMMIT;
> 
> 
> -Blake-
> Conducting Magic
> Will consume any data format
> MOBIUS
> 
> On 5/28/2024 1:45 PM, Murphy, Benjamin via Evergreen-general wrote:
>> NC Cardinal has a process that deletes old output and non-recurring 
>> reports after 3 months. We don't touch the templates. (Its a cron job 
>> that Mobius runs for us.)
>>
>> *Benjamin Murphy*
>>
>> NC Cardinal Program Manager
>>
>> State Library of North Carolina
>>
>> _benjamin.murphy at dncr.nc.gov _ | 
>> https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal
>>
>> 109 East Jones Street  | 4640 Mail Service Center
>>
>> Raleigh, North Carolina 27699-4600
>>
>> The State Library is part of the NC Department of Natural & Cultural 
>> Resources.
>>
>> /Email correspondence to and from this address is subject to the North 
>> Carolina Public Records Law and may be disclosed to third parties./
>>
>> Please note new email address
>>
>> ------------------------------------------------------------------------
>> *From:* Evergreen-general 
>> <evergreen-general-bounces at list.evergreen-ils.org> on behalf of 
>> JonGeorg SageLibrary via Evergreen-general 
>> <evergreen-general at list.evergreen-ils.org>
>> *Sent:* Tuesday, May 28, 2024 2:35 PM
>> *To:* Evergreen Discussion Group 
>> <evergreen-general at list.evergreen-ils.org>
>> *Cc:* JonGeorg SageLibrary <jongeorg.sagelibrary at gmail.com>
>> *Subject:* [External] [Evergreen-general] Reporter folder cleanup 
>> question
>> CAUTION: External email. Do not click links or open attachments unless 
>> verified. Report suspicious emails with the Report Message button 
>> located on your Outlook menu bar on the Home tab.
>>
>> What methodology are you all using to periodically purge old reports 
>> out of the /openils/var/web/reporter folder?
>>
>> Thanks
>> -Jon
>>
>> ------------------------------------------------------------------------
>>
>> Email correspondence to and from this address may be subject to the 
>> North Carolina Public Records Law and may be disclosed to third 
>> parties by an authorized state official.
>>
>> _______________________________________________
>> Evergreen-general mailing list
>> Evergreen-general at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
> 
> 
> _______________________________________________
> Evergreen-general mailing list
> Evergreen-general at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general