Hello All,

I need to build a list of my file storage volumes that contain a "full" backup. 
 Which I will then take that list and use to make an offsite longterm archive.

I could not find a way to do it efficiently with the bls program, so I turned 
to using a sql script to do it.  Here is what I have written:
--
select distinct(jobmedia.mediaid)
from job, jobmedia
where level = 'F' 
   and name != 'BackupCatalog'
   and name != 'RestoreFiles'
   and job.jobid = jobmedia.jobid
order by jobmedia.mediaid
;
--

My volumes are actually named "VolXXXX" and the mediaid is an integer but it 
seems to sequence with what I am seeing in my email reports.

Does anyone know if the sql above is correct for what I am trying to get?

I would also only like to get the volumes where the job finished successfully.  
Looking at the jobstatus column in the job table, almost all are "T", but I did 
see two records that have an "E" in the jobstatus column.

Does anyone know the description of the codes for jobstatus? 


TIA
Jim




------------------------------------------------------------------------------
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