Pretty cool. Thanks.
2013/5/19 Dan Langille <dan AT langille DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|