Re: [Bacula-users] Listing jobs and volumes...
Mandag 27 november 2006 18:01 skrev du: In the message dated: Fri, 24 Nov 2006 14:03:05 +0100, The pithy ruminations from steen meyer on Re: [Bacula-users] Listing jobs and volumes... were: = 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: Those sound like very useful queries. Could you please post the SQL code to the mailing list Already did friday - and they come here below too (and submit it to Kern as an addition to future releases)? This I did not do because I have not examined if it is already present in the latest releases, which I am not running at the moment, and I don't know if it will work with the database changes since 1.38.0, but maybe Kern can tell at a glance;-) so here we go: (note that the first two list all volumes in the database) # 17 :List Volumes by Volume: SELECT VolumeName, Job.JobId as JobID, Job.Name as JobName, 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 VolumeName; # 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 Thanks, Mark [SNIP!] = = Is it something like this you are looking for? = = Steen = Mark Bergman [EMAIL PROTECTED] System Administrator Section of Biomedical Image Analysis 215-662-7310 Department of Radiology, University of Pennsylvania http://pgpkeys.pca.dfn.de:11371/pks/lookup?search=mark.bergman%40.uphs.upen n.edu The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. - 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.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Listing jobs and volumes...
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. 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 + 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#SECTION000206000 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.phpp=sourceforgeCID=DEVDEV ___ 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.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Listing jobs and volumes...
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 + 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#SECTION00020600 0 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.phpp=sourceforgeCID=DEVDEV ___ 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.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Regards Steen - 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.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Listing jobs and volumes...
Hello, Is it possible to get a list jobs having also listed the volume(s) related to them? Thanks for your 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 - 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.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Listing jobs and volumes...
--On Donnerstag, 23. November 2006 17:36 + 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#SECTION000206000 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.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users