[Bacula-users] sql query for files stored on a given volume

Subject:	[Bacula-users] sql query for files stored on a given volume
From:	Ralf Gross <Ralf-Lists AT ralfgross DOT de>
To:	bacula-users AT lists.sourceforge DOT net
Date:	Thu, 27 Aug 2009 15:02:14 +0200

Hi,

does anyone have a custom sql query to get all volume files?
Something like

12: List Files for a selected Job

but for volumes. I tried a combination of query 12 and

14: List Jobs stored for a given Volume name

But my query was a bit suboptimal... :/

Out of memory: kill process 32013 (bacula-dir) score 467185 or a child
Killed process 32013 (bacula-dir)


Ralf

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users