[Bacula-users] Extensions to query.sql (was: problems with update slots)

2006-01-16 Thread Arno Lehmann
Hello, On 1/15/2006 11:17 PM, Arno Lehmann wrote: ... But, and this might be something worth a feature request (Kern, are you reading this ;-) there should be a pre-defined query to print out which volumes are loaded into which slots in which storage device. Incidentially, I've got such a

Re: [Bacula-users] Extensions to query.sql (was: problems with update slots)

2006-01-16 Thread John Kodis
On Mon, Jan 16, 2006 at 10:27:17AM +0100, Arno Lehmann wrote: Ok, here is what I added to my query.sql file. Note that it works with MySQL only - the only PostgreSQL installation I have available uses file based backups, so there never was much need to make these queries portable. And

Re: [Bacula-users] Extensions to query.sql (was: problems with update slots)

2006-01-16 Thread Kern Sibbald
Thanks. I've added your #17 and 18 to the query.sql file. On Monday 16 January 2006 10:27, Arno Lehmann wrote: # 16 :List last 25 Jobs ordered by start time with long status: SELECT JobId,Name,StartTime,Type,Level,JobFiles,JobBytes,JobStatusLong AS Status FROM Job LEFT JOIN Status ON