[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 que

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 d

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 Stat