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.schuerkamp AT nionex DOT net 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



------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users