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.schuerk...@nionex.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
