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 %avi)

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

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 due

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