Re: [Bacula-users] List files in a volume

2015-04-23 Thread Ana Emília M . Arruda
Much more simple. I thought the script for a huge number of jobs and files. Thank you. Best regards, Ana On Thu, Apr 23, 2015 at 5:07 AM, Radosław Korzeniewski < rados...@korzeniewski.net> wrote: > Hello, > > 2015-04-22 18:07 GMT+02:00 bdam : > >> One final question about this - when i issue

Re: [Bacula-users] List files in a volume

2015-04-23 Thread Radosław Korzeniewski
Hello, 2015-04-22 18:07 GMT+02:00 bdam : > One final question about this - when i issue the query command from the > console this way, is there a way to either pagenate the results or send > them to a file Use @output filename.txt in the bconsole to redirect all the output to the file. Then sim

Re: [Bacula-users] List files in a volume

2015-04-22 Thread Ana Emília M . Arruda
Hi, Maybe something like this: #!/bin/bash VOLUME=$1 DBHOST=localhost DATABASE=bacula USER="" PASSWORD="" JOBS=($(mysql --host=$DBHOST --database=$DATABASE --user=$USER --password=$PASSWORD -N -e "SELECT DISTINCT Job.JobId as JobId,Job.Name as Name,Job.StartTime as StartTime, Job.Type as Type,J

[Bacula-users] List files in a volume

2015-04-22 Thread bdam
One final question about this - when i issue the query command from the console this way, is there a way to either pagenate the results or send them to a file so I can browse them? These are 3 months of CCTV from multiple cameras running 24/7 in 20 minute sections, so there are rather a lot of f

[Bacula-users] List files in a volume

2015-04-22 Thread bdam
I never realized you could copy the sample SQL commands that way. So I did that, found the job id's from "14" then the listing from "12". Excellent, thanks! +-- |This was sent by bill.dam...@yahoo.com via Backup Central. |Forwar

Re: [Bacula-users] List files in a volume

2015-04-22 Thread Roberts, Ben
Hi, > It would be far quicker to find the files I needed > and it means I can do this search without interfering with the daily > backups which are using the same drive. By the way, the CCTV isn't on 100% > of the time, so having said that the files might not be present and/or the > filenames not

[Bacula-users] List files in a volume

2015-04-21 Thread bdam
I have the need to restore some CCTV data which was recorded in July 2014. The volume names are all right there in the pool, and I know the target date I'm looking for since its part of the filename. I just don't know which volume it's in. So an "ls" listing would identify it instantly. There ar