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