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

[Phil S. <al...@me...>]

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
  al...@ca...   al...@me...   ph...@co...
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.