Author: Gregory Orange <gregory.orange AT metoceanengineers DOT com>
Date: Fri, 11 Jul 2008 14:57:05 +0800
Two items which relate to one another. 1. When bacula prunes jobs as part of a normal job run, I'd like to know which jobs have been pruned. In the typical job results email I receive, there's either
Author: Gregory Orange <gregory.orange AT metoceanengineers DOT com>
Date: Mon, 14 Jul 2008 09:09:39 +0800
I'd like to know jobs which are purged, not volumes. Any way of doing that? -- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open s
-- On Sun, 7/13/08, Gregory Orange <gregory.orange AT metoceanengineers DOT You may have to run SQL query against jobmedia and media tables. Something like: select distinct job.name,job.jobid,media.v
Author: Gregory Orange <gregory.orange AT metoceanengineers DOT com>
Date: Mon, 14 Jul 2008 15:27:51 +0800
Hmm, not quite. This is what I really wanted: SELECT file.fileid FROM file WHERE file.jobid NOT IN ( SELECT DISTINCT file.jobid FROM file INNER JOIN job ON file.jobid=job.jobid ) ... but this query n