Re: [Bacula-users] List files and directorys from a volume

On 06/13/2012 01:25 PM, Eduardo Júnior wrote:
> 
> Hi,
> 
> 
> Is it possible get the list of file from a especific volume?
> 
> For example:
> 
> I have a job to an incremental backup today at 15:00h.
> I would like to know what files were backuped since the last job.

Try this SQL query:

select Client.Name, Path.Path, Filename.Name from File join Filename on
File.FilenameId = Filename.FilenameId join Path on File.PathId =
Path.PathId join Job on Job.JobId = File.JobId join Client on
Job.ClientId = Client.ClientId where Job.JobId = [your job ID here];

In my case, using last night's incremental backup of the machine I'm
working at right now, this returns 5597 rows in 0.06 seconds.



-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.



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