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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
