Bacula-users

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

2012-12-27 08:43:58
Subject: Re: [Bacula-users] SQL query to find media without jobs or with zero file bytes?
From: Uwe Schuerkamp <uwe.schuerkamp AT nionex DOT net>
To: "K. M. Peterson" <kmp.lists+bacula-users AT gmail DOT com>
Date: Thu, 27 Dec 2012 14:41:51 +0100
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 does the same for volumes that are in the Media
> table with no corresponding JobMedia entry.  (For our operations, we're
> also only interested in volumes in Pools with a PoolId between 2 and 5
> inclusive.
> 

Thanks for sharing! 

All the best, Uwe 
-- 
NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA



------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>