John Drescher wrote: > On Fri, Oct 16, 2009 at 6:30 PM, Terry L. Inzauro > <tinza...@ha-solutions.net> wrote: >> John Drescher wrote: >>> On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro >>> <tinza...@ha-solutions.net> wrote: >>>> Does bconsole support sorting of output? For instance, can bconsole sort >>>> the output of "list volumes pool=FullPool" by size >>>> or date? >>>> >>>> kind regards, >>>> >>> You can do that in a query. >>> >>> John >> >> >> When you say query, I'm assuming you are suggesting I run an SQL query. I >> like the idea, however, I am not versed in the >> ways of the SQL master. >> >> Is there a repository of SQL queries somewhere that may be of use for >> reporting purposes? >> >> I am trying to figure out a way to automate reporting for a client on a >> daily/weekly/monthly basis. >> > > type query in bconsole. > > There are several builtin queries you can use as examples. I believe > bacula-dir.conf specifies the location of where the query file is. > > On my system I have > > QueryFile = "/usr/libexec/bacula/query.sql" > > Add your query to that file at the end and bacula will load and > execute that with the query command of bconsole. > > John
Yup. That should do it. For testing, I've decided to use the mysql command line interface and I have one last question. How would I take take sums of two columns such as JobFiles and JobBytes [18:13:04 r...@jenna:~]# mysql -u root -pxxxxx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 489 Server version: 5.0.51a-24+lenny2-log (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use bacula; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SELECT DISTINCT Job.JobId as JobId,Client.Name as Client, FileSet.FileSet AS FileSet,Level,StartTime, JobFiles,JobBytes,VolumeName FROM Client,Job,JobMedia,Media,FileSet WHERE Client.Name='peyton' AND Client.ClientId=Job.ClientId AND Job.Type='B' AND Job.JobStatus='T' AND Job.FileSetId=FileSet.FileSetId AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId ORDER BY Job.StartTime; +-------+--------+---------------+-------+---------------------+----------+-----------+---------------+ | JobId | Client | FileSet | Level | StartTime | JobFiles | JobBytes | VolumeName | +-------+--------+---------------+-------+---------------------+----------+-----------+---------------+ | 4700 | peyton | StandardLinux | F | 2009-09-06 05:28:54 | 47498 | 789899195 | FullPool_0067 | | 4777 | peyton | StandardLinux | D | 2009-09-13 00:37:11 | 50 | 2442702 | DiffPool_0004 | | 4910 | peyton | StandardLinux | I | 2009-09-25 00:28:57 | 43 | 2095221 | IncrPool_0036 | | 4921 | peyton | StandardLinux | I | 2009-09-26 00:29:15 | 41 | 2072585 | IncrPool_0090 | | 4932 | peyton | StandardLinux | D | 2009-09-27 00:53:34 | 52 | 2497277 | DiffPool_0011 | | 4943 | peyton | StandardLinux | I | 2009-09-28 00:29:48 | 50 | 2366865 | IncrPool_0037 | | 4954 | peyton | StandardLinux | I | 2009-09-29 00:28:55 | 41 | 2018132 | IncrPool_0119 | | 4965 | peyton | StandardLinux | I | 2009-09-30 00:38:28 | 41 | 2035566 | IncrPool_0136 | | 4976 | peyton | StandardLinux | I | 2009-10-01 00:29:36 | 41 | 2052047 | IncrPool_0130 | | 4987 | peyton | StandardLinux | I | 2009-10-02 00:31:56 | 45 | 2069134 | IncrPool_0011 | | 4998 | peyton | StandardLinux | I | 2009-10-03 00:29:48 | 41 | 2085954 | IncrPool_0140 | | 5009 | peyton | StandardLinux | F | 2009-10-04 05:36:39 | 47498 | 789930570 | FullPool_0009 | | 5020 | peyton | StandardLinux | I | 2009-10-05 00:29:15 | 50 | 2378897 | IncrPool_0029 | | 5031 | peyton | StandardLinux | I | 2009-10-06 00:29:07 | 41 | 2029220 | IncrPool_0004 | | 5042 | peyton | StandardLinux | I | 2009-10-07 00:51:50 | 41 | 2046245 | IncrPool_0055 | | 5053 | peyton | StandardLinux | I | 2009-10-08 00:28:28 | 41 | 2062919 | IncrPool_0077 | | 5108 | peyton | StandardLinux | I | 2009-10-14 01:25:39 | 50 | 2430892 | IncrPool_0079 | | 5119 | peyton | StandardLinux | I | 2009-10-14 02:41:33 | 50 | 2431747 | IncrPool_0027 | | 5130 | peyton | StandardLinux | I | 2009-10-15 00:30:11 | 41 | 2073822 | IncrPool_0009 | | 5141 | peyton | StandardLinux | I | 2009-10-16 00:30:07 | 41 | 2091084 | IncrPool_0005 | +-------+--------+---------------+-------+---------------------+----------+-----------+---------------+ 20 rows in set (0.01 sec) Thank you for all of your help. Terry ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
