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