[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-users
Subject:    Re: [Bacula-users] SQL query to find media without jobs or with zero file bytes?
From:       Uwe Schuerkamp <uwe.schuerkamp () nionex ! net>
Date:       2012-12-27 13:41:51
Message-ID: 20121227134151.GH26049 () nionex ! net
[Download RAW message or body]

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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[prev in list] [next in list] [prev in thread] [next in thread]