Thank you everyone. This helps a ton. -Jon On Tue, May 28, 2024 at 12:48 PM Jason Stephenson via Evergreen-general < [email protected]> wrote:
> I hit reply too soon! > > We also run this a few minutes later to remove empty directories: > > find /openils/var/data/reports/ -empty -type d -delete > > You could bundle them up into a single script. I recommend running the > above find command after the one in the previous email. > > On 5/28/24 15:46, Jason Stephenson wrote: > > 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 > >>> > >>> [email protected] _ | > >>> 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 > >>> <[email protected]> on behalf of > >>> JonGeorg SageLibrary via Evergreen-general > >>> <[email protected]> > >>> *Sent:* Tuesday, May 28, 2024 2:35 PM > >>> *To:* Evergreen Discussion Group > >>> <[email protected]> > >>> *Cc:* JonGeorg SageLibrary <[email protected]> > >>> *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 > >>> [email protected] > >>> > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general > >> > >> > >> _______________________________________________ > >> Evergreen-general mailing list > >> [email protected] > >> > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general > _______________________________________________ > Evergreen-general mailing list > [email protected] > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >
_______________________________________________ Evergreen-general mailing list [email protected] http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
