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.


Thanks in advance for any help.

Cheers,

-- 
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