Re: [FOSSology] Clean Out Repository

2011-06-15 Thread Westphal, Raymond W
@fossology.org Subject: Re: [FOSSology] Clean Out Repository Hi Ray, To find the uploads over a year old: select upload_pk from upload where upload_ts (now() - interval '1 year') order by upload_ts You can then take that list and schedule the delete agent on each one of the upload_pk's

Re: [FOSSology] Clean Out Repository

2011-06-15 Thread Bob Gobeille
, Ray W. -Original Message- From: Bob Gobeille [mailto:bob.gobei...@hp.com] Sent: Tuesday, June 14, 2011 12:27 PM To: Westphal, Raymond W Cc: fossology@fossology.org Subject: Re: [FOSSology] Clean Out Repository Hi Ray, To find the uploads over a year old: select

Re: [FOSSology] Clean Out Repository

2011-06-14 Thread Bob Gobeille
Hi Ray, To find the uploads over a year old: select upload_pk from upload where upload_ts (now() - interval '1 year') order by upload_ts You can then take that list and schedule the delete agent on each one of the upload_pk's with the fossjobs command (man fossjobs). Unfortunately, you can't