On 19/05/2013, at 07:32 p.m., Isamar Maia <isa...@gmail.com> wrote: > 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
I know it's going to sound stupid, but why a simple list volumes command doesn't work? On my server it shows disabled, recycled and purged volumes in addition to full and appending ones :/ LDC - Gustavo El Khoury ------------------------------------------------------------------------------ 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
