I need to create a report with the last time a good backup was run of each
client.
We are looking for anyone who has not backed up recently, so it would be
nice if the report could be set for clients that have not had a successful
backup in 1 week, or even a variable amount of time.
I am assuming this would be SQL. Grepping (or anything else) Bacula's 'List
Jobs' would not work, since if a client has not even started a backup it
would not be listed there. (Our backups are kicked off by remotely calling a
script on each client that starts the FD. We have several 'waves' of backups
when departments are not here or would be least affected by the backup.)
We envision the report being something like:
Name Last Backup F/D/I JobFiles JobBytes JobStatus
COMPUTER1 2013-11-06 23:59 I 29 129,056 T
LAPTOP2 2013-10-20 10:30 D 17 89,423 T
COMPUTER2 2013-10-19 17:05 I 0 0 E
Anyone else doing something like this, or can point me to some examples?
Thanks in advance
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
