Re: [Bacula-users] Exporting tape list to excel in Mac OSX?

2014-01-09 Thread Davide Franco (dev)
Hello Bill, The simplest way would be to use an Excel plugin (don't know if version you're using has it by default) to connect directly to your catalog. Then simply import the Media table into Excel. So no needs to perform a SQL query Hope it'd helpful Regards Davide On Jan 9, 2014 11:35 PM,

Re: [Bacula-users] Exporting tape list to excel in Mac OSX?

2014-01-09 Thread Bill Arlofski
On 01/09/14 15:45, Shadow187 wrote: You can used a (simple) one-liner like this: echo "SELECT * FROM Media;" \ | mysql -u bacula bacula \ | sed -e 's/\(^.\)/"\1/' \ -e 's/\t/","/g' \ -e 's/\(.$\)/\1"/' > /tmp/media.csv That will output all of your media (all columns of the

[Bacula-users] Copy job limit is 100?

2014-01-09 Thread Steven Hammond
I missed a couple of days (holidays) backing up from disk to tape (we backup disk to disk every night) so when I went to run the job to copy disk to tape it only grabbed 100 jobs. This seems sort of artificial (what if I had more than 100 workstations/servers I was backing up?). I was wonderin

[Bacula-users] Exporting tape list to excel in Mac OSX?

2014-01-09 Thread Shadow187
Thank you for the information Dimitri, however I am not proficient in mysql either. +-- |This was sent by michael.naz...@noaa.gov via Backup Central. |Forward SPAM to ab...@backupcentral.com. +

Re: [Bacula-users] Exporting tape list to excel in Mac OSX?

2014-01-09 Thread Dimitri Maziuk
On 01/09/2014 01:38 PM, Shadow187 wrote: > I am very new to using Bacula but am in need of getting the tape > list exported out to excel to attach for off-site backups. I have > not been able to find a way to even copy out of the GUI tape list and > am wondering how this can be achieved? You could

[Bacula-users] Exporting tape list to excel in Mac OSX?

2014-01-09 Thread Shadow187
I am very new to using Bacula but am in need of getting the tape list exported out to excel to attach for off-site backups. I have not been able to find a way to even copy out of the GUI tape list and am wondering how this can be achieved? I am running bat 5.2.13 and using the terminal service

Re: [Bacula-users] Planning large installation

2014-01-09 Thread Uwe Schuerkamp
On Tue, Jan 07, 2014 at 03:32:01PM -1000, Romeo Theriault wrote: > Hi Uwe, thanks for the response. I'm not sure how many directors we'll > have. Was going to start with one and go from there. How many do you have > for your 110 client setup? It's good to hear you're fairly happy with the > separat