[Bacula-users] Hope usefull script if you know % of progress backup

Hi All!

I hope thi can be usefull

the script return lines like this

JobId= 5257 <JOBNAME> <CLIENT> | Now: 58.81% Files=217437 Bytes=224761256596 Bytes/sec=7269592 Errors=3 (on tot.byte= 382146782310) 08:35:18 <-- duration
JobId= 5226 <JOBNAME> <CLIENT> | Now: 73.15% Files=1580436 Bytes=217781667592 Bytes/sec=5045914 Errors=0 (on tot.byte= 297702961761) 11:59:20

Here you are and pls, let me know ;)

Fabio

#!/bin/bash
#
# Script to know the progress of running bck
#        using by -u for updating client list/estimate
#
# By CHIECHI Fabio
# (c) 2009
#
chcpath=/filedisk/chc/tmp
bindir=/usr/bin
db_name=${db_name:-bacula}
if [ ! -f $bindir/mysql ]; then
   echo -e "Sorry, Script for MySQL!\nI can't find MySQL :("
   exit 1
fi
case "$1" in

   -u|update|-update|upd|-upd)
      rm -f $chcpath/bacula_estratto_estimate.txt
      bconsole <<END-OF-DATA | grep -v Enter | grep -v 1000 | grep -v client | sort -u > $chcpath/bacula_lista_client.txt
.client
END-OF-DATA
      cat $chcpath/bacula_lista_client.txt | while read line
      do
         echo $line
         esito=$(bconsole <<END-OF-DATA| grep "OK estimate"
estimate job=$line.j
END-OF-DATA)
         echo $esito
         echo $line $esito | awk '{print $1 "   bytes = " substr($6,7,20) "   files = " substr($5,7,20)}' | sed "s/,//g" >> $chcpath/bacula_estratto_estimate.txt
      done
      rm -f $chcpath/bacula_lista_client.txt
      ;;

   *)
      if [ ! -f $chcpath/bacula_estratto_estimate.txt ]; then
         echo "I can't find estimate data."
         echo "Run the scrpt with -u option!"
         exit 1
      fi

      $bindir/mysql -f <<END-OF-DATA | grep -v "JobId" | while read line
USE ${db_name};
select JobId,Job,Client.Name from Job inner join Client on Job.ClientId = Client.ClientId where Job.JobStatus='R';
END-OF-DATA
      do
         JBID=$(echo $line |awk '{print $1}')
         SRV=$(echo $line |awk '{print $3}')
         esito=$(bconsole <<END-OF-DATA| grep "Files=" | sed "s/,//g"
status client=$SRV
END-OF-DATA)
         battuali=$(echo $esito | awk '{print $2}'|cut -d "=" -f 2)
         btot=$(cat ${chcpath}/bacula_estratto_estimate.txt | grep $SRV | awk '{print $4}')
         if [ "$btot" == "" ]; then
            echo "client doesn't exists in estimate data!"
         else
            perc=$(echo "scale=2; $battuali * 100 / $btot" | bc)
            adata=$(date '+%Y-%m-%d %H:%M:%S')
            durata=$($bindir/mysql -f <<END-OF-DATA | grep -v timediff
USE ${db_name}
select timediff('$adata',Job.StartTime) from Job where JobId='$JBID'
END-OF-DATA)
            echo "JobId= "$line "| Now: " $perc"% " $esito " (on tot.byte= "$btot")" $durata
         fi
      done
      ;;
esac

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users