On Jul 6, 2010, at 10:25 AM, Phil Stracchino wrote: > On 07/06/10 10:58, Charlie Reddington wrote: >> Hi, >> >> I backup to to file storage. I also create a new volume for every >> backup job. So for a client I may have Full-0001, Diff-0001, and >> Incr-0001, Incr-0002, Incr-0003. >> >> Recently we found that our volume retention was WAY to long, and I >> wanted to purge some volumes and get some free space on the >> filesystem >> again. I found it difficult to find which volumes went to where , and >> I figured I am just missing something. >> >> I basically went back through my email logs, looked for the jobs >> for a >> client and what volume they wrote. Purged them and then removed them >> from the disk. There has to be a easier way, and I assume a better >> way >> inside of bconsole. >> >> I had thought this may be a good one to use the sql query ability of >> bconsole, but I am not 100% certain. > > There exists a console function to list the jobs contained on a > volume, > grasshopper. It is readily accessible from the Pools listing in > BAT, if > you don't want to do it from bconsole. > >
sqlquery seems to be what I want. I used a query like this to get the basic info I want. I think a bit more tweaking I can make this very useful for us. select Job.Name, Job.JobID, JobMedia.MediaID, Media.VolumeName from Job, JobMedia, Media WHERE Job.JobID = JobMedia.JobID AND JobMedia.MediaID = Media.MediaID ORDER BY Job.Name; This gets you the server name | job ID | media ID | Volume name. It's nearly a cut and paste from some documentation I found. -> https://www.cs.drexel.edu/node/12576 except I order by host. Thanks, Charlie ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users