Re: [Bacula-users] How to find all file .avi from full tape

2010-05-31 Thread Mike Holden
Simone Martina wrote: > Thanks for your suggestions, I propose a query made with help of a > friend of mine: > SELECT CONCAT(Path.Path,Filename.Name) FROM Filename Inner Join File > ON > Filename.FilenameId = File.FilenameId Inner Join Path ON File.PathId > = > Path.PathId where (Filename.Name LIKE

Re: [Bacula-users] How to find all file .avi from full tape

2010-05-28 Thread Simone Martina
Thanks for your suggestions, I propose a query made with help of a friend of mine: SELECT CONCAT(Path.Path,Filename.Name) FROM Filename Inner Join File ON Filename.FilenameId = File.FilenameId Inner Join Path ON File.PathId = Path.PathId where (Filename.Name LIKE "%avi") OR (Filename.Name LIKE

Re: [Bacula-users] How to find all file .avi from full tape

2010-05-28 Thread Graham Keeling
On Fri, May 28, 2010 at 10:12:51AM +0100, Graham Keeling wrote: > On Fri, May 28, 2010 at 10:47:00AM +0200, Simone Martina wrote: > > Hi at all, > > someone of my colleagues tends to save non-work files (like large avi > > file) in shared directory and so my bacula backup Job take a lot of time >

Re: [Bacula-users] How to find all file .avi from full tape

2010-05-28 Thread Graham Keeling
On Fri, May 28, 2010 at 10:47:00AM +0200, Simone Martina wrote: > Hi at all, > someone of my colleagues tends to save non-work files (like large avi > file) in shared directory and so my bacula backup Job take a lot of time > due to save these unuseful rubbish... I would like to find full path of

[Bacula-users] How to find all file .avi from full tape

2010-05-28 Thread Simone Martina
Hi at all, someone of my colleagues tends to save non-work files (like large avi file) in shared directory and so my bacula backup Job take a lot of time due to save these unuseful rubbish... I would like to find full path of something file name contaings avi or AVI, has bconsole a sort of comma