Re: [Bacula-users] Query to list volumes available in the pool

On May 18, 2013, at 6:35 PM, Isamar Maia wrote:

> Hi Folks,
> 
> I need a SQL query for Bacula to list the volumes available in the
> pool, including those to be recycled
> due to expiration of their retention periods but weren't still recycled.
> 
> For time being, I am using this query:
> 
> select count(*) as count from Media where PoolId = X and StorageId = Y
> and (VolStatus = 'Purged' or VolStatus = 'Recycle' or VolStatus =
> 'Append');
> 
> 
> But, it doesn't include volumes up to be recycled due their job/volume
> retention periods. I need to include that info into my SQL query.


Does this help?  https://services.unixathome.org/bacula/recycling.php

You can view the SQL.  It's customized for PostgreSQL, but you can adjust that 
easily enough.

-- 
Dan Langille - http://langille.org


------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users