[Bacula-devel] Best way to determine purged/old volumes for script?

[Richard Y. <rm...@sd...>]

Hi All -
I have a bacula setup using File storage type.   The pools & volumes are 
setup so that each volume is used only once, and that the volume is 
auto-labeled with the client name,  level and date of the job.   That 
way it's easy to tell what's on the volume.   In order to preserve disk 
space (as I gathered from other posts here in the list, that bacula 
never actually deletes the volumes), I'm trying to write a script for 
the "Run Before Job" configuration attribute.

So, now I'm trying to figure out the best way to determine which volumes 
are okay to delete.  Looking at the database, would it be something like 
running a mysql query against the bacula database such as:

select VolumeName from Media where VolStatus = 'Purged'

The desired result is to obtain a list of the volumes that are okay to 
delete.

TIA,
Rich Yumul
-- 
------------------------------------------------------------------------
Richard M Yumul
rm...@sd... <mailto:rm...@sd...>
SDTechnix
http://www.sdtechnix.com
------------------------------------------------------------------------