Re: [Bacula-users] PoolUncopiedJobs directive

[Uwe S. <uwe...@ni...>]

On Fri, Jun 15, 2012 at 10:07:58AM -0400, Marty Frasier wrote:
> 
> I have a query in my query list to show uncopied jobs by pool name in 
> bconsole.  Here it is:
> 
> :List Uncopied Jobs for Pool:
> *Enter Source Pool Name :
> SELECT DISTINCT 
> Job.JobId,Job.Name,Job.level,Job.jobstatus,Job.StartTime,Job.EndTime,Job.jobfiles,Job.jobbytes 
> 
> FROM Job,Pool
> WHERE Pool.Name = '%1'
>   AND Pool.PoolId = Job.PoolId
>   AND Job.Type = 'B'
>   AND Job.JobStatus IN ('T','W')
>   AND Job.jobBytes > 0
>   AND Job.JobId NOT IN (SELECT PriorJobId FROM Job WHERE Type IN 
> ('B','C') AND Job.JobStatus IN ('T','W')
>   AND PriorJobId != 0)
> ORDER by Job.StartTime;
> 
> Hope that helps.
> 
> Regards,
> Marty

Thanks Marty, that was exactly what I was looking for, much
appreciated. 

All the best, Uwe 

-- 
uwe...@ni... fon: [+49] 5242.91 - 4740, fax:-69 72
Hauptsitz: Avenwedder Str. 55, D-33311 Gütersloh, Germany
Registergericht Gütersloh HRB 4196, Geschäftsführer: H. Gosewehr, D. Suda
NIONEX --- Ein Unternehmen der Bertelsmann AG