Re: [Bacula-users] SQL query to find media without jobs or with zero file bytes?

2012-12-27 Thread Uwe Schuerkamp
On Mon, Dec 24, 2012 at 05:48:35PM -0500, K. M. Peterson wrote: Hi Mark, I have two jobs that I run periodically. query_errvols.sql generates a list of volumes that were written by failed jobs. If a job failed, or was cancelled, it gets returned by this program. query_orphan_volumes.sql

Re: [Bacula-users] SQL query to find media without jobs or with zero file bytes?

2012-12-24 Thread K. M. Peterson
Hi Mark, I have two jobs that I run periodically. query_errvols.sql generates a list of volumes that were written by failed jobs. If a job failed, or was cancelled, it gets returned by this program. query_orphan_volumes.sql does the same for volumes that are in the Media table with no

[Bacula-users] SQL query to find media without jobs or with zero file bytes?

2012-12-20 Thread mark . bergman
I believe we have a significant number of tapes that bacula thinks are full but which no longer have jobs. These tapes were used normally and became full. Later we decommissioned the machines that were backed up to those tapes and pruned purged the bacula jobs that referenced the decommissioned