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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
