Pretty cool. Thanks. 2013/5/19 Dan Langille <d...@langille.org>: > > 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 >
-- Isamar Maia Cel. VIVO SSA: (55) 71-9146-8575 Fixo: (55) 71-4062-8688 Skype ID: isamar.maia "A vida é muito curta para ser pequena" (Benjamin Disraeli) ------------------------------------------------------------------------------ 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
