Bill, Thanks for the information. Using your ideas and with help from one of our MySQL programmers we were able to create a script that will work for us.
Jack On 01/16/13 14:33, Jack Cobb wrote: > We are using Bacula 5.0.3 on an Ubuntu 10.04 server using MySQL as the > database engine. We review each day's backup to verify it completed > but now our auditors are asking for a report that shows the backup job > results for the previous twelve months...which is the amount of time we keep our backup history. > > > > Has anyone ever generated a report using the Bacula history and if so > what tools did you use? Thanks. Hi Jack... couldn't you just use the "list jobs" bconsole output? It is formatted reasonably enough as-is, or you could script something to convert it into CSV format which could be pulled into a spreadsheet. A quick (and very dirty) combination of bconsole, grep and sed might do the trick like so: echo "list jobs" | bconsole -c /etc/bacula/bconsole.conf \ | grep "^|" | sed -e 's/|//g' -e 's/,//g' -e 's/^ \+//' \ -e 's/ \+/ /g' -e 's/ \+$//' -e 's/ /,/g' Which outputs: --[snip]-- 18966,SpeedyFull,2013-01-15,20:30:21,B,I,23614,1816360338,T 18967,SpeedyMusic,2013-01-15,20:30:21,B,I,0,0,T 18969,Voip,2013-01-15,20:30:21,B,I,152,1174965049,T 18980,Voip,2013-01-15,20:30:21,C,I,152,1174982569,T 18970,Satch,2013-01-15,20:30:23,B,I,84,1311771664,T 18965,NewbyFull,2013-01-15,20:30:26,B,I,1513,812848531,T 18971,Zimbra,2013-01-16,02:45:00,B,F,387775,16323518664,T 18972,Helpdesk,2013-01-16,02:46:58,B,F,182057,9736122612,T 18973,Newby_MustHave,2013-01-16,04:00:05,B,F,22914,6787198696,T 18974,Catalog,2013-01-16,04:04:36,B,F,9,11054415984,T --[snip]-- Of course, all of our Job Names contain no spaces so the above output does not insert double quotes, but that is easy enough to fix if you have spaces in your job names. Hope this helps -- Bill Arlofski Reverse Polarity, LLC ---------------------------------------------------------------------------- -- Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery and much more. Keep your Java skills current with LearnJavaNow - 200+ hours of step-by-step video tutorials by Java experts. SALE $49.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122612 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_122712 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users