Author: vishal veerkar <vishalveerkar AT gmail DOT com>
Date: Sat, 9 Jan 2010 16:23:22 +0530
I recall that there were 3 or 4 replies to the thread after that one. Did they not help you? I thought a full query had been posted already. That was weeks ago, and I can't remember exactly what you
Author: vishal veerkar <vishalveerkar AT gmail DOT com>
Date: Fri, 18 Dec 2009 11:14:28 +0530
Hi All, I would like to calculate the last 7days total backup utilization of my clients. I presently using 2.2.8 with Mysql in catalog DB. I was trying to tweak one query from query.sql as below. Fra
Author: "Mike Holden" <bacula AT mikeholden DOT org>
Date: Fri, 18 Dec 2009 05:40:27 -0500
I'm no Mysql expert, but I am an Oracle expert! I would expect to see more columns listed in the GROUP BY clause for that query. Since the only column that is aggregated is the sum(JobBytes) part, I
MySQL silently does unexpected things. PostgreSQL does this: SELECT DISTINCT Job.JobId,Client.Name as Client,Level,StartTime,JobFiles,sum(JobBytes) as Totalsize,VolumeName FROM Client,Job,JobMedia,Me
Author: vishal veerkar <vishalveerkar AT gmail DOT com>
Date: Fri, 18 Dec 2009 17:01:36 +0530
After trying some combination with other queries finally i got the break through...below query gives the output for All clients utilization in GB for specified time window...this may helpful for othe
Please note, the above is not valid SQL bacula-# FROM Client, Job, Pool bacula-# WHERE Job.ClientID = Client.ClientID and Job.PoolID = Pool.PoolID bacula-# AND JobStatus='T' bacula-# AND Job.StartTim
Author: "Mike Holden" <bacula AT mikeholden DOT org>
Date: Fri, 18 Dec 2009 06:47:19 -0500
You still have Pool.Name listed in the SELECT list but not in the GROUP BY clause. I would suggest (to give standard SQL code), that you change the "GROUP BY clause to "GROUP BY Client.Name, Pool.Nam