Fredag 24 november 2006 18:42 skrev du: > Although is not exactly what i wanted, its very close and equally helpful. > I'm using 1.38.11. How can I access that?
You can paste this into your query.sql: # 18 :List Volumes by Jobs: SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime as Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes FROM Job,JobMedia,Media WHERE JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime ORDER by JobName, Start; # 19 :List Volumes for a jobname: *Enter Job name: SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime as Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes FROM Job,JobMedia,Media WHERE Job.Name='%1' AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime ORDER by JobName, Start; Regards Steen > > By the way. what I really wanted was all the data you get from "list > jobs" plus the volume where the job is. > Thank you for your reply and help. > > > > > > > > Jaime Ventura > [Infra-estruturas e Comunicações] > > Rua Dr. António Bernardino de Almeida, 431 > 4200 - 072 Porto > Telef: +351 22 834 05 00 (04) - ext. 1641 > Fax: +351 22 832 11 59 > > e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > url: www.isep.ipp.pt <http://www.isep.ipp.pt> > > steen meyer wrote: > > Fredag 24 november 2006 12:40 skrev Jaime Ventura: > >> Thank you for your reply. > >> I knew about the "list jobmedia" command. > >> But I wanted both results(job media and jobs) merged using just one > >> command. > > > > I have made this query addition: > > > > 18: List Volumes by Jobs: > > 19: List Volumes for a jobname: > > Choose a query (1-19): 18 > > +---------------+-------+--------------+---------------------+----------- > >+--------------+ > > > > | jobname | jobid | volumename | start | files > > | | > > > > bytes | > > +---------------+-------+--------------+---------------------+----------- > >+--------------+ > > > > | adm-backup | 1,031 | Arch-0128 | 2006-06-10 10:05:02 | 599,346 > > | | > > > > 10703086842 | > > > > | adm-backup | 1,031 | Arch-0127 | 2006-06-10 10:05:02 | 399,564 > > | | > > > > 7135391228 | > > > > | adm-backup | 1,031 | Arch-0129 | 2006-06-10 10:05:02 | 199,782 > > | | > > > > 3567695614 | > > > > | adm-backup | 1,313 | Arch-0131 | 2006-07-29 10:05:03 | 199,825 > > | | > > > > 3669803318 | > > > > | adm-backup | 1,313 | Arch-0130 | 2006-07-29 10:05:03 | 599,475 > > | | > > > > 11009409954 | > > > > > > Is it something like this you are looking for? > > > > Steen > > > >> Once again, thanks. > >> > >> > >> > >> > >> > >> > >> > >> Jaime Ventura > >> [Infra-estruturas e Comunicações] > >> > >> Rua Dr. António Bernardino de Almeida, 431 > >> 4200 - 072 Porto > >> Telef: +351 22 834 05 00 (04) - ext. 1641 > >> Fax: +351 22 832 11 59 > >> > >> e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > >> url: www.isep.ipp.pt <http://www.isep.ipp.pt> > >> > >> Georg Altmann wrote: > >>> --On Donnerstag, 23. November 2006 17:36 +0000 Jaime Ventura > >>> > >>> <[EMAIL PROTECTED]> wrote: > >>>> Hello, > >>>> Is it possible to get a "list jobs" having also listed the > >>>> volume(s) related to them? > >>> > >>> This is in the manual: > >>> <http://www.bacula.org/rel-manual/Bacula_Console.html#SECTION0002060000 > >>>00 000000000> > >>> > >>> Use > >>> list jobmedia jobid=<thejobid> > >>> > >>> Regards, > >>> Georg > >>> > >>> > >>> ----------------------------------------------------------------------- > >>>-- 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=DEVD > >>>EV _______________________________________________ > >>> Bacula-users mailing list > >>> Bacula-users@lists.sourceforge.net > >>> https://lists.sourceforge.net/lists/listinfo/bacula-users > >> > >> ------------------------------------------------------------------------ > >>- 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=DEVDE > >>V _______________________________________________ > >> Bacula-users mailing list > >> Bacula-users@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------- 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
