On Wed, 17 Jan 2007 [EMAIL PROTECTED] wrote: > > I noticed an error in the $BACULA/bin/query.sql query #3, which is supposed to > list the last 20 full backups for a client.
I'd noticed this too, but hadn't gotten round to trying to fix it. Your fix works for me, but shows up a lack of Job.Name in the output. >For all I know, this has already been > corrected in the latest bacula release. It hasn't. > The diff being: > ####################################################################### > --- query.sql 2007-01-17 12:01:25.000000000 -0500 > +++ query.sql-fixed 2007-01-17 12:01:36.000000000 -0500 > @@ -29,7 +29,7 @@ > :List last 20 Full Backups for a Client > *Enter Client name: > SELECT DISTINCT Job.JobId,Client.Name AS Client,StartTime,JobFiles,JobBytes, > - JobMedia.StartFile as VolFile,VolumeName > + VolumeName > FROM Client,Job,JobMedia,Media > WHERE Client.Name='%1' > AND Client.ClientId=Job.ClientId > ######################################################################## I'd suggest this as well - SELECT DISTINCT Job.JobId,Client.Name AS Client,StartTime,JobFiles,JobBytes, + SELECT DISTINCT Job.JobId,Job.Name,StartTime,JobFiles,JobBytes, IMO There's not much point showing the client name as it's just been explicitly specified and you can't script "query" commands. YMMV ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
