Hi Gustavo, The purpose here is to send out by email regular reports to the team and make the management easier.
isamar 2013/5/19 LDC - Gustavo El Khoury <gust...@ldc.usb.ve>: > 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 -- 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
