I do similar stats with this script. Script searches for clients those
have no successful backup for last 5 days:
#!/bin/bash
CURDATE=`date +%s`
# DELTA is 5 days
DELTA=432000
CHECKDATE=$((CURDATE-DELTA))
CHECKDATE2=`date -d @$CHECKDATE "+%Y-%m-%d %H:%M:%S"`
### Read client list via bcopnsole
/us
Troubleshooting: Bacula daemons not starting.
On debian/ubuntu systems bacula startup with init.d sysv init script
/etc/init.d/bacula.
For check why it not starting use init.d script modifications (for example):
ARGS="-d20 -dt -c /etc/bacula/bacula-fd.conf"
do_start()
One refinement. SELECT DISTINCT doesn't actually work (ha). If you want to
see just the last job failure, the query would look like this:
select j.name as "Job Name", c.name as "Client", max(j.schedtime) as "Job
Scheduled Time" from job j
inner join client c on c.clientid=j.clientid
where j.jo
I'm a newbie and so others can/will probably offer a better way of doing this,
but I would probably do something like this:
I would create a bash script and run it from crontab with the following line:
psql -d Bacula = now()-'10 days'::interval
If you just want to see the LAST time a job failed
We do something like this by running a job within Bacula every morning
that scans all client configuration files, builds a list of expected
current jobs/clients and then queries the Bacula DB to see when/if
they've been successfully backed up or not (i.e. marked with a T). If
it's been more th
Hi,
add the lines below to your query.sql and you should be good to go,
adding a time period parameter should be trivial (check the other
examples in query.sql).
HTH Uwe
##
:List all clients without a backup in the last week
SE
